/* ================================================================================ 档案代号:adw_file 档案名称:流通配销系统参数档--仓退单 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table adw_file ( adw01 varchar2(10) NOT NULL, /*拨入营运中心 */ adw02 varchar2(5), /*单别 */ adw03 varchar2(10), /*部门 */ adw04 varchar2(10), /*人员 */ adw05 varchar2(4), /*理由码 */ adw06 varchar2(1), /*No */ adw07 varchar2(1), /*No */ adw08 varchar2(1), /*No */ adw09 varchar2(1), /*No */ adwacti varchar2(1), /*资料有效码 */ adwuser varchar2(10), /*资料所有者 */ adwgrup varchar2(10), /*资料所有部门 */ adwmodu varchar2(10), /*资料修改者 */ adwdate date /*最近修改日 */ ); create unique index adw_pk on adw_file (adw01); alter table adw_file add constraint adw_pk primary key (adw01) enable validate; grant select on adw_file to public; grant index on adw_file to public; grant update on adw_file to public; grant delete on adw_file to public; grant insert on adw_file to public; |