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)