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