flower.sql

精美的画面。完善的功能

CREATE TABLE "CONSUMERLOGIN"
(
"CONSUMERID" VARCHAR2 (10),
"CONSUMERNAME" VARCHAR2 (50),
"CONSUMERPASSWORD" VARCHAR2 (20)
)
;
CREATE TABLE "OUTSTOCKLIST"
(
"OUTSTOCKID" VARCHAR2 (10),
"LISTID" VARCHAR2 (10),
"GOODSID" VARCHAR2 (10),
"OUTSTOCKPRICE" NUMERIC (10,2),
"OUTSTOCKNUM" NUMERIC (10)
)
;
CREATE TABLE "FLOWERTYPE"
(
"FLOWERTYPEID" VARCHAR2 (10),
"FLOWERTYPENAME" VARCHAR2 (20)
)
;
CREATE TABLE "STOCK"
(
"STOCKID" VARCHAR2 (10),
"GOODSID" VARCHAR2 (10),
"STOCKNUM" NUMERIC (10)
)
;
CREATE TABLE "ORDERMAIN"
(
"ORDERID" VARCHAR2 (10),
"CUSTOMERID" VARCHAR2 (10),
"ORDERDATE" DATE,
"TOTALMONEY" NUMERIC (10,2),
"PAYTYPE" VARCHAR2 (10),
"PAYFLAG" VARCHAR2 (2),
"FLAG" VARCHAR2 (10)
)
;
CREATE TABLE "OUTSTOCK"
(
"OUTSTOCKID" VARCHAR2 (10),
"OUTSTOCKDATE" DATE,
"HANDLEMAN" VARCHAR2 (20)
)
;
CREATE TABLE "ORDERLIST"
(
"ORDERID" VARCHAR2 (10),
"LISTID" VARCHAR2 (10),
"GOODSID" VARCHAR2 (10),
"NUM" NUMERIC (10),
"PRICE" NUMERIC (10,2)
)
;
CREATE TABLE "FLOWERINFO"
(
"FLOWERID" VARCHAR2 (10),
"FLOWERNAME" VARCHAR2 (20),
"FLOWERTYPEID" VARCHAR2 (10),
"FLOWERCOLOR" VARCHAR2 (10),
"FLOWERPHOTO" VARCHAR2 (50),
"FLOWERDESCRIPTION" VARCHAR2 (100)
)
;
CREATE TABLE "CONSUMERINFO"
(
"CONSUMERID" VARCHAR2 (10),
"REALNAME" VARCHAR2 (50),
"CONSUMERSEX" VARCHAR2 (4),
"IDENTITYCARD" VARCHAR2 (18),
"ADDRESS" VARCHAR2 (100),
"ZIPCODE" VARCHAR2 (6),
"EMAIL" VARCHAR2 (50),
"TEL" VARCHAR2 (15)
)
;
CREATE TABLE "INSTOCKLIST"
(
"INSTOCKID" VARCHAR2 (10),
"LISTID" VARCHAR2 (10),
"GOODSID" VARCHAR2 (10),
"INSTOCKPRICE" NUMERIC (10,2),
"INSTOCKNUM" NUMERIC (10)
)
;
CREATE TABLE "INSTOCK"
(
"INSTOCKID" VARCHAR2 (10),
"INSTOCKDATE" DATE,
"HANDLEMAN" VARCHAR2 (20)
)
;
CREATE TABLE "GOODSINFO"
(
"GOODSID" VARCHAR2 (10),
"FLOWERID" VARCHAR2 (10),
"RETAILPRICE" NUMERIC (10,2),
"COSTPRICE" NUMERIC (10,2),
"SUPID" VARCHAR2 (10),
"ATTR" VARCHAR2 (100)
)
;
CREATE TABLE "OPERATOR"
(
"OPERATORID" VARCHAR2 (10),
"OPERATORNAME" VARCHAR2 (20),
"OPERATORPASSWORD" VARCHAR2 (20),
"OPERATORTYPE" VARCHAR2 (20)
)
;
CREATE TABLE "PROVIDERINFO11"
(
"SUPID" VARCHAR2 (10),
"SUPNAME" VARCHAR2 (50),
"ADDRESS" VARCHAR2 (100),
"ZIPCODE" VARCHAR2 (6),
"EMAIL" VARCHAR2 (50),
"TEL" VARCHAR2 (15)
)
;