10th_UMC
Tables (12)
food
- food_id — BIGINT — Primary key — NOT NULL — 약관 ID
- name — ENUM( 'NONE', 'KOREAN', 'JAPANESE', 'CHINESE', 'WESTERN', 'SNACK', 'FASTFOOD', 'DESSERT', 'ASIAN' ) — NOT NULL — 약관명
location
- location_id — BIGINT — Primary key — NOT NULL — 지역 ID
- name — VARCHAR(100) — NOT NULL — 지역명
- created_at — TIMESTAMP — NOT NULL — 생성일시
member
- member_id — BIGINT — Primary key — NOT NULL — 주소
- name — VARCHAR(20) — NOT NULL — 상세주소
- gender — ENUM('MALE', 'FEMALE', 'NONE') — NOT NULL — 소셜 UID
- birth — DATE — NOT NULL — 소셜 타입
- address — VARCHAR(100) — NOT NULL — 포인트
- detail_address — VARCHAR(255) — 이메일
- social_uid — VARCHAR(255) — 전화번호
- social_type — ENUM('KAKAO', 'NAVER', 'APPLE', 'GOOGLE', 'LOCAL') — NOT NULL — 프로필 URL
- point — INT — NOT NULL — 삭제일자
- email — VARCHAR(50) — NOT NULL — 수정일자
- phone_number — VARCHAR(20) — 생성일자
- profile_url — TEXT — 사용자 선호 음식 ID
- deleted_at — TIMESTAMP — 사용자 ID
- updated_at — TIMESTAMP — NOT NULL — 음식 ID
- created_at — TIMESTAMP — NOT NULL — 사용자 약관 ID
member_food
- member_food_id — BIGINT — Primary key — NOT NULL — 약관 ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 미션 ID
- food_id — BIGINT — Foreign key → food.food_id — NOT NULL — 미션 기한
member_mission
- member_mission_id — BIGINT — Primary key — NOT NULL — 리뷰 ID
- status — ENUM( 'IN_PROGRESS', 'SUCCESS_REQUESTED', 'COMPLETED', 'REVIEWED', 'CANCELLED' ) — NOT NULL — 리뷰 내용
- challenged_at — TIMESTAMP — NOT NULL — 생성일시
- success_requested_at — TIMESTAMP — 수정일시
- completed_at — TIMESTAMP — 별점
- reviewed_at — TIMESTAMP — 가게 ID
- mission_id — BIGINT — Foreign key → mission.mission_id — NOT NULL — 사용자 ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 리뷰 사진 ID
member_term
- member_term_id — BIGINT — Primary key — NOT NULL — 성공 점수
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 생성일자
- term_id — BIGINT — Foreign key → term.term_id — NOT NULL — 수정일자
mission
- mission_id — BIGINT — Primary key — NOT NULL — 가게 ID
- deadline — DATE — 사용자 미션 ID
- conditional — TEXT — NOT NULL — 상태
- reward_point — INT — NOT NULL — 도전일시
- created_at — TIMESTAMP — NOT NULL — 성공 요청일시
- updated_at — TIMESTAMP — NOT NULL — 완료일시
- deleted_at — TIMESTAMP — 리뷰 작성일시
- store_id — BIGINT — Foreign key → store.store_id — NOT NULL — 미션 ID
reply
- reply_id — BIGINT — NOT NULL
review
- review_id — BIGINT — NOT NULL — 리뷰 ID
- content — TEXT — NOT NULL — 답글 ID
- created_at — TIMESTAMP — NOT NULL — 내용
- updated_at — TIMESTAMP — NOT NULL — 생성일시
- star — DECIMAL(2, 1) — NOT NULL — 수정일시
- store_id — BIGINT — Foreign key → store.store_id — NOT NULL — 리뷰 ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
review_photo
- review_photo_id — BIGINT — NOT NULL
store
- store_id — BIGINT — Primary key — NOT NULL — 가게명
- name — VARCHAR(255) — NOT NULL — 사장님 구분 번호
- manager_number — BIGINT — NOT NULL — 상세 주소
- detail_address — VARCHAR(255) — NOT NULL — 지역 ID
- location_id — BIGINT — Foreign key → location.location_id — NOT NULL — 생성일시
- created_at — TIMESTAMP — NOT NULL — 수정일시
- updated_at — TIMESTAMP — NOT NULL — 음식 ID
term
- term_id — BIGINT — Primary key — NOT NULL — 이름
- name — ENUM( 'AGE', 'SERVICE', 'PRIVACY', 'LOCATION', 'MARKETING' ) — NOT NULL — 성별