/* ================================================================================ 档案代号:zod_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zod_file ( zod00 varchar2(10) NOT NULL, /*资料代码 */ zod01 varchar2(15) NOT NULL, /*档案代码 */ zod02 varchar2(30) NOT NULL, /*汇入序号 */ zod03 varchar2(30), /*汇入档名 */ zod04 date, /*汇入日期 */ zod05 varchar2(10), /*汇入者 */ zod06 number(10), /*汇入笔数 */ zod07 varchar2(30), /*旧单号(起) */ zod08 varchar2(30), /*旧单号(讫) */ zod09 varchar2(30), /*tp单号(起) */ zod10 varchar2(30), /*tp单号(讫) */ zod11 varchar2(1), /*已删除否 */ zod12 varchar2(1) /*已检核否 */ ); create unique index zod_pk on zod_file (zod00,zod01,zod02); alter table zod_file add constraint zod_pk primary key (zod00,zod01,zod02) enable validate; grant select on zod_file to public; grant index on zod_file to public; grant update on zod_file to public; grant delete on zod_file to public; grant insert on zod_file to public; |