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)