/*
================================================================================
档案代号:gcm_file
档案名称:udm_tree资料查询设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gcm_file
(
gcm01       number(5) NOT NULL,      /*项次                                   */
gcm02       varchar2(10),            /*类别代码                               */
gcm03       varchar2(15),            /*表格代码                               */
gcm04       varchar2(20),            /*栏位代码                               */
gcm05       varchar2(20),            /*对应程式代码                           */
gcm06       varchar2(20),            /*key1                                   */
gcm07       varchar2(20),            /*key2                                   */
gcm08       varchar2(20),            /*key3                                   */
gcm09       varchar2(20),            /*key4                                   */
gcm10       varchar2(20),            /*key5                                   */
gcm11       varchar2(20),            /*对应的程式代码                         */
gcm12       varchar2(1),             /*no use                                 */
gcm13       varchar2(1)              /*no use                                 */
);

create unique index gcm_pk on gcm_file (gcm01);
alter table gcm_file add  constraint gcm_pk primary key  (gcm01) enable validate;
grant select on gcm_file to public;
grant index on gcm_file to public;
grant update on gcm_file to public;
grant delete on gcm_file to public;
grant insert on gcm_file to public;