10th_UMC

Tables (12)

food

  • food_id — BIGINT — Primary key — NOT NULL — 약관 ID
  • name — ENUM( 'NONE', 'KOREAN', 'JAPANESE', 'CHINESE', 'WESTERN', 'SNACK', 'FASTFOOD', 'DESSERT', 'ASIAN' ) — NOT NULL — 약관명

location

  • location_id — BIGINT — Primary key — NOT NULL — 지역 ID
  • name — VARCHAR(100) — NOT NULL — 지역명
  • created_at — TIMESTAMP — NOT NULL — 생성일시

member

  • member_id — BIGINT — Primary key — NOT NULL — 주소
  • name — VARCHAR(20) — NOT NULL — 상세주소
  • gender — ENUM('MALE', 'FEMALE', 'NONE') — NOT NULL — 소셜 UID
  • birth — DATE — NOT NULL — 소셜 타입
  • address — VARCHAR(100) — NOT NULL — 포인트
  • detail_address — VARCHAR(255) — 이메일
  • social_uid — VARCHAR(255) — 전화번호
  • social_type — ENUM('KAKAO', 'NAVER', 'APPLE', 'GOOGLE', 'LOCAL') — NOT NULL — 프로필 URL
  • point — INT — NOT NULL — 삭제일자
  • email — VARCHAR(50) — NOT NULL — 수정일자
  • phone_number — VARCHAR(20) — 생성일자
  • profile_url — TEXT — 사용자 선호 음식 ID
  • deleted_at — TIMESTAMP — 사용자 ID
  • updated_at — TIMESTAMP — NOT NULL — 음식 ID
  • created_at — TIMESTAMP — NOT NULL — 사용자 약관 ID

member_food

  • member_food_id — BIGINT — Primary key — NOT NULL — 약관 ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 미션 ID
  • food_id — BIGINT — Foreign key → food.food_id — NOT NULL — 미션 기한

member_mission

  • member_mission_id — BIGINT — Primary key — NOT NULL — 리뷰 ID
  • status — ENUM( 'IN_PROGRESS', 'SUCCESS_REQUESTED', 'COMPLETED', 'REVIEWED', 'CANCELLED' ) — NOT NULL — 리뷰 내용
  • challenged_at — TIMESTAMP — NOT NULL — 생성일시
  • success_requested_at — TIMESTAMP — 수정일시
  • completed_at — TIMESTAMP — 별점
  • reviewed_at — TIMESTAMP — 가게 ID
  • mission_id — BIGINT — Foreign key → mission.mission_id — NOT NULL — 사용자 ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 리뷰 사진 ID

member_term

  • member_term_id — BIGINT — Primary key — NOT NULL — 성공 점수
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 생성일자
  • term_id — BIGINT — Foreign key → term.term_id — NOT NULL — 수정일자

mission

  • mission_id — BIGINT — Primary key — NOT NULL — 가게 ID
  • deadline — DATE — 사용자 미션 ID
  • conditional — TEXT — NOT NULL — 상태
  • reward_point — INT — NOT NULL — 도전일시
  • created_at — TIMESTAMP — NOT NULL — 성공 요청일시
  • updated_at — TIMESTAMP — NOT NULL — 완료일시
  • deleted_at — TIMESTAMP — 리뷰 작성일시
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL — 미션 ID

reply

  • reply_id — BIGINT — NOT NULL

review

  • review_id — BIGINT — NOT NULL — 리뷰 ID
  • content — TEXT — NOT NULL — 답글 ID
  • created_at — TIMESTAMP — NOT NULL — 내용
  • updated_at — TIMESTAMP — NOT NULL — 생성일시
  • star — DECIMAL(2, 1) — NOT NULL — 수정일시
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL — 리뷰 ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

review_photo

  • review_photo_id — BIGINT — NOT NULL

store

  • store_id — BIGINT — Primary key — NOT NULL — 가게명
  • name — VARCHAR(255) — NOT NULL — 사장님 구분 번호
  • manager_number — BIGINT — NOT NULL — 상세 주소
  • detail_address — VARCHAR(255) — NOT NULL — 지역 ID
  • location_id — BIGINT — Foreign key → location.location_id — NOT NULL — 생성일시
  • created_at — TIMESTAMP — NOT NULL — 수정일시
  • updated_at — TIMESTAMP — NOT NULL — 음식 ID

term

  • term_id — BIGINT — Primary key — NOT NULL — 이름
  • name — ENUM( 'AGE', 'SERVICE', 'PRIVACY', 'LOCATION', 'MARKETING' ) — NOT NULL — 성별