UMCERD

Tables (17)

Alarm

  • ID (alarm_id) — bigint — Primary key — NOT NULL
  • 유저ID (user_id) — BIGINT — Foreign key → User.유저ID — NOT NULL
  • 생성일자 (created_at) — datetime
  • 확인여부 (is_confirmed) — bool
  • 타입 (alarm_type) — enum

AlarmNotice

  • Id (alarm_notice_id) — bigint — Primary key — NOT NULL
  • ID (alarm_id) — bigint — Foreign key → Alarm.ID — NOT NULL
  • 내용 (alarm_content) — text
  • 제목 (alarm_title) — varchar(50)

AlarmRestaurant

  • ID (alarm_restaurant_id) — bigint — Primary key — NOT NULL
  • 알람ID (alarm_id) — bigint — Foreign key → Alarm.ID — NOT NULL
  • 식당ID (restaurant_id) — bigint — Foreign key → Restaurant.식당ID — NOT NULL
  • 내용 (alarm_content) — text
  • 제목 (alarm_title) — varchar(50)

Food

  • ID (food_id) — bigint — Primary key — NOT NULL
  • 식당ID (restaurant_id) — bigint — Foreign key → Restaurant.식당ID — NOT NULL
  • 이름 (food_name) — varchar(10)
  • 타입 (food_type) — varchar(10)
  • 가격 (food_coast) — bigint

Mission

  • 미션ID (mission_id) — bigint — Primary key — NOT NULL
  • 식당ID (restaurant_id) — bigint — Foreign key → Restaurant.식당ID — NOT NULL
  • 미션생성일 (created_at) — datetime
  • 미션변경일 (updated_at) — datetime
  • 미션삭제일 (deleted_at) — datetime
  • 삭제여부 (is_deleted) — bool
  • 포인트 (point) — int
  • 미션 제목 (mission_title) — varchar
  • 미션내용 (mission_content) — text
  • 타입 (mission_type) — enum

MissionRegion (Untitled2)

  • Id (mission_region_iod) — bigint — Primary key — NOT NULL
  • 지역 (region) — varchar
  • 미션ID (mission_id) — bigint — Foreign key → Mission.미션ID — NOT NULL

MissionRestaurant (Untitled)

  • ID (missiobn_restaurant_id) — bigint — Primary key — NOT NULL
  • 미션ID (mission_id) — bigint — Foreign key → Mission.미션ID — NOT NULL
  • 식당ID (restaurant_id2) — bigint — Foreign key → Restaurant.식당ID — NOT NULL

Preference

  • ID (preference_id) — bignt — Primary key — NOT NULL
  • 선호사항 (preference_type) — varchar(10)

Restaurant

  • 식당ID (restaurant_id) — bigint — Primary key — NOT NULL
  • 식당이름 (restaurant_name) — varchar(50)
  • 주소 (address) — varchar(10)

RestaurantImage

  • ID (restaurant_image_id) — bigint — Primary key — NOT NULL
  • URL (url) — varchar(50)
  • 식당ID (restaurant_id) — bigint — Foreign key → Restaurant.식당ID — NOT NULL

Review

  • 리뷰ID (reaview_id) — bigint — Primary key — NOT NULL
  • 유저ID (user_id) — BIGINT — Foreign key → User.유저ID — NOT NULL
  • 식당ID (restaurant_id) — bigint — Foreign key → Restaurant.식당ID — NOT NULL
  • 제목 (review_title) — varchar(50)
  • 내용 (review_content) — text
  • 별점 (score) — demical(2,1)
  • 작성일 (created_at) — datetime

ReviewImage

  • Id (review_image_id) — bigint — Primary key — NOT NULL
  • 리뷰ID (reaview_id) — bigint — Foreign key → Review.리뷰ID — NOT NULL
  • URL (url) — varchar(50)

User

  • 유저ID (user_id) — BIGINT — Primary key — NOT NULL
  • 유저이름 (user_name) — varchar(10)
  • 생성시간 (created_at) — datetime
  • 수정시간 (updated_at) — datetiem
  • 삭제시간 (deleted_at) — datetime
  • 삭제여부 (is_deleted) — bool
  • 성별 (gender) — bool
  • 주소 (region) — varchar(50)
  • 이메일 (email) — varchar(50)
  • 전화번호 (phon_number) — varchar(15)
  • 인증여부 (is_certified) — bool
  • 프로필이미지 (profile_image_url) — varchar(50)
  • 생년월일 (birthday) — varchar(10)

UserAlarmSetting

  • ID (user_alarm_setting_id) — bigint — Primary key — NOT NULL
  • 타입 (alarm_type) — enum
  • 거졀여부 (is_accepted) — bool
  • 유저ID (user_id) — BIGINT — Foreign key → User.유저ID — NOT NULL

UserMission

  • ID (user_mission_id) — bigint — Primary key — NOT NULL
  • 시작일 (started_at) — datetime
  • 종료일 (ended_at) — datetime
  • 상태 (mission_status) — enum
  • 유저ID (user_id) — BIGINT — Foreign key → User.유저ID — NOT NULL
  • 미션ID (mission_id2) — bigint — Foreign key → Mission.미션ID — NOT NULL

UserPreference

  • ID (user_preference_id) — bigint — Primary key — NOT NULL
  • 유저ID (user_id) — BIGINT — Foreign key → User.유저ID — NOT NULL
  • ID (preference_id2) — bignt — Foreign key → Preference.ID — NOT NULL

provider

  • 제공자Id (provider_id) — BIGINT — Primary key — NOT NULL
  • 유저ID (user_id2) — BIGINT — Foreign key → User.유저ID — NOT NULL
  • 서비스제공자 (provider) — enum
  • 서비스제공자유저ID (provider_user_id) — BIGINT