test5
Tables (3)
BUYER
- BUYER_ID — VARCHAR(50) — Foreign key → MEM.MEM_ID — NOT NULL
- BUYER_NAME — VARCHAR(100) — NOT NULL
- BUYER_MAIL — VARCHAR(100) — NOT NULL
- BUYER_ADDR — VARCHAR(100) — NOT NULL
- BUYER_HP — VARCHAR(100) — NOT NULL
- BUYER_COMPANY — VARCHAR(100) — NOT NULL
- BUYER_REG — VARCHAR(100) — NOT NULL
CUSTOM
- CUSTOM_ID — VARCHAR(50) — Foreign key → MEM.MEM_ID — NOT NULL
- CUSTOM_NAME — VARCHAR(50) — NOT NULL
- CUSTOM_MAIL — VARCHAR(100) — NOT NULL
- CUSTOM_ADDR — VARCHAR(100) — NOT NULL
- CUSTOM_BIR — DATE — NOT NULL
- CUSTOM_GENDER — VARCHAR(10) — NOT NULL
- CUSTOM_HP — VARCHAR(50) — NOT NULL
- CUSTOM_GRADE — VARCHAR(50) — NOT NULL
- CUSTOM_POINT — NUMBER — NOT NULL
- CUSTOM_IMAGE — VARCHAR(100)
MEM
- MEM_ID — VARCHAR(50) — Primary key — NOT NULL
- MEM_GRANTNO — NUMBER — NOT NULL
- MEM_PASS — VARCHAR(100) — NOT NULL