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)