/* ================================================================================ 档案代号:ozg_file 档案名称:其他运输基本代码档 档案目的:记录其他运输基本资料 上游档案: 下游档案: ============.========================.========================================== */ create table ozg_file ( ozg01 varchar2(10) NOT NULL, ozg02 varchar2(60), ozgacti varchar2(1), /*资料有效码 */ ozguser varchar2(10), ozggrup varchar2(6), ozgmodu varchar2(10), ozgdate date ); create unique index ozg_pk on ozg_file (ozg01); alter table ozg_file add constraint ozg_pk primary key (ozg01) enable validate; grant select on ozg_file to public; grant index on ozg_file to public; grant update on ozg_file to public; grant delete on ozg_file to public; grant insert on ozg_file to public; |