Mission
Tables (6)
food_category (Untitled4)
- id — bigint — Primary key — NOT NULL
- name — varchar(50)
member (Untitled)
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255)
- provider — varchar(50)
- provider_id — varchar(255)
- point — int
- deleted_at — timestamp
member_mission (Untitled5)
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- status — varchar(20)
- review_content — varchar(100)
mission (Untitled6)
- id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- title — varchar(255)
- description — varchar(500)
- reward_point — int
region (Untitled2)
- id — bigint — Primary key — NOT NULL
- name — varchar(100)
store (Untitled3)
- id — bigint — Primary key — NOT NULL
- region_id — bigint — Foreign key → region.id — NOT NULL
- food_category_id — bigint — Foreign key → food_category.id — NOT NULL
- name — varchar(255) — NOT NULL
- address — varchar(255)