borrow.sql

来自「POWERBUILDER+SQLSERVER数据库应用系统开发与实力源码 图书」· SQL 代码 · 共 10 行

CREATE TABLE [dbo].[borrow] (
	[borrow_id] [int] IDENTITY (1, 1) NOT NULL ,
	[reader_code] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[book_code] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[borrow_date] [datetime] NOT NULL ,
	[return_date] [datetime] NULL ,
	[status] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO