項(xiàng)目4網(wǎng)上書城數(shù)據(jù)庫表的管理(編輯修改稿)
2025-04-01 04:11 本頁面
【文章內(nèi)容簡介】 SMS411 2 PRIMARY KEY CID412 3413 411 412 413 PRIMARY KEY TSQL PRIMARY KEY CREATE TABLE Customers ( CID char (6) NOT NULL Constraint PK_CID PRIMARY KEY, CTrueName varchar(30) NOT NULL, Cpassword varchar(30) NOT NULL, CSex char(2) NOT NULL, CAddress varchar(50) NULL, CMobile varchar(11) NOT NULL, CEmail varchar(50) NULL, CRegisterDate datetime NOT NULL ) +OrderDetails OID GID PRIMARY KEY USE BookShop GO CREATE TABLE OrderDetails ( OID char (14) NOT NULL, GID char(6) NOT NULL, OdPrice float NOT NULL, OdNumber int NOT NULL, CONSTRAINT PK_OID_GID PRIMARY KEY(OID,GID) ) 414 FOREIGN KEY FOREIGN KEYFOREIGN KEY 1 …… 2 …… 3 —— —— —— —— …… TSQL CHECK CREATE TABLE Customers ( CID char (6) NOT NULL Constraint PK_CID PRIMARY KEY, CTrueName varchar(30) NOT NULL, Cpassword varchar(30) NOT NULL, CSex char(2) NOT NULL CHECK(CSex=39。 39。 or CSex=39。 39。), CAddress varchar(50) NULL, CMobile varchar(11) NOT NULL, CEmail varchar(50) NULL, CRegisterDate datetime NOT NULL ) UNIQUE CategoryCategory CaName UNIQUE CREATE TABLE Category ( CaID char(2) NOT NULL PRIMARY KEY, CaName varchar(20) NOT NULL, CaDeleted bit NOT NULL, CONSTRAINT UN_CaName UNIQUE(CaName) ) DEFAULT Customers CRegisterDate CREATE TABLE Customers ( CID char (6) NOT NULL Constraint PK_CID PRIMARY KEY, CTrueName varch
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1