UMC_01
Tables (12)
diner (식당)
- id (Key) — bigint — Primary key — NOT NULL
- food_type_id (Key2) — bigint — Foreign key → food_type.id — NOT NULL
- region_id (Key3) — bigint — Foreign key → region.id — NOT NULL
- diner_name (Field) — varchar(50)
- avg_star (Field2) — int
- location (Field3) — varchar(100)
diner_mission (식당 별 미션)
- id (Key) — bigint — Primary key — NOT NULL
- mission_id (Key2) — bigint — Foreign key → mission.id — NOT NULL
- diner_id (Key3) — bigint — Foreign key → diner.id — NOT NULL
- expire_date (Field) — datetime
food_type (음식 장르)
- id (Key) — bigint — Primary key — NOT NULL
- food_type (Field) — varchar(20)
inquiry (문의)
- id (Key) — bigint — Primary key — NOT NULL
- id (Key2) — bigint — Foreign key → user.id — NOT NULL
- title (Field) — varchar(100)
- content (Field2) — text
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime_(6)
- type (Field5) — varchar(15)
mission (미션)
- id (Key) — bigint — Primary key — NOT NULL
- quest (Field) — text
- reward (Field2) — int
mission_clear_log (미션 클리어 로그)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
- diner_mission_id (Key3) — bigint — Foreign key → diner_mission.id — NOT NULL
- mission_id (Key22) — bigint — Foreign key → diner_mission.mission_id — NOT NULL
- diner_id (Key32) — bigint — Foreign key → diner_mission.diner_id — NOT NULL
- point_id (Key4) — bigint — Foreign key → point_history.id — NOT NULL
- user_id (Key23) — bigint — Foreign key → point_history.user_id — NOT NULL
- created_at (Field) — datetime(6)
- clear_status (Field2) — ENUM
- clear_at (Field3) — datetime(6)
point_history (포인트 히스토리)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
- create_at (Field) — datetime
- reason (Field2) — text
- point_change (Field3) — int
region (지역)
- id (Key) — bigint — Primary key — NOT NULL
- region_name (Field) — varchar(100)
region_mission_user (지역별 미션 카운터)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → region.id — NOT NULL
- region_id (Key3) — bigint — Foreign key → user.id — NOT NULL
- mission_counter (Field) — int
review (리뷰)
- id (Key) — bigint — Primary key — NOT NULL
- diner_id (Key2) — bigint — Foreign key → diner.id — NOT NULL
- user_id (Key4) — bigint — Foreign key → user.id — NOT NULL
- star (Field) — int
- content (Field2) — text
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
user (유저)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- id (Field2) — varchar(20)
- pw (Field3) — varchar(20)
- gender (Field4) — varchar(10)
- birth (Field5) — datetime
- address (Field6) — varchar(100)
- email (Field7) — varchar(50)
- phone_number (Field8) — varchar(11)
- profile_url (Field9) — varchar(255)
- total_point (Field10) — int
user_favored_food_type (유저 선호 음식 종류)
- id (Key3) — bigint — Primary key — NOT NULL
- food_type_id (Key) — bigint — Foreign key → food_type.id — NOT NULL
- user_id (Key2) — bigint — Foreign key → user.id — NOT NULL