/* ================================================================================ 档案代号:nab_file 档案名称:关系企业 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nab_file ( nab01 varchar2(8) NOT NULL, /*关系企业编号 */ nab02 varchar2(40), /*简称 */ nab03 varchar2(80) /*全名 */ ); create unique index nab_pk on nab_file (nab01); alter table nab_file add constraint nab_pk primary key (nab01) enable validate; grant select on nab_file to public; grant index on nab_file to public; grant update on nab_file to public; grant delete on nab_file to public; grant insert on nab_file to public; |