storage数据库设计

create database storage
go
use storage
create table easybuy_user
(
eu_user_id varchar(10) not null constraint PK_easybuy_user primary key,
eu_user_name varchar(20) not null,
eu_password varchar(20) not null,
eu_sex char(1) not null,
eu_birthday date,
eu_identity_code varchar(60),
eu_email varchar(80),
eu_mobile varchar(11),
eu_address varchar(200) not null,
eu_status numeric(6,0) not null check(eu_status in('普通用户','管理员')) default '普通用户'
)

create table easybuy_news
(
en_id numeric(10,0) not null constraint PK_easybuy_news primary key identity(1,1000),
en_title varchar(40) not null constraint UQ_easybuy_news_en_title unique(en_title),
en_content varchar(1000) not null,
en_create_time date not null default(getDate())
)

create table easybuy_comment
(
ec_id numeric(10,0) not null constraint PK_easybuy_comment primary key identity(1,1000),
ec_reply varchar(200),
ec_content varchar(200) not null,
ec_create_time date not null,
ec_reply_time date ,
ec_nick_name varchar(10) not null
)

create table easybuy_product
(
eq_id numeric(10,0) not null constraint PK_easybuy_product primary key identity(1,10000),
eq_name varchar(20) not null,
eq_description varchar(100) ,
eq_price numeric(10,2) not null,
eq_stock numeric(10,0) not null,
eqc_id numeric(10,0) not null,
eqc_child_id numeric(10,0),
eq_file_name varchar(200) not null
)

create table easybuy_product_category
(
eqc_id numeric(10,0) constraint PK_easybuy_product_category primary key identity(1,10000),
eqc_name varchar(20) not null,
eqc_parent_id numeric(10,0) not null
)

create table easybuy_order
(
eo_id numeric(10,0) constraint PK_easybuy_order primary key identity(1,10000),
eo_user_id numeric(10,0) not null,
eo_user_name varchar(20) not null,
eo_user_address varchar(200) not null,
eo_create_time date not null,
eo_cost numeric(10,2) not null,
eo_status numeric(6,0) not null check(eo_status in('下单','审核通过','配货','发送中','收获并确认')) default '下单',
eo_type numeric(6,0) not null check(eo_type in('货到付款','网上支付')) default '货到付款',
)

create table easybuy_order_detail
(
eod_id numeric(10,0) not null constraint PK_easybuy_order_detail primary key identity(1,10000),
eo_id numeric(10,0) not null,
ep_id numeric(10,0) not null,
eod_quantity numeric(10,0) not null,
eod_cost numeric(10,2) not null
)