cw_sj.sql

一个简单的酒店管理系统 用VB.net+SQL2000实现

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
        )
);