9th_umc_study
Tables (9)
area
- area_id (Key) — long — Primary key — NOT NULL
- area_name (Field) — varchar(30)
food_category
- food_id (Key) — long — Primary key — NOT NULL
- name (Field) — varchar(15)
image
- image_id (Key) — long — Primary key — NOT NULL
- review_id (Key2) — long — Foreign key → review.review_id — NOT NULL
- image_url (Field) — text
member
- member_id (Key) — long — Primary key — NOT NULL
- name (Field) — varchar(20)
- gender (Field2) — enum
- birth (Field3) — datetime
- address (Field4) — varchar(30)
- created_at (Field6) — datetime(6)
- updated_at (Field7) — datetime(6)
- status (Field5) — varchar(15)
- inactive_date (Field8) — datetime
member_mission
- user_id (Key2) — long — Foreign key → member.member_id — NOT NULL
- mission_id (Key3) — long — Foreign key → mission.mission_id — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
- status (Field3) — enum
member_prefer
- user_prefer_id (Key) — long — Primary key — NOT NULL
- user_id (Key2) — long — Foreign key → member.member_id — NOT NULL
- food_id (Key3) — long — Foreign key → food_category.food_id — NOT NULL
mission
- mission_id (Key) — long — Primary key — NOT NULL
- restaurant_id (Key2) — long — Foreign key → store.store_id — NOT NULL
- content (Field) — text
- point_value (Field2) — int
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
review
- review_id (Key) — long — Primary key — NOT NULL
- store_id (Key2) — long — Foreign key → store.store_id — NOT NULL
- member_id (Key3) — long — Foreign key → member.member_id — NOT NULL
- content (Field) — text
- rate (Field2) — float
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
store (restaurant)
- store_id (Key) — long — Primary key — NOT NULL
- area_id (Key2) — long — Foreign key → area.area_id — NOT NULL
- address (Field) — varchar(30)
- rate (Field2) — float
- restaurant_name (Field3) — varchar(20)