1week
Tables (10)
food (Untitled7)
- id — int — Primary key — NOT NULL
- type — varchar(10)
member (Untitled)
- id — int — Primary key — NOT NULL
- name — varchar(20)
- gender — varchar20)
- birth — datetime(6)
- address — varchar(40)
- email — varchar(40)
- phone_number — varchar(20)
- point — int
- nickname — varchar(20)
member_agree (Untitled2)
- id — int — Primary key — NOT NULL
- member_id — int — Foreign key → member.id — NOT NULL
- terms_id — int — Foreign key → terms.id — NOT NULL
member_mission (Untitled4)
- id — int — Primary key — NOT NULL
- member_id — int — Foreign key → member.id — NOT NULL
- mission_id — int — Foreign key → mission.id — NOT NULL
- status — varchar(10)
member_prefer (Untitled3)
- id — int — Primary key — NOT NULL
- member_id — int — Foreign key → member.id — NOT NULL
- food_id — int — Foreign key → food.id — NOT NULL
mission (Untitled10)
- id — int — Primary key — NOT NULL
- store_id — int — Foreign key → store.id — NOT NULL
- contents — text
- point — int
- deadline — datetime(6)
region (Untitled5)
- id — int — Primary key — NOT NULL
- name — varchar(20)
review (Untitled8)
- id — int — Primary key — NOT NULL
- member_id — int — Foreign key → member.id — NOT NULL
- store_id — int — Foreign key → store.id — NOT NULL
- id (id2) — int — Foreign key → store.region_id — NOT NULL
- image — text
- contents — text
- score — float
- day — datetime(6)
store (Untitled9)
- id — int — Primary key — NOT NULL
- food_id — int — Foreign key → food.id — NOT NULL
- region_id — int — Foreign key → region.id — NOT NULL
- region — varchar(20)
- score — float
terms (Untitled6)
- id — int — Primary key — NOT NULL
- title — varchar(20)
- contents — text
- option — boolean