【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了borrow.sql提供大家参考,希望对大家有所帮助!
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