/*
================================================================================
档案代号:zal_file
档案名称:设定SQL栏位资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zal_file
(
zal01       varchar2(80) NOT NULL,   /*查询单ID                               */
zal02       number(5) NOT NULL,      /*序号                                   */
zal03       varchar2(1) NOT NULL,    /*语言别                                 */
zal04       varchar2(80),            /*栏位代号                               */
zal05       varchar2(80),            /*显示名称                               */
zal06       varchar2(255),           /*备注                                   */
zal07       varchar2(1) NOT NULL,    /*客制码                                 */
zal08       number(10),              /*栏位宽度                               */
zal09       varchar2(1)              /*栏位属性                               */
);

create unique index zal_pk on zal_file (zal01,zal02,zal03,zal07);
alter table zal_file add  constraint zal_pk primary key  (zal01,zal02,zal03,zal07) enable validate;
grant select on zal_file to public;
grant index on zal_file to public;
grant update on zal_file to public;
grant delete on zal_file to public;
grant insert on zal_file to public;