UMC-MJU_FIrst_week
Tables (8)
ALAM (Untitled7)
- Key — Primary key — NOT NULL
- ID (Key2) — Foreign key → Member.ID — NOT NULL
- ISALLOWED (Field) — ENUM
BOSS (Untitled5)
- ID (Key) — Primary key — NOT NULL
- NAME (Field)
FEEDBACK (Untitled6)
- ID (Key) — Primary key — NOT NULL
- MEMBER_ID (Key2) — Foreign key → Member.ID — NOT NULL
- TIME (Field)
- CONTENT (Field2)
MENU (Untitled8)
- ID (Key) — Primary key — NOT NULL
- STORE_ID (Key2) — Foreign key → STORE.ID — NOT NULL
- NAME (Field)
- PRICE (Field2)
MISSION (Untitled2)
- ID (Key2) — Primary key — NOT NULL
- MEMBER_ID (Key) — Foreign key → Member.ID — NOT NULL
- ISCOMPLETED (Field) — ENUM
- STATUS (Field2) — ENUM
- Field3
Member (Untitled)
- ID (Key) — Primary key — NOT NULL
- LOGIN_ID (Field2)
- PASSWORD (Field3)
- POINT (Field6)
- GENDER (Field) — ENUM
- BIRTH (Field4)
- ADRESS (Field5)
- MISSON_COUNT (Field7)
- LIKE_FOOD (Field8)
REVIEW (Untitled3)
- ID (Key2) — Primary key — NOT NULL
- MEMBER_ID (Key) — Foreign key → Member.ID — NOT NULL
- STORE_ID (Key3) — Foreign key → STORE.ID — NOT NULL
- CONTENT (Field)
STORE (Untitled4)
- ID (Key) — Primary key — NOT NULL
- BOSS_ID (Key2) — Foreign key → BOSS.ID — NOT NULL
- NAME (Field)
- CATEGORY (Field2)
- LOCATION (Field3)
- BOSS (Field4)