table_customlist.sql

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

CREATE TABLE CustomerList (
	[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),
	[room_id] [int] DEFAULT(0) ,
	[bed_no] [int] DEFAULT (0) ,
	[bedstate_id] [smallint]  DEFAULT (1),
	[memo1] [varchar] (30)  DEFAULT (space(0)),
	[memo2] [varchar] (30)  DEFAULT (space(0)),
	[test] [datetime] default(getdate()) 
) ON [PRIMARY]
GO