UMC7th-Chapter1

Tables (17)

alarm (Untitled9)

  • Key2 — Primary key — NOT NULL
  • missionId (Key) — Foreign key → mission.Key — NOT NULL
  • content (Field)
  • date (Field2)
  • confirmation_status (Field4)
  • alarmType (enum)

category (Untitled10)

  • Key — Primary key — NOT NULL
  • type (Field)

category-store (Untitled15)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → category.Key — NOT NULL
  • Key (Key3) — Foreign key → store.Key — NOT NULL

image (Untitled7)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → review.Key — NOT NULL

image (CopyOfUntitled7)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → store.Key — NOT NULL

image (Untitled8)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → report.Key — NOT NULL

member (Untitled)

  • Key — Primary key — NOT NULL
  • name (Field)
  • birthday (Field2)
  • gender (Field3)
  • address (Field4)
  • level (Field5)
  • point (Field6)
  • email (Field7)
  • favoriteFoodList (Field8)
  • nickname (Field9)
  • profileImg (Field10)
  • phoneNumber (Field11)
  • point (Field12)

member-agree (Untitled16)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → member.Key — NOT NULL
  • Key (Key3) — Foreign key → terms.Key — NOT NULL

member-alarm (Untitled13)

  • Key — Primary key — NOT NULL
  • memberId (Key2) — Foreign key → member.Key — NOT NULL
  • alarmId (Key22) — Foreign key → alarm.Key2 — NOT NULL

member-mission (Untitled4)

  • Key — Foreign key → member.Key — NOT NULL
  • Key (Key2) — Foreign key → mission.Key — NOT NULL
  • status (Field)
  • hostNumber (Field2)
  • Field3

memberPrefer (Untitled14)

  • Key — Foreign key → member.Key — NOT NULL
  • Key (Key2) — Foreign key → category.Key — NOT NULL

mission (Untitled3)

  • Key — Primary key — NOT NULL
  • title (Field)
  • point (Field2)
  • bound (Field3)
  • deadline (Field4)
  • category (Field5)
  • storeId (Key2) — Foreign key → store.Key — NOT NULL
  • reviewId (Key3) — Foreign key → review.Key — NOT NULL

region (Untitled11)

  • Key — Primary key — NOT NULL
  • name (Field)
  • status (Field2)
  • count (Field3)
  • memberId (Key2) — Foreign key → member.Key — NOT NULL

report (Untitled6)

  • Key — Primary key — NOT NULL
  • title (Field)
  • type (Field2)
  • content (Field3)
  • status (Field4)
  • answer (Field5)
  • memberId (Key2) — Foreign key → member.Key — NOT NULL

review (Untitled2)

  • Key — Primary key — NOT NULL
  • content (Field)
  • star (Field2)
  • comment (Field3)
  • memberId (Key2) — Foreign key → member.Key — NOT NULL
  • storeId (Key3) — Foreign key → store.Key — NOT NULL

store (Untitled5)

  • Key — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • category (Field3)
  • star (Field4)
  • time (Field5)

terms (Untitled12)

  • Key — Primary key — NOT NULL
  • content (Field)
  • type (Field2)