电子商城sql脚本（二）

xa_zbl

于 2011-08-17 10:49:02 发布

阅读量327

点赞数

文章标签：商城脚本 sql table null email

本文链接：https://blog.csdn.net/xa_zbl/article/details/6694160

版权

/*==============================================================*/
/* Table: tbl_customer                                        */
/*==============================================================*/
create table tbl_customer
(
   account            varchar(20)          not null,
   password           varchar(20),
   realName           varchar(20),
   integrate          int,
   idNo               varchar(20),
   gender             varchar(10),
   birthday           DATE,
   zipcode            varchar(10),
   Email              varchar(100),
   telephone          varchar(50),
   address            varchar(100),
   constraint PK_TBL_CUSTOMER primary key (account)
);

/*==============================================================*/
/* Table: tbl_goods                                           */
/*==============================================================*/
create table tbl_goods
(
   goodsCode          varchar(50)          not null,
   cateId             int,
   goodsName          varchar(50),
   buyingPrice        NUMBER,
   marketPrice        NUMBER,
   vipPrice           NUMBER,
   stockSum           int,
   goodsGeneral       varchar(500),
   goodsPic           varchar(200),
   remark             varchar(500),
   constraint PK_TBL_GOODS primary key (goodsCode)
);