/* ================================================================================ 档案代号:ads_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ads_file ( ads01 varchar2(16) NOT NULL, /*库存调整档 */ ads02 date, /*异动日期 */ ads03 varchar2(10), /*客户编号 */ ads04 varchar2(10), /*员工编号 */ ads05 varchar2(10), /*部门编号 */ ads06 varchar2(255), /*备注 */ ads07 varchar2(1), /*状况码 */ adsmksg varchar2(1), /*是否签核 */ adssign varchar2(4), /*签核等级 */ adsdays number(5), /*签核完成天数 */ adsprit number(5), /*签核有先等级 */ adssseq number(5), /*已签核顺序 */ adssmax number(5), /*应签核顺序 */ adsconf varchar2(1), /*确认 */ adspost varchar2(1), /*过帐否 */ adsprsw number(5), /*列印次数 */ adsacti varchar2(1), /*有效否 */ adsuser varchar2(10), /*建档人员 */ adsgrup varchar2(10), /*建档部门 */ adsmodu varchar2(10), /*最后修改人员 */ adsdate date /*最后修改日期 */ ); create unique index ads_pk on ads_file (ads01); alter table ads_file add constraint ads_pk primary key (ads01) enable validate; grant select on ads_file to public; grant index on ads_file to public; grant update on ads_file to public; grant delete on ads_file to public; grant insert on ads_file to public; |