/* ================================================================================ 档案代号:ozc_file 档案名称:运输方式档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ozc_file ( ozc01 varchar2(1) NOT NULL, /*运输模式 */ ozc02 varchar2(80), /*运输方式说明 */ ozcacti varchar2(1), /*资料有效码 */ ozcuser varchar2(10), /*资料所有者 */ ozcgrup varchar2(10), /*资料所有群 */ ozcmodu varchar2(10), /*资料修改者 */ ozcdate date /*最近修改日 */ ); create unique index ozc_pk on ozc_file (ozc01); alter table ozc_file add constraint ozc_pk primary key (ozc01) enable validate; grant select on ozc_file to public; grant index on ozc_file to public; grant update on ozc_file to public; grant delete on ozc_file to public; grant insert on ozc_file to public; |