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