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