UMC_HomeWork

Tables (10)

food_category (Untitled5)

  • id — int — Primary key — NOT NULL
  • 내용 (name) — varchar
  • 생성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

member (Untitled)

  • 회원번호 (id) — int — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 성별 (gender) — int
  • 나이 (age) — int
  • 주소 (address) — varchar
  • 회원탈퇴여부 (status) — boolean
  • 회원탈퇴날짜 (inactive_date) — datetime — NOT NULL
  • 회원가입경로 (social) — varchar
  • 생성일 (created_at) — datetime
  • 변경일 (updated_at) — datetime — NOT NULL
  • email — varchar
  • 포인트 (point) — int
  • 휴대폰번호 (phonenumber) — varchar — NOT NULL
  • 미션성공횟수 (mission_clear) — tinyint

member_agree (Untitled2)

  • id — int — Primary key — NOT NULL
  • 회원번호 (member_id) — int — Foreign key → member.회원번호 — NOT NULL
  • 약관번호 (terms_id) — int — Foreign key → terms.약관번호 — NOT NULL
  • 동의여부 (is_agree) — boolean
  • (created_at) — datetime
  • (updated_at) — datetime

member_mission (Untitled9)

  • id — int — Primary key — NOT NULL
  • 회원번호 (member_id) — int — Foreign key → member.회원번호 — NOT NULL
  • id (mission_id) — int — Foreign key → mission.id — NOT NULL
  • 완료여부 (status) — boolean
  • 생성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

member_prefer (Untitled4)

  • id — int — Primary key — NOT NULL
  • 회원번호 (member_id) — int — Foreign key → member.회원번호 — NOT NULL
  • id (category_id) — int — Foreign key → food_category.id — NOT NULL
  • 생성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

mission (Untitled10)

  • id — int — Primary key — NOT NULL
  • id (store_id) — int — Foreign key → store.id — NOT NULL
  • 보상 (reward) — int
  • 기간 (deadlint) — datetime
  • 미션내용 (body) — text
  • 생성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

region (Untitled8)

  • id — int — Primary key — NOT NULL
  • 지역명 (name) — varchar
  • 생성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

review (Untitled6)

  • id — int — Primary key — NOT NULL
  • 회원번호 (member_id) — int — Foreign key → member.회원번호 — NOT NULL
  • 가게번호 (store_id) — int — Foreign key → store.id — NOT NULL
  • 내용 (body) — text
  • 별점 (score) — float
  • 생성일 (created_at) — datetime
  • 변경일 (updated_at) — datetime
  • 사진 (picture) — varchar

store (Untitled7)

  • id — int — Primary key — NOT NULL
  • id (region_id) — int — Foreign key → region.id — NOT NULL
  • 상호명 (name) — varchar
  • 주소 (address) — varchar
  • 별점 (score) — float

terms (Untitled3)

  • 약관번호 (id) — int — Primary key — NOT NULL
  • 약관 (title) — varchar
  • 내용 (body) — text
  • 선택사항여부 (optional) — boolean
  • 생성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime