/* ================================================================================ 档案代号:oza_file 档案名称:航运基本代码档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oza_file ( oza01 varchar2(10) NOT NULL, /*航运代码 */ oza02 varchar2(80), /*航运说明 */ ozaacti varchar2(1), /*资料有效码 */ ozauser varchar2(10), /*资料所有者 */ ozagrup varchar2(10), /*资料所有部门 */ ozamodu varchar2(10), /*资料修改者 */ ozadate date /*最近修改日 */ ); create unique index oza_pk on oza_file (oza01); alter table oza_file add constraint oza_pk primary key (oza01) enable validate; grant select on oza_file to public; grant index on oza_file to public; grant update on oza_file to public; grant delete on oza_file to public; grant insert on oza_file to public; |