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