UMC 6th chapter4

Tables (11)

allowance (Untitled2)

  • 아이디 (id) — bigint — Primary key — NOT NULL
  • title — varchar(20)
  • 설명 (description) — text
  • 필수여부 (optional) — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)

food_category (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • 카테고리 이름 (name) — varchar(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)

image (Untitled9)

  • id — bigint — Primary key — NOT NULL
  • review_id — bigint — Foreign key → review.id — NOT NULL
  • url — text
  • created_at — datetime(6)
  • updated_at — datetime(6)

member (Untitled)

  • id — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar(20)
  • 성별 (gender) — varchar(10)
  • 생년월일 (birthday) — datetime
  • 도로명주소 (zipcode) — int
  • 상세주소 (address) — varchar(50)
  • 계정 상태 (status) — varchar(10)
  • 비활성화 날짜 (inactive_date) — datetime
  • 회원가입 타입 (social_type) — varchar(10)
  • 이메일 (email) — varchar(30)
  • 포인트 (point) — int
  • 위치 정보 제공 (location_allowance) — boolean
  • 마케팅 수신 동의 (marketing_allowance) — bolean
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_allowance (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • allowance_id — bigint — Foreign key → allowance.아이디 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_food_category (Untitled5)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • food_category_id (food_catgory_id) — bigint — Foreign key → food_category.id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_mission (Untitled7)

  • id — bigint — Primary key — NOT NULL
  • member_id — datetime(6) — Foreign key → member.id — NOT NULL
  • mission_id — datetime(6) — Foreign key → mission.id — NOT NULL
  • 완료여부 (mission_status) — varchar(10)
  • created_at — datetime(6)
  • updated_at — datetime(6)

mission (Untitled6)

  • id — bigint — Primary key — NOT NULL
  • restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
  • 획득 기능 포인트 (point) — int
  • 음식 가격 (food_price) — int
  • 미션 마감 기한 (deadline) — datetime
  • created_at — datetime(6)
  • updated_at — datetime(6)

restaurant (Untitled8)

  • id — bigint — Primary key — NOT NULL
  • restaurant_category_id — bigint — Foreign key → restaurant_category.id — NOT NULL
  • 식당 이름 (name) — varchar(30)
  • 주소 (address) — varchar(50)
  • created_at — datetime(6)
  • updated_at — datetime(6)

restaurant_category (Untitled10)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)

review

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
  • 별점 (star) — float
  • 리뷰 내용 (body) — text
  • created_at — datetime(6)
  • updated_at — datetime(6)