dada

Tables (3)

MEMBER (Untitled)

  • ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • NAME (Field) — VARCHAR2
  • PASSWORD (Field2) — VARCHAR2
  • CLASS_CODE (Field3) — VARCHAR2
  • JOIN_DATA (Field4) — date

ORDER (Untitled3)

  • ODR_NO (Key) — NUMBER(19,6) — Primary key — NOT NULL
  • ST_NO (Key3) — NUMBER(19.6) — Foreign key → STORE.ST_NO — NOT NULL
  • ODR_MAX (Field2) — NUMBER
  • ODR_MEMBERS (Field3) — ARRAYLIST<ID>
  • ODR_HOST (Key2) — VARCHAR2 — Foreign key → MEMBER.ID — NOT NULL

STORE (Untitled2)

  • ST_NO (Key) — NUMBER(19.6) — Primary key — NOT NULL
  • ST_NAME (Field) — VARCHAR2
  • ST_ADD (Field2) — VARCHAR2