UMC_0_week
Tables (11)
event
- id (Key) — Primary key — NOT NULL
- start_date (Field)
- end_date (Field2)
- title (Field3)
- comment (Field4)
food
- id (Key) — Primary key — NOT NULL
- food_type (Field)
member
- id (Key) — Primary key — NOT NULL
- name (Field)
- gender (Field2)
- birth (Field3)
- adress (Field4)
- kakao (Field5)
- naver (Field6)
- apple (Field7)
- google (Field8)
- inactive_date (Field9)
- created_at (Field10)
- updated_at (Field11)
- mission_count (Field12)
- adress_detail (Field13)
- have_point (Field14)
- event_notification (Field15)
- review_notification (Field16)
- qna_notification (Field17)
- phone_number (Field18)
member_food
- id (Key) — Foreign key → member.id — NOT NULL
- id (Key2) — Foreign key → food.id — NOT NULL
mission
- id (Key) — Primary key — NOT NULL
- name (Field)
- comment (Field2)
- adress (Field3)
- is_complete (Field4)
- on_going (Field5)
- created_at (Field6)
- updated_at (Field7)
- id (Key2) — Foreign key → store.id — NOT NULL
- give_point (Field8)
mission_member
- id (Key) — Foreign key → member.id — NOT NULL
- id (Key2) — Foreign key → mission.id — NOT NULL
notification
- id (Key) — Primary key — NOT NULL
- type (Field) — 이벤트, 리뷰, 문의내역
- id (Key2) — Foreign key → review.id — NOT NULL
- id (Key3) — Foreign key → mission.id — NOT NULL
- id (Key4) — Foreign key → event.id — NOT NULL
notification_member
- id (Key) — Foreign key → notification.id — NOT NULL
- id (Key2) — Foreign key → member.id — NOT NULL
- created_at (Field)
qna
- id (Key) — Primary key — NOT NULL
- title (Field)
- comment (Field2)
- id (Key2) — Foreign key → member.id — NOT NULL
- created_at (Field3)
- updated_at (Field4)
review
- id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → member.id — NOT NULL
- comment (Field)
- star (Field2)
- created_at (Field3)
- updated_at (Field4)
- answer (Field5)
store
- id (Key) — Primary key — NOT NULL
- title (Field)
- comment (Field2)
- average_star (Field3)
- id (Key2) — Foreign key → review.id — NOT NULL