umc-6th

Tables (9)

category (카테고리)

  • id (분류id) — Long — Primary key — NOT NULL
  • category (가게분류) — String

image (이미지)

  • id (이미지id) — Long — Primary key — NOT NULL
  • type (파일타입) — varchar(50)
  • url (이미지링크) — varchar(100)
  • reviewId (리뷰id) — Long — Foreign key → review.id — NOT NULL

member (회원)

  • id (회원id) — Long — Primary key — NOT NULL
  • name (이름)
  • nickname (닉네임) — varchar(40)
  • profileUrl (프로필사진) — varchar(100)
  • gender (성별) — varchar(20)
  • status (상태) — varchar(15)
  • inactive_date (활성날짜) — datetime
  • point (포인트) — Integer
  • address (주소) — varchar(40)
  • birthday (생년월일) — LocalDate
  • phone_number (전화번호) — varchar(20)
  • verified (번호인증여부) — boolean
  • email (이메일) — varchar(30)

member_category (회원선호음식)

  • id (아이디) — Long — Primary key — NOT NULL
  • id (분류id) — Long — Foreign key → category.id — NOT NULL
  • id (회원id) — Long — Foreign key → member.id — NOT NULL

member_mission (진행중인 미션)

  • id (진행미션id) — Long — Primary key — NOT NULL
  • status (미션진행상) — varchar(15)
  • userId (회원id) — Long — Foreign key → member.id — NOT NULL
  • missionid (미션id2) — Long — Foreign key → mission.id — NOT NULL

mission (미션)

  • id (미션id) — Long — Primary key — NOT NULL
  • point (포인트) — Integer
  • minPrice (최소주문비용) — Integer
  • savings (적립퍼센트) — Integer
  • storeId (가게id) — Long — Foreign key → store.id — NOT NULL
  • regionId (지역id) — Long — Foreign key → region.id — NOT NULL

region (지역)

  • id (지역id) — Long — Primary key — NOT NULL
  • region (지역명) — varchar(40)

review (리뷰)

  • id (리뷰id) — Long — Primary key — NOT NULL
  • content (리뷰내용) — String
  • rating (점수) — float
  • createdAt (리뷰생성날짜) — LocalDate
  • storeId (가게id) — Long — Foreign key → store.id — NOT NULL
  • memberId (회원id) — Long — Foreign key → member.id — NOT NULL

store (가게)

  • id (가게id) — Long — Primary key — NOT NULL
  • title (가게명) — String
  • address (가게주소) — String
  • number (가게전화) — String
  • status (영업여부) — Status
  • imageUrl (가게사진url) — varchar(100)
  • categoryId (분류id) — Long — Foreign key → category.id — NOT NULL
  • regionId (지역id) — Long — Foreign key → region.id — NOT NULL