/* ================================================================================ 档案代号:gbk_file 档案名称:udm_tree流程图资料 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gbk_file ( gbk01 varchar2(30) NOT NULL, /*分类代号 */ gbk02 number(5) NOT NULL, /*顺序 */ gbk03 varchar2(80), /*下层目录 */ gbk04 varchar2(1) NOT NULL, /*语言别 */ gbk05 varchar2(255), /*Button名称 */ gbk06 varchar2(255) /*Button的隐藏叙述 */ ); create unique index gbk_pk on gbk_file (gbk01,gbk02,gbk04); alter table gbk_file add constraint gbk_pk primary key (gbk01,gbk02,gbk04) enable validate; grant select on gbk_file to public; grant index on gbk_file to public; grant update on gbk_file to public; grant delete on gbk_file to public; grant insert on gbk_file to public; |