mission1
Tables (6)
food_category
- id — BIGINT — Primary key — NOT NULL — Auto Incrment
- name — VARCHAR(50)
member
- id — BIGINT — Primary key — NOT NULL — Auto Increment
- name — VARCHAR(50)
- email — VARCHAR(100)
- social_provider — VARCHAR(20)
- deleted_at — DATETIME — NOT NULL
member_mission
- id — BIGINT — Primary key — NOT NULL
- completed_at — DATETIME — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL — Auto Increment
- mission_id — BIGINT — Foreign key → mission.id — NOT NULL — Auto Increment
mission
- id — BIGINT — Primary key — NOT NULL — Auto Increment
- title — VARCHAR(100)
- description — VARCHAR(500)
- store_id — BIGINT — Foreign key → store.id — NOT NULL — Auto Increment
region
- id — BIGINT — Primary key — NOT NULL — Auto Increment
- name — VARCHAR(50)
store
- id — BIGINT — Primary key — NOT NULL — Auto Increment
- name — VARCHAR(100)
- address — VARCHAR(255)
- rsgion_id (region_id) — BIGINT — Foreign key → region.id — NOT NULL — Auto Increment
- food_category_id — BIGINT — Foreign key → food_category.id — NOT NULL — Auto Incrment