圖書館管理系統(tǒng)結(jié)構(gòu)圖(參考版)
2024-08-22 01:23本頁(yè)面
【正文】 Sql代碼如下： 創(chuàng)建數(shù)據(jù)庫(kù) CREATE DATABASE DateBook use DateBook Go 創(chuàng)建admin表 CREATE TABLE admin( admin_id int IDENTITY(1,1) NOT NULL, admin_name varchar(30) CONSTRAINT PK_adminInfo PRIMARY KEY CLUSTERED , create_date datetime NOT NULL, phone varchar(15) NOT NULL, varchar(80) NOT NULL, password varchar(30) NOT NULL) 創(chuàng)建Book表 CREATE TABLE Book( book_id int IDENTITY(1,1) CONSTRAINT PK_Book PRIMARY KEY CLUSTERED , isbn varchar(15) NOT NULL, title varchar(100) NOT NULL, author varchar(100) NOT NULL, publisher varchar(80) NOT NULL, price float NOT NULL, amount int NOT NULL, total_amount int NOT NULL,
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號(hào)-1