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