/*
================================================================================
档案代号: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;