umc

Tables (9)

alarm (알림)

  • id (알람 id) — bigint — Primary key — NOT NULL
  • member_id (사용자 id) — bigint — Foreign key → member.member_id — NOT NULL
  • dtype (구분) — varchar2(20)
  • is_confirmed (Field) — boolean
  • created_at (생성 날짜) — datetime(6)
  • updated_at (수정 날짜) — datetime(6)
  • title — varchar2(30)
  • body — text

favor (선호음식)

  • id (선호 id) — bigint — Primary key — NOT NULL
  • member_id (사용자 id) — bigint — Foreign key → member.member_id — NOT NULL
  • korea (한식) — int
  • japan (일식) — int
  • china (중식) — int
  • western (양식) — int
  • chicken (치킨) — int
  • snack (분식) — int
  • roasted (고기/구이) — int
  • box (도시락) — int
  • night (야식) — int
  • fast (패스트푸드) — int
  • dessert (디저트) — int
  • asian (아시안) — int

member (회원정보(마이페이지))

  • member_id (사용자 id) — bigint — Primary key — NOT NULL
  • email (사용자 email) — varchar2(50)
  • gender (성별) — int
  • birth (생년월일) — date
  • address (주소) — varchar2(50)
  • created_at (생성 날짜) — datetime(6)
  • updated_at (수정 날짜) — datetime(6)
  • status (상태) — varchar2(15)
  • inactive_date (비활성 날짜) — datetime

mission (미션)

  • mission_id (미션id (구분 번호)) — varchar2(50) — Primary key
  • member_id (사용자 id) — bigint — Foreign key → member.member_id — NOT NULL
  • region_id (지역 id) — bigint — Foreign key → region.region_id — NOT NULL
  • completed (성공 여부) — boolean
  • point (미션 포인트) — bigint

point (포인트(사용자))

  • id (포인트 id) — bigint — Primary key
  • member_id (사용자 id) — bigint — Foreign key → member.member_id — NOT NULL
  • name (포인트 지급 이름) — varchar2(50)
  • created_at (생성 날짜) — datetime(6)
  • updated_at (수정 날짜) — datetime(6)

qna (문의)

  • id (문의 id) — bigint — Primary key
  • member_id (사용자 id) — bigint — Foreign key → member.member_id — NOT NULL
  • created_at (생성 날짜) — datetime(6)
  • updated_at (수정 날짜) — datetime(6)
  • state (문의 상태) — int
  • title (문의 제목) — varchar2(100)
  • text (문의 내용) — text
  • photo (문의 사진) — varchar2(100)

region (지역)

  • region_id (지역 id) — bigint — Primary key — NOT NULL
  • region (지역이름) — varchar2(50)

review (리뷰)

  • review_id (리뷰 id) — bigint — Primary key — NOT NULL
  • member_id (사용자 id) — bigint — Foreign key → member.member_id — NOT NULL
  • store_id (가게 id) — bigint — Foreign key → store.store_id — NOT NULL
  • point (리뷰 포인트) — float
  • text (리뷰 내용) — text
  • photo (리뷰 사진) — varchar2(100)
  • reply (리뷰 답글) — text
  • created_at (생성 날짜) — datetime(6)
  • updated_at (수정 날짜) — datetime(6)

store (가게)

  • store_id (가게 id) — bigint — Primary key — NOT NULL
  • region_id (지역 id) — bigint — Foreign key → region.region_id — NOT NULL
  • name (가게 이름) — varchar2(50)
  • address (가게 주소) — varchar2(80)