umc
Tables (6)
food (Untitled2)
- id — Primary key — NOT NULL
- foodname — varchar(10)
- food_field — varchar(10)
member (Untitled)
- id — Primary key — NOT NULL
- name — varchar(10)
- birth — varchar(10)
- gender — varchar(10)
- photo — text
- address — varchar(10)
- nickname — varchar(10)
- date — varchar(10)
- phone number — varchar(20)
- email — varchar(50)
member_prefer (Untitled4)
- id — Primary key — NOT NULL
- member_id — int — Foreign key → member.id — NOT NULL
- food_id — int — Foreign key → food.id — NOT NULL
mission (Untitled3)
- id — int — Primary key — NOT NULL
- store_name — int
- contents — varchar(10)
- deadline — int
- store_field — varchar(10)
review (Untitled5)
- Key (id) — int — Primary key — NOT NULL
- Key — Foreign key → member.id — NOT NULL
- member_id — int
- store_id — text
- photo — text
- contents — text
- score — int
store (Untitled6)
- id — int — Primary key — NOT NULL
- id (id2) — int — Foreign key → mission.id — NOT NULL
- food_id — int
- place — varchar(10)
- score