/* ================================================================================ 档案代号:bze_file 档案名称:保税机器设备盘点底稿单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bze_file ( bze01 varchar2(10) NOT NULL, /*盘点编号 */ bze02 date, /*盘点日期 */ bze03 varchar2(255), /*备注 */ bze04 number(5), /*盘点年度 */ bze05 varchar2(10), /*确认人 */ bze06 date, /*确认日期 */ bze07 varchar2(1), /*确认码 */ /*(Y/N/X) */ bze08 varchar2(1), /*No Use */ bze09 varchar2(1), /*No Use */ bze10 varchar2(1), /*No Use */ bzeacti varchar2(1), /*资料有效码 */ bzeuser varchar2(10), /*资料所有者 */ bzegrup varchar2(10), /*资料所有部门 */ bzemodu varchar2(10), /*资料修改者 */ bzedate date /*最近修改日 */ ); create unique index bze_pk on bze_file (bze01); alter table bze_file add constraint bze_pk primary key (bze01) enable validate; grant select on bze_file to public; grant index on bze_file to public; grant update on bze_file to public; grant delete on bze_file to public; grant insert on bze_file to public; |