cw_sj.sql

来自「该系统为酒店日常管理提供了很大的方便」· SQL 代码 · 共 28 行

connect to s_hdxt;
create table cw_sj
(
        cwdwbm char(4) not null,
        txbm char(4) not null,
        ssnf numeric(4,0) not null,
        mon numeric(2,0) not null,
        ri numeric(2,0),
        pzh numeric(3,0) not null,
        lsh numeric(2,0) not null,
        fj numeric(3,0),
        zd char(10),
        fhr char(10),
        kmbm char(12),
        jje numeric(13,2),
        dje numeric(13,2),
        jy char(44),
        primary key
        (
                cwdwbm,
                txbm,
                ssnf,
                mon,
                pzh,
                lsh
        )
);