电子商城sql脚本（二）

/*==============================================================*/
/* 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)
);