Closing

Tables (13)

ai_sessions

  • session_id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — V2 추가
  • status — VARCHAR(255) — NEW / GENERATED / ALREADY_CONFIRMED
  • messages — TEXT — NOT NULL — 대화 이력 (JSON 직렬화)
  • turn_count — INTEGER — NOT NULL
  • generated_tasks — TEXT — 생성된 임시 일정 (JSON 직렬화)
  • confirmed_task_ids — TEXT — 확정된 일정의 taskId 목록 (JSON)
  • version — BIGINT — 낙관적 락(optimistic lock) - 동시 세션 갱신 충돌 방지
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL

bookmarks

  • bookmark_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • support_id — BIGINT — Foreign key → support_info.support_id — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL

business_registrations

  • registration_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • business_number — VARCHAR(255) — NOT NULL
  • business_owner_name — VARCHAR(255)
  • business_open_date — TIMESTAMP(6)
  • business_close_date — TIMESTAMP(6)
  • close_planned_date — DATE — 폐업 예정일 (디데이 계산 및 AI 일정 생성용)
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL

chat_messages

  • message_id — BIGSERIAL — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → chat_rooms.room_id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • message_type — VARCHAR(255) — TEXT / IMAGE
  • is_read — BOOLEAN — NOT NULL — 메시지 단위 읽음 처리 (room 단위 last_read 컬럼은 사용 안 함)
  • created_at — TIMESTAMP(6) — NOT NULL

chat_rooms

  • room_id — BIGSERIAL — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → products.product_id — NOT NULL
  • buyer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • seller_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL

inquiries

  • inquiry_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(255)
  • content — TEXT — NOT NULL
  • image_urls — TEXT — 첨부 이미지 (최대 N장)
  • status — VARCHAR(255) — NOT NULL — PENDING / ANSWERED
  • answer — TEXT
  • answered_at — TIMESTAMP(6) — 답변 전 NULL
  • created_at — TIMESTAMP(6) — NOT NULL

product_bookmarks

  • bookmark_id — BIGSERIAL — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → products.product_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL

products

  • product_id — BIGSERIAL — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • business_category — VARCHAR(255) — 업종별 카테고리 - CHECK 제약 (허용값 13종, 하단 CK_PRODUCTS_BUSINESS_CATEGORY 참고)
  • product_category — VARCHAR(255) — 품목별 카테고리 - CHECK 제약 (허용값 11종, 하단 CK_PRODUCTS_PRODUCT_CATEGORY 참고)
  • price — INTEGER — NOT NULL
  • description — TEXT
  • image_urls — TEXT — 이미지 URL 배열 (최대 10개)
  • is_delivery_available — BOOLEAN — NOT NULL
  • is_direct_available — BOOLEAN — NOT NULL
  • trade_location — VARCHAR(255)
  • status — VARCHAR(255) — SELLING / SOLD_OUT / DELETED / RESERVED
  • latitude — NUMERIC(10, 7)
  • longitude — NUMERIC(10, 7)
  • purchased_at — DATE
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL

support_info

  • support_id — BIGSERIAL — Primary key — NOT NULL
  • organization_name — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • apply_start_date — DATE
  • apply_end_date — DATE
  • application_period — VARCHAR(255) — 신청기간 표기용 원문 텍스트 (예: 상시모집 등)
  • external_id — VARCHAR(255) — 외부 공고 원본 식별자 (중복 수집 방지)
  • external_url — TEXT
  • status — VARCHAR(255) — NOT NULL — ONGOING / CLOSED
  • view_count — INTEGER — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL

tasks

  • task_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — V4에서 registration_id FK → user_id FK로 교체됨
  • title — VARCHAR(255) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • start_time — TIME(6)
  • end_time — TIME(6)
  • is_completed — BOOLEAN — NOT NULL — 진행률 계산 기준. true=완료 / false=미완료
  • source — VARCHAR(255) — 생성 출처: AI_GENERATED / MANUAL
  • description — TEXT
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL

terms

  • term_id — BIGSERIAL — Primary key — NOT NULL
  • type — VARCHAR(255) — SERVICE / PRIVACY / AGE
  • version — VARCHAR(255)
  • content — TEXT — NOT NULL
  • effective_date — DATE — NOT NULL
  • is_required — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL

user_terms

  • user_term_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • term_id — BIGINT — Foreign key → terms.term_id — NOT NULL
  • agreed_at — TIMESTAMP(6) — NOT NULL — 동의 시각 - 법적 증빙 목적상 가장 중요

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • kakao_id — VARCHAR(255) — 카카오 고유 식별자 (V6: nullable로 변경, 카카오 외 인증수단 확장 대비)
  • nickname — VARCHAR(50) — NOT NULL
  • name — VARCHAR(255)
  • phone — VARCHAR(255)
  • email — VARCHAR(255)
  • profile_image_url — TEXT
  • location — VARCHAR(50) — 활동 지역 (V5 추가)
  • deleted_at — TIMESTAMP(6) — 탈퇴일시 (soft delete)
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL