drop table GOODS cascade constraints;
/*==============================================================*/
/* Table: GOODS                                                 */
/*==============================================================*/
create table GOODS 
(
 ID                   NUMBER               not null,
 NAME                 VARCHAR2(128)        not null,
 DESCRIPTION          VARCHAR2(512),
 TOTAL_AMOUNT         NUMBER(18)           not null,
 QUANTITY             NUMBER               not null,
 VERSION              NUMBER(18)           default 1,
 GMT_UPDATE           DATE                 not null,
 GMT_CREATE           DATE                 not null,
 constraint PK_GOODS primary key (ID)
);
comment on table GOODS is
'商品表';
comment on column GOODS.ID is
'主键，自增';
comment on column GOODS.NAME is
'商品名称';
comment on column GOODS.DESCRIPTION is
'商品描述';
comment on column GOODS.TOTAL_AMOUNT is
'商品价格';
comment on column GOODS.QUANTITY is
'库存数量';
comment on column GOODS.VERSION is
'版本号,用于实现乐观锁';
comment on column GOODS.GMT_UPDATE is
'修改时间';
comment on column GOODS.GMT_CREATE is
'创建时间';

drop table ORDERS cascade constraints;
/*==============================================================*/
/* Table: ORDERS                                                */
/*==============================================================*/
create table ORDERS 
(
 ID                   NUMBER               not null,
 ORDER_NO             VARCHAR2(64)         not null,
 GOODS_ID             NUMBER               not null,
 GOODS_NAME           VARCHAR2(128)        not null,
 BUYER_ID             VARCHAR2(64)         not null,
 TRADE_STATUS         VARCHAR2(32)         not null,
 TOTAL_AMOUNT         NUMBER(18)           not null,
 GMT_UPDATE           DATE                 not null,
 GMT_CREATE           DATE,
 constraint PK_ORDERS primary key (ID)
);
comment on table ORDERS is
'订单表';
comment on column ORDERS.ID is
'主键，自增';
comment on column ORDERS.ORDER_NO is
'订单编号';
comment on column ORDERS.GOODS_ID is
'外键，商品编号';
comment on column ORDERS.GOODS_NAME is
'商品名称';
comment on column ORDERS.BUYER_ID is
'购买人ID';
comment on column ORDERS.TRADE_STATUS is
'交易状态。success：交易成功；failed：交易失败；busy：系统繁忙';
comment on column ORDERS.TOTAL_AMOUNT is
'商品总价';
comment on column ORDERS.GMT_UPDATE is
'修改时间';
comment on column ORDERS.GMT_CREATE is
'创建时间';