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