【書店號】【nvarchar】(6)整理中文_ PRC _ CI _ as不為空,
[商店名稱] [nvarchar] (30)整理中文_ PRC _ ci _ as不為空,
[電話] [CHAR] (8)整理中文_ PRC _ CI _ as null,
[address] [char] (40)整理中文_ PRC _ ci _ as null,
[郵政編碼] [CHAR] (6)整理中文_ PRC _ CI _ as null
)開[主]
去
創建表[dbo]。[書桌](
【書號】【nvarchar】(6)整理中文_ PRC _ ci _ as not null,
[Title] [nvarchar] (30)整理中文_ PRC _ CI _ as not null,
[第壹作者] [char] (10)整理中文_ PRC _ CI _ as not null,
[發布日期] [smalldatetime] NULL,
[價格][數字](4,1) NULL
)開[主]
去
創建表[dbo]。[圖書銷售表](
【書號】【nvarchar】(6)整理中文_ PRC _ ci _ as not null,
【書店號】【nvarchar】(6)整理中文_ PRC _ CI _ as不為空,
[銷售日期] [smalldatetime]不為空,
[銷售數量] [smallint]空
)開[主]
去
更改表。[書店桌子]帶NOCHECK ADD
約束[PK_ bookstore表]主鍵聚集
(
[書店號碼]
)開[主]
去
更改表。[圖書表]帶NOCHECK ADD
約束[PK_ book表]主鍵聚集
(
[書號]
)開[主]
去
更改表。[圖書銷售表]帶NOCHECK ADD
約束[PK_圖書銷售表]主鍵聚集
(
【書號】,
【書店號】,
[銷售日期]
)開[主]
去