table_customlist.sql

来自「一套宾馆管理系统」· SQL 代码 · 共 26 行

CREATE TABLE CustomerList (
        regist_id numeric(38) primary key identity(1,1),  --select numeric datatype to generate an identity column
	custom_name varchar (50)  NOT NULL ,
	custom_sexid tinyint NOT NULL ,
	custom_countryid smallint NOT NULL ,
	custom_nation smallint NULL  DEFAULT (0),
	custom_birth varchar (10)  DEFAULT (space(0)),
	custom_phone varchar (20)  DEFAULT (space(0)),
	custom_post varchar (20)  DEFAULT (space(0)),
	custom_address varchar (50)  DEFAULT (space(0)),
	custom_idno char (20)  DEFAULT (space(0)),
	image_path varchar (50)  DEFAULT (space(0)),
	regist_date datetime  DEFAULT (getdate()),
	leave_date datetime   DEFAULT (getdate() + 1),
        live_day  smallint default (1), -- days the client will leave and have leave
	room_id int DEFAULT(0) ,
	bed_no int DEFAULT (0) ,
	bedsta_id smallint  DEFAULT (1),
	memo1 varchar (30)  DEFAULT (space(0)),
	memo2 varchar (30)  DEFAULT (space(0)),
	test datetime default(getdate()) 
) 
GO