create.sql

来自「Toy Universe网上玩具购物系统源代码」· SQL 代码 · 共 54 行

create database ToyData
go
use ToyData
go

create table UserLogin
(
cUserName char(20) constraint pkUserName primary key,
vPassword varchar(20)
)

go 
/*====================================*/
create table UserDetails
(
iUserId int constraint pkUserId primary key,
cUserName char(20) constraint fkUserName foreign key references userLogin(cUserName),
cName char(15) ,
cCredit char(20),
cSex char(5),
iAge int,
vCountry varchar(20),
vState varchar(20),
vEnjoy varchar(20)
)
go
/*====================================*/
create table Toys
(
cToyId char(6) constraint pkToyId primary key,
vToyName varchar(20),
vToyDescription varchar(50),
fToyRate float,
vToyImage varchar(20),
)
go
/*====================================*/
create table OrderDetails
(
iOrderNo int constraint pkOrderNo primary key,
cName char(15),
dDate datetime,
cToyBuy char(6) constraint fkToyBuy foreign key references toys(ctoyid),
cTraffic char(20),
cCasing char(10),
fMoneyTotal float,
cAddress char(50),
cWithWord char(50)
)
go
create index idxUserName on Userdetails(cusername)
go
alter table OrderDetails
add constraint defDate default getdate() for dDate