/* ================================================================================ 档案代号:coi_file 档案名称:进口加签异动单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table coi_file ( coi01 varchar2(16) NOT NULL, /*申请编号 */ coi02 date, /*加签日期 */ coi03 varchar2(20), /*手册编号 */ /*No:BUG-490398 */ coi04 number(20,6), /*加签总值 */ coi05 varchar2(10), /*海关代号 */ /*No:BUG-490398 */ coi06 varchar2(1), /*No Use */ coi07 varchar2(1), /*No Use */ coi08 varchar2(1), /*No Use */ coi09 varchar2(1), /*No Use */ coi10 varchar2(1), /*No Use */ coiconf varchar2(1), /*确认码 */ coiacti varchar2(1), /*资料有效码 */ coiuser varchar2(10), /*资料所有者 */ coigrup varchar2(10), /*资料所有群 */ coimodu varchar2(10), /*资料更改者 */ coidate date, /*最近修改日 */ coiud01 varchar2(255), /*自订栏位-Textedit */ coiud02 varchar2(40), /*自订栏位-文字 */ coiud03 varchar2(40), /*自订栏位-文字 */ coiud04 varchar2(40), /*自订栏位-文字 */ coiud05 varchar2(40), /*自订栏位-文字 */ coiud06 varchar2(40), /*自订栏位-文字 */ coiud07 number(15,3), /*自订栏位-数值 */ coiud08 number(15,3), /*自订栏位-数值 */ coiud09 number(15,3), /*自订栏位-数值 */ coiud10 number(10), /*自订栏位-整数 */ coiud11 number(10), /*自订栏位-整数 */ coiud12 number(10), /*自订栏位-整数 */ coiud13 date, /*自订栏位-日期 */ coiud14 date, /*自订栏位-日期 */ coiud15 date /*自订栏位-日期 */ ); create unique index coi_pk on coi_file (coi01); alter table coi_file add constraint coi_pk primary key (coi01) enable validate; grant select on coi_file to public; grant index on coi_file to public; grant update on coi_file to public; grant delete on coi_file to public; grant insert on coi_file to public; |