Closing
Tables (13)
ai_sessions
- session_id — VARCHAR(255) — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL — V2 추가
- status — VARCHAR(255) — NOT NULL — 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)
- updated_at — TIMESTAMP(6)
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)
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)
- updated_at — TIMESTAMP(6)
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) — NOT NULL — TEXT / IMAGE
- is_read — BOOLEAN — NOT NULL — 메시지 단위 읽음 처리 (room 단위 last_read 컬럼은 사용 안 함)
- created_at — TIMESTAMP(6)
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)
inquiries
- inquiry_id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- type — VARCHAR(255) — NOT NULL
- 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)
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)
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) — NOT NULL — 업종별 카테고리 - CHECK 제약 (허용값 13종, 하단 CK_PRODUCTS_BUSINESS_CATEGORY 참고)
- product_category — VARCHAR(255) — NOT NULL — 품목별 카테고리 - 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) — NOT NULL — SELLING / SOLD_OUT / DELETED / RESERVED
- latitude — NUMERIC(10, 7)
- longitude — NUMERIC(10, 7)
- purchased_at — DATE
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
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)
- updated_at — TIMESTAMP(6)
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) — NOT NULL — 생성 출처: AI_GENERATED / MANUAL
- description — TEXT
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
terms
- term_id — BIGSERIAL — Primary key — NOT NULL
- type — VARCHAR(255) — NOT NULL — SERVICE / PRIVACY / AGE
- version — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- effective_date — DATE — NOT NULL
- is_required — BOOLEAN — NOT NULL
- created_at — TIMESTAMP(6)
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) — 동의 시각 - 법적 증빙 목적상 가장 중요
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)
- updated_at — TIMESTAMP(6)