200803

Tables (5)

BUCKET (Untitled3)

  • ID (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • USER_ID (Key2) — VARCHAR2(20) — Foreign key → USER.ID — NOT NULL
  • PRODUCT_NUM (Key3) — VARCHAR2(20) — Foreign key → PRODUCT.ID — NOT NULL
  • QT (Field3) — NUMBER(3)

CLAIM (Untitled5)

  • ID (Key2) — VARCHAR2(20) — Foreign key → ORDER.ID — NOT NULL
  • BUCKET_ID (Key22) — VARCHAR2(20) — Foreign key → ORDER.BUCKET_ID — NOT NULL
  • USER_ID (Key222) — VARCHAR2(20) — Foreign key → ORDER.USER_ID — NOT NULL
  • PRODUCT_NUM (Key3) — VARCHAR2(20) — Foreign key → ORDER.PRODUCT_NUM — NOT NULL
  • REQ_DATE (Field) — DATE
  • COMMENT (Field2) — VARCHAR2(100)
  • REQ_CASE (Field3) — VARCHAR2(20)

ORDER (Untitled4)

  • ID (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • BUCKET_ID (Key2) — VARCHAR2(20) — Foreign key → BUCKET.ID — NOT NULL
  • USER_ID (Key22) — VARCHAR2(20) — Foreign key → BUCKET.USER_ID — NOT NULL
  • PRODUCT_NUM (Key3) — VARCHAR2(20) — Foreign key → BUCKET.PRODUCT_NUM — NOT NULL
  • N_ADDRESS (Field2) — VARCHAR2(150)
  • CASH (Field3) — NUMBER(20)
  • REGDATE (Field4) — DATE

PRODUCT (Untitled2)

  • ID (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • NAME (Field) — VARCHAR2(60)
  • PRICE (Field2) — NUMBER(10)
  • STOCK (Field3) — NUMBER(3)
  • CATEGORY (Field4) — VARCHAR2(20)

USER (Untitled)

  • ID (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • PWD (Field) — VARCHAR2(20)
  • NAME (Field2) — VARCHAR2(20)
  • PERSONAL_NUMBER (Field3) — VARCHAR2(14)
  • PHONE_NUMBER (Field4) — VARCHAR2(13)
  • ADDRESS (Field5) — VARCHAR2(150)
  • EMAIL (Field6) — VARCHAR2(30)