/* ================================================================================ 档案代号:bzp_file 档案名称:保税机器设备异动资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bzp_file ( bzp01 varchar2(16) NOT NULL, /*单据单号 */ bzp02 number(5) NOT NULL, /*单据项次 */ bzp03 date, /*异动日期 */ bzp04 varchar2(1), /*性质 */ /*A.外送 B.收回 C.报废 D.除帐 */ bzp05 number(5), /*状态 */ /*外送:-1, 收回:1, 报废:-1, 除帐:-1 */ bzp06 varchar2(20), /*机器设备编号 */ bzp07 number(5), /*序号 */ bzp08 number(15,3), /*异动数量 */ bzp09 date, /*确认日期 */ bzp10 varchar2(1) /*No Use */ ); create unique index bzp_pk on bzp_file (bzp01,bzp02); alter table bzp_file add constraint bzp_pk primary key (bzp01,bzp02) enable validate; grant select on bzp_file to public; grant index on bzp_file to public; grant update on bzp_file to public; grant delete on bzp_file to public; grant insert on bzp_file to public; |