/* ================================================================================ 档案代号:gcn_file 档案名称:udm_tree资料查询类别设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gcn_file ( gcn01 varchar2(10) NOT NULL, /*类别代码 */ gcn02 varchar2(1) NOT NULL, /*语言别 */ gcn03 varchar2(80), /*类别名称 */ gcn04 varchar2(1000), /*备注 */ gcn05 varchar2(1), /*no use */ gcn06 varchar2(1), /*no use */ gcn07 varchar2(1), /*no use */ gcn08 varchar2(1) /*no use */ ); create unique index gcn_pk on gcn_file (gcn01,gcn02); alter table gcn_file add constraint gcn_pk primary key (gcn01,gcn02) enable validate; grant select on gcn_file to public; grant index on gcn_file to public; grant update on gcn_file to public; grant delete on gcn_file to public; grant insert on gcn_file to public; |