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)