s
Tables (4)
Untitled (MEMBER)
- Key (USERID) — VARCHAR2(20) — Primary key — NOT NULL
- Field (USERPWD) — VARCHAR2(20)
- Field2 (USERNAME) — VARCHAR2(20)
- Field3 (USERGENDER) — VARCHAR2(20)
- Field4 (USERBIRTH) — DATE
- Field5 (USERADDR) — VARCHAR2(1000)
- Field6 (USEREMAIL) — VARCHAR2(50)
- Field (USERTEL) — CHAR(11)
- Field (REGISTRATION) — NUMBER(1)
Untitled (PRODUCT)
- Key (PRODUCTNUM) — NUMBER(10) — Primary key — NOT NULL
- Field (PRODUCTNAME) — VARCHAR2(50)
- Field (PRODUCTPRICE) — NUMBER
- Field (PRODUCTCATEGORY) — VARCHAR2(20)
- Field (SAVEFILENAME) — VARCHAR2(2000)
- Field (ORIGINALFILENAME) — VARCHAR2(2000)
- Field (PRODUCTCOLOR) — VARCHAR2(100)
- Field (PRODUCTSIZE) — VARCHAR2(100)
- Field (DESCRIPTION) — VARCHAR2(1000)
Untitled (ORDERS)
- Key (ORDERNUM) — NUMBER — Primary key — NOT NULL
- Key (USERID) — VARCHAR2(20) — Foreign key → Untitled.Key — NOT NULL
- Key (PRODUCTNUM) — NUMBER(10) — Foreign key → Untitled.Key — NOT NULL
- Field (ORDERQUANTITY) — NUMBER(5)
- Field (ORDERCOLOR) — VARCHAR2(20)
- Field (ORDERSIZE) — VARCHAR2(20)
- Field (UPDATEDATE) — DATE
- Field (PROGRESS) — VARCHAR2(20)
Untitled (DELIVERY)
- Key (DELIVERYNUM) — NUMBER — Primary key — NOT NULL
- Key (USERID) — VARCHAR2(20) — Foreign key → Untitled.Key — NOT NULL
- Field (ORDERNUM) — VARCHAR2(100)
- Field (DELIVERYNAME) — VARCHAR2(20)
- Field (DELIVERYTEL) — CHAR(11)
- Field (DELIVERYADDR) — VARCHAR2(1000)
- Field (DELIVERYEMAIL) — VARCHAR2(50)
- Field (TOTALPRICE) — NUMBER
- Field