/* ================================================================================ 档案代号:adx_file 档案名称:流通配销系统参数档-销退单 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table adx_file ( adx01 varchar2(10) NOT NULL, /*拨出营运中心 */ adx02 varchar2(5), /*单别 */ adx03 varchar2(1), /*销退处理方式 */ adx04 varchar2(1), /*No */ adx05 varchar2(1), /*No */ adx06 varchar2(1), /*No */ adx07 varchar2(1), /*No */ adxacti varchar2(1), /*资料有效码 */ adxuser varchar2(10), /*资料所有者 */ adxgrup varchar2(10), /*资料所有部门 */ adxmodu varchar2(10), /*资料修改者 */ adxdate date /*最近修改日 */ ); create unique index adx_pk on adx_file (adx01); alter table adx_file add constraint adx_pk primary key (adx01) enable validate; grant select on adx_file to public; grant index on adx_file to public; grant update on adx_file to public; grant delete on adx_file to public; grant insert on adx_file to public; |