/* ================================================================================ 档案代号:apl_file 档案名称:杂项厂商全名地址档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apl_file ( apl01 varchar2(20) NOT NULL, /*杂项厂商 (MISC) 营利事业统一 */ /* (apl01 = apa21) */ apl02 varchar2(80), /*帐款对象全名一 */ /*帐款对象全名一 char(40)-> char(36) */ apl021 varchar2(80), /*帐款对象全名二 */ /*帐款对象全名二 add 01/12/27 */ apl03 varchar2(255) /*帐款对象地址 */ ); create unique index apl_pk on apl_file (apl01); alter table apl_file add constraint apl_pk primary key (apl01) enable validate; grant select on apl_file to public; grant index on apl_file to public; grant update on apl_file to public; grant delete on apl_file to public; grant insert on apl_file to public; |