03(maven+SSH)网上商城项目实战之数据库设计(PDM)
来源:互联网 发布:sopcast网络电视直播 编辑:程序博客网 时间:2024/05/21 07:56
数据库物理模型:
数据库SQL:
create
table
consignee_management
(
consignee_id
int
not
null
auto_increment,
user_id
int
,
consignee_name
varchar
(50),
consignee_address
varchar
(1000),
consignee_code
varchar
(10),
consignee_phone
varchar
(11),
primary
key
(consignee_id)
);
create
table
goods_info
(
goods_id
int
not
null
auto_increment,
goods_name
varchar
(200),
goods_price
double
,
goods_url
varchar
(1000),
goods_desc
varchar
(2000),
goods_state
varchar
(10) comment
'1 上架 2 下架'
,
primary
key
(goods_id)
);
create
table
order_detail
(
order_detail_id
int
not
null
auto_increment,
order_id
int
,
goods_id
int
,
orde_number
int
,
order_price
double
,
primary
key
(order_detail_id)
);
create
table
order_management
(
order_id
int
not
null
auto_increment,
user_id
int
,
consignee_id
int
,
order_time datetime,
order_total
double
,
order_state
varchar
(10),
primary
key
(order_id)
);
create
table
user_info
(
user_id
int
not
null
auto_increment,
user_name
varchar
(50),
user_sex
varchar
(10),
user_phone
varchar
(11),
user_pw
varchar
(100),
user_type
varchar
(5) comment
'1 普通用户 2 管理员'
,
primary
key
(user_id)
);
alter
table
consignee_management
add
constraint
FK_Reference_1
foreign
key
(user_id)
references
user_info (user_id)
on
delete
restrict
on
update
restrict
;
alter
table
order_detail
add
constraint
FK_Reference_4
foreign
key
(order_id)
references
order_management (order_id)
on
delete
restrict
on
update
restrict
;
alter
table
order_detail
add
constraint
FK_Reference_5
foreign
key
(goods_id)
references
goods_info (goods_id)
on
delete
restrict
on
update
restrict
;
alter
table
order_management
add
constraint
FK_Reference_2
foreign
key
(user_id)
references
user_info (user_id)
on
delete
restrict
on
update
restrict
;
alter
table
order_management
add
constraint
FK_Reference_3
foreign
key
(consignee_id)
references
consignee_management (consignee_id)
on
delete
restrict
on
update
restrict
;
0 0
- 03(maven+SSH)网上商城项目实战之数据库设计(PDM)
- 03(maven+SSH)网上商城项目实战之数据库设计(PMD)
- 01 (maven+SSH)网上商城项目实战之项目简介
- 01 (maven+SSH)网上商城项目实战之项目简介
- 02 (maven+SSH)网上商城项目实战之需求分析
- 02 (maven+SSH)网上商城项目实战之需求分析
- 06(maven+SSH)网上商城项目实战之springmvc配置
- 04(maven+SSH)网上商城项目实战之maven热部署
- 08(maven+SSH)网上商城项目实战之使用nexus搭建maven私有服务器
- 05(maven+SSH)网上商城项目实战之spring mybatis整合
- 07(maven+SSH)网上商城项目实战之springmvc乱码问题
- 11(maven+SSH)网上商城项目实战之Freemarker 页面静态化
- 10(maven+SSH)网上商城项目实战之页面缓存OSCache
- 09(maven+SSH)网上商城项目实战之使用jersey实现应用服务器和图片服务器分离
- 网上商城项目实战之maven热部署
- 【SSH网上商城项目实战14】商城首页UI的设计
- 【SSH网上商城项目实战14】商城首页UI的设计
- 【SSH网上商城项目实战14】商城首页UI的设计
- iOS面试题集锦
- 坑爹的Spring数据源——自动提交事务
- 3G Remote Alarm Camera
- 初识backbone之HelloWord
- 2 BLE介绍
- 03(maven+SSH)网上商城项目实战之数据库设计(PDM)
- iso9660重新回顾
- Windows 系统错误193: 0xc1
- SQl语句收藏
- 相机权限
- IOS-26-自定义Item控件在横竖屏运行时大小位置紊乱
- mybatis学习
- monkey和monkeyrunner
- 关于首次安装app时出现按home键再点击图标不能回到预期界面的问题