create.sql

Toy Universe网上玩具购物系统源代码

create database ToyData
go
use ToyData

go

create table UserDetails
(

vUserName varchar(15) constraint pkUserId primary key,

vPassword varchar(20),
vName varchar(15) ,
cCredit varchar(20),
cSex char(5),
iAge int,
vCountry varchar(20),
vState varchar(20),
vEnjoy varchar(20)
)
go
/*====================================*/
create table Toys
(
vToyId varchar(6) constraint pkToyId primary key,
vToyName varchar(40),
vToyDescription varchar(100),
fToyRate float,
vToyImage varchar(20),
)
go
/*====================================*/
create table OrderDetails
(

vUserName varchar(15),
dDate datetime,
vToyBuy varchar(150) ,
vTraffic varchar(20),
vCasing varchar(10),
fMoneyTotal float,
vAddress varchar(50),
vWithWord varchar(50)
)

go
alter table OrderDetails
add constraint defDate default getdate() for dDate

alter table orderdetails
add constraint fkUserName foreign key(vusername) references userdetails(vusername)