csos.sql

一个PB源程序代码

%% ============================================================
%%   Database name:  MODEL_18                                  
%%   DBMS name:      Sybase SQL Anywhere                       
%%   Created on:     103-3-17  9:54                            
%% ============================================================

%% ============================================================
%%   Table: T_USER                                             
%% ============================================================
create table T_USER
(
    YHM      varchar(12)           not null,
    MM       varchar(12)           not null,
    QX       char(1)               not null
        default '3'
        check (
            QX in ('1','2','3')),
    primary key (YHM)
);

%% ============================================================
%%   Table: T_MZBM                                             
%% ============================================================
create table T_MZBM
(
    MZBH     char(1)               not null,
    MZNR     varchar(20)           not null,
    primary key (MZBH)
);

%% ============================================================
%%   Table: T_YJMS                                             
%% ============================================================
create table T_YJMS
(
    YJBH     char(1)               not null,
    YJNR     varchar(30)           not null,
    primary key (YJBH)
);

%% ============================================================
%%   Table: T_ZYMS                                             
%% ============================================================
create table T_ZYMS
(
    ZYBH     integer               not null,
    ZYNR     varchar(30)           not null,
    primary key (ZYBH)
);

%% ============================================================
%%   Table: T_JCJB                                             
%% ============================================================
create table T_JCJB
(
    JCJBBH   char(1)               not null,
    JCJBNR   varchar(300)          not null,
    primary key (JCJBBH)
);

%% ============================================================
%%   Table: T_XB                                               
%% ============================================================
create table T_XB
(
    XBBH     char(1)               not null,
    YJBH     char(1)                       ,
    XBNR     varchar(20)           not null,
    primary key (XBBH)
);

%% ============================================================
%%   Table: T_XSB                                              
%% ============================================================
create table T_XSB
(
    XH       varchar(10)           not null,
    XBBH     char(1)                       ,
    YJBH     char(1)                       ,
    ZYBH     integer                       ,
    MZBH     char(1)                       ,
    XM       varchar(12)           not null,
    XB       char(1)               not null
        check (
            XB in ('1','2')),
    CSNY     date                  not null,
    JG       varchar(20)           not null,
    JKZK     char(1)               not null
        check (
            JKZK in ('1','2','3')),
    ZZMM     varchar(20)                   ,
    SYLB     char(1)               not null
        check (
            SYLB in ('1','2','3')),
    RXSJ     date                          ,
    XZ       char(1)               not null
        default '4',
    DSZK     varchar(20)                   
        check (
            DSZK is null or (DSZK in ('1','2','3','4','5','6'))),
    SFZ_ID   varchar(20)                   ,
    BJ       char(1)                       ,
    primary key (XH)
);

%% ============================================================
%%   Table: T_SHGX                                             
%% ============================================================
create table T_SHGX
(
    XH       varchar(10)           not null,
    F_XM     varchar(12)                   ,
    F_GX     varchar(20)                   ,
    F_ZZMM   varchar(20)                   ,
    F_ZY     varchar(30)                   ,
    F_ZZ     varchar(100)                  ,
    F_LXFS   varchar(200)                  ,
    SHGX_ID  integer               not null,
    primary key (SHGX_ID)
);

%% ============================================================
%%   Table: T_GRJL                                             
%% ============================================================
create table T_GRJL
(
    XH       varchar(10)           not null,
    SJ       varchar(100)                  ,
    DD       varchar(100)                  ,
    HZJL     varchar(300)                  ,
    GRJL_ID  integer               not null,
    primary key (GRJL_ID)
);

%% ============================================================
%%   Table: T_CQTJ                                             
%% ============================================================
create table T_CQTJ
(
    XH       varchar(10)           not null,
    CQ_ID    integer               not null,
    CQZT     char(1)                       
        default '1'
        check (
            CQZT is null or (CQZT in ('1','2','3'))),
    CQSJ     date                          ,
    SFCQ     char(1)                       
        default '1'
        check (
            SFCQ is null or (SFCQ in ('1','2'))),
    CQJTMC   varchar(100)                  ,
    QQYY     varchar(300)                  ,
    primary key (CQ_ID)
);

%% ============================================================
%%   Index: T_CQTJ_PK                                          
%% ============================================================
create unique index T_CQTJ_PK on T_CQTJ (XH asc, CQ_ID asc);

%% ============================================================
%%   Table: T_JCQK                                             
%% ============================================================
create table T_JCQK
(
    XH       varchar(10)           not null,
    JCJBBH   char(1)               not null,
    JC_ID    integer               not null,
    JC       char(1)                       
        check (
            JC is null or (JC in ('1','0'))),
    HZJC     varchar(100)                  ,
    JCSJ     date                          ,
    JCYY     varchar(300)                  ,
    JCMS     varchar(300)                  ,
    primary key (JC_ID)
);

%% ============================================================
%%   Index: T_JCQK_PK                                          
%% ============================================================
create unique index T_JCQK_PK on T_JCQK (XH asc, JCJBBH asc, JC_ID asc);

alter table T_XB
    add foreign key FK_T_XB_RELATION__T_YJMS (YJBH)
       references T_YJMS (YJBH) on update restrict on delete restrict;

alter table T_XSB
    add foreign key FK_T_XSB_RELATION__T_XB (XBBH)
       references T_XB (XBBH) on update restrict on delete restrict;

alter table T_XSB
    add foreign key FK_T_XSB_RELATION__T_YJMS (YJBH)
       references T_YJMS (YJBH) on update restrict on delete restrict;

alter table T_XSB
    add foreign key FK_T_XSB_RELATION__T_ZYMS (ZYBH)
       references T_ZYMS (ZYBH) on update restrict on delete restrict;

alter table T_XSB
    add foreign key FK_T_XSB_RELATION__T_MZBM (MZBH)
       references T_MZBM (MZBH) on update restrict on delete restrict;

alter table T_SHGX
    add foreign key FK_T_SHGX_RELATION__T_XSB (XH)
       references T_XSB (XH) on update restrict on delete restrict;

alter table T_GRJL
    add foreign key FK_T_GRJL_RELATION__T_XSB (XH)
       references T_XSB (XH) on update restrict on delete restrict;

alter table T_CQTJ
    add foreign key FK_T_CQTJ_RELATION__T_XSB (XH)
       references T_XSB (XH) on update restrict on delete restrict;

alter table T_JCQK
    add foreign key FK_T_JCQK_RELATION__T_JCJB (JCJBBH)
       references T_JCJB (JCJBBH) on update restrict on delete restrict;

alter table T_JCQK
    add foreign key FK_T_JCQK_RELATION__T_XSB (XH)
       references T_XSB (XH) on update restrict on delete restrict;