/* ================================================================================ 档案代号:oca_file 档案名称:客户分类档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oca_file ( oca01 varchar2(10) NOT NULL, /*客户分类码 */ oca02 varchar2(80), /*客户分类名称 */ oca03 varchar2(24), /*应收帐款科目编号 */ oca04 varchar2(24) /*应收帐款科目二 */ ); create unique index oca_pk on oca_file (oca01); alter table oca_file add constraint oca_pk primary key (oca01) enable validate; grant select on oca_file to public; grant index on oca_file to public; grant update on oca_file to public; grant delete on oca_file to public; grant insert on oca_file to public; |