[sql]小东商城数据库表格创建

-- 用户表
drop table xd_userk;
create table xd_user(
id varchar2(100) primary key,
nickname varchar2(20),
avatar varchar2(100),
phone varchar2(12),
email varchar2(20),
password varchar2(100),
name varchar2(12),
birth date,
create_time date,
addr varchar2(100)
);

-- 分类表
create table xd_categroy(
id varchar2(100) primary key,
name varchar2(12)
);

-- 商品表
drop table xd_commodity;
create table xd_commodity(
id varchar2(100) primary key,
name varchar2(12),
title varchar2(100),
price number,
categroy_id varchar2(100),
state varchar2(8),
commnet_count int,
create_time timestamp
);

-- 商品图片表
create table xd_commodity_pic(
id varchar2(100) primary key,
commodity_id varchar2(100),
img_src varchar2(500),
state varchar2(8)
);

-- 订单
create table xd_order(
id varchar2(100) primary key,
user_id varchar2(100),
commodity_id varchar2(100),
count int,
create_time timestamp,
state varchar2(8)
);

-- 评论
create table xd_commnet(
id varchar2(100) primary key,
user_id varchar2(100),
content varchar2(1000),
grade varchar2(8),
create_time timestamp,
thumb_up int
);