umc_실습
테이블 (7)
food (Untitled5)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — enum
liked_food (Untitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL
- food_id (Key2) — bigint — 외래 키 → food.id — NOT NULL
member (Untitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20)
- gender (Field2) — varchar(20)
- birth (Field3) — datetime
- address (Field4) — text
- point (Field5) — bigint
- updated_at (Field6) — datetime
- deleted_at (Field7) — datetime
member_mission (Untitled6)
- id (Key3) — bigint — 기본 키 — NOT NULL
- member_id (Key) — bigint — 외래 키 → member.id — NOT NULL
- mission_id (Key2) — bigint — 외래 키 → mission.id — NOT NULL
- is_complete (Field) — boolean
mission (Untitled3)
- id (Key) — bigint — 기본 키 — NOT NULL
- store_id (Key3) — bigint — 외래 키 → store.id — NOT NULL
- condition (Field) — text
- created_at (Field2) — timestamp
- point (Field3) — int
review (Untitled7)
- id (Key) — bigint — 기본 키 — NOT NULL
- content (Field) — text
- star (Field2) — int
- store_id (Key2) — bigint — 외래 키 → store.id — NOT NULL
- member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL
store (Untitled4)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar