umc_week0
Tables (9)
Inquiry (Untitled8)
- inquiry_id (문의 ID) — INT — Primary key — NOT NULL
- user_id (사용자 ID) — INT — Primary key — NOT NULL
- type (문의 유형) — VARCHAR(50)
- title (제목) — VARCHAR(100)
- content (내용) — TEXT
- status (처리 상태) — VARCHAR(20)
- imageURL (첨부 이미지) — VARCHAR(30)
- inquiryDate (작성일) — TIMESTAMP
- user_id (Key) — INT — Foreign key → User.user_id — NOT NULL
Mission (Untitled4)
- mission_id (미션 ID) — INT — Primary key — NOT NULL
- Key2 (가게 ID) — INT — Primary key — NOT NULL
- description (미션 설명) — VARCHAR(300)
- points (포인트) — INT
- total_missions_per_region (지역 전체 미션 수) — INT
- store_id (가게 ID2) — INT — Foreign key → Store.store_id — NOT NULL
- region_id (지역 ID) — INT — Foreign key → Store.region_id — NOT NULL
Notification (Untitled9)
- notification_id (알림 ID) — INT — Primary key — NOT NULL
- user_id (사용자 ID) — INT — Primary key — NOT NULL
- type (알림 유형) — VARCHAR(100)
- content (알림 내용) — TEXT
- isRead (읽음 여부) — BOOLEAN
- sentDate (발송일시) — TIMESTAMP
- user_id (Key) — INT — Foreign key → User.user_id — NOT NULL
Region (Untitled2)
- region_id (Key) — INT — Primary key — NOT NULL
- name (지역 이름) — VARCHAR(100)
Review (Untitled7)
- review_id (리뷰 ID) — INT — Primary key — NOT NULL
- user_id (사용자 ID) — INT — Primary key — NOT NULL
- store_id (Key) — INT — Primary key — NOT NULL
- rating (평점) — INT
- comment (내용) — TEXT
- imageURL (이미지 경로) — VACHAR(300)
- created_at (작성일시) — TIMESTAMP
- user_id (Key2) — INT — Foreign key → User.user_id — NOT NULL
- store_id (가게 ID) — INT — Foreign key → Store.store_id — NOT NULL
- region_id (지역 ID) — INT — Foreign key → Store.region_id — NOT NULL
Store (Untitled3)
- store_id (가게 ID) — INT — Primary key — NOT NULL
- region_id (지역 ID) — INT — Primary key — NOT NULL
- name (가게 이름) — VARCHAR(100)
- address (주소) — VARCHAR(300)
- category (카테고리) — VARCHAR(50)
- phone (전화번호) — VARCHAR(20)
- created_at (등록일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
- region_id (Key) — INT — Foreign key → Region.region_id — NOT NULL
User (Untitled)
- user_id (Key) — INT — Primary key — NOT NULL
- nickname (닉네임) — VARCHAR(50)
- password (비밀번호) — VARCHAR(100)
- email (이메일) — VARCHAR(100)
- phone (전화번호) — VARCHAR(20)
- gender (성별) — CHAR(1)
- address (주소) — VARCHAR(300)
- birthdate (생년월일) — DATE
- created_at (가입일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
- region_id (선호 지역 ID) — INT
- total_point (누적 포인트) — INT
- is_active (활성 여부) — INT
- is_new_event_noti_on (이벤트 알림 여부) — BOOLEAN
- is_review_comment_on (리뷰 댓글 알림 여부) — BOOLEAN
- is_inquiry_reply_on (문의 답변 알림 여부) — BOOLEAN
- is_phone_verified (전화 인증 여부) — BOOLEAN
- region_id (Key2) — INT — Foreign key → Region.region_id — NOT NULL
UserMission (Untitled5)
- user_id (사용자 ID) — INT — Primary key — NOT NULL
- mission_id (미션 ID) — INT — Primary key — NOT NULL
- Key (리뷰 ID) — INT — Primary key — NOT NULL
- user_id (Key) — INT — Foreign key → User.user_id — NOT NULL
- mission_id (미션 ID2) — INT — Foreign key → Mission.mission_id — NOT NULL
- Key2 (가게 ID) — INT — Foreign key → Mission.Key2 — NOT NULL
- status (상태) — VARCHAR(20)
- certification_code (인증 코드) — VARCHAR(50)
- completed_at (완료 일시) — TIMESTAMP
- created_at (등록일시) — TIMESTAMP
UserPreference (Untitled6)
- user_id (사용자 ID) — INT — Primary key — NOT NULL
- cuisine_name (선호 음식) — VARCHAR(50) — Primary key — NOT NULL
- user_id (Key) — INT — Foreign key → User.user_id — NOT NULL