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