DB1

Tables (13)

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 — TIMESTAMPTZ — NOT NULL

business_registrations

  • registration_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • business_owner_name — VARCHAR(50)
  • business_open_date — TIMESTAMPTZ
  • business_close_date — TIMESTAMPTZ — 폐업일자 (D-day 계산 기준)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

chat_messages

  • message_id — BIGSERIAL — Primary key — NOT NULL
  • room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • content — TEXT
  • message_type — VARCHAR(20)
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

chat_rooms

  • room_id — BIGSERIAL — Primary key — NOT NULL
  • product_id — BIGINT — NOT NULL
  • buyer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • seller_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • buyer_last_read_message_id — BIGINT — NOT NULL
  • seller_last_read_message_id — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

document_chunks

  • chunk_id — BIGSERIAL — Primary key — NOT NULL
  • source_type — VARCHAR(20)
  • source_id — VARCHAR(50)
  • content — TEXT
  • embedding — TEXT — BGE-M3 임베딩 벡터. 원래 타입 VECTOR(1024) → ERD Cloud 임포트용 TEXT 대체
  • created_at — TIMESTAMPTZ — NOT NULL

inquiries

  • inquiry_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(20)
  • content — TEXT
  • image_urls — TEXT — 첨부 이미지(최대 N장). 원래 타입 TEXT → ERD Cloud 임포트용 TEXT 대체
  • status — VARCHAR(20) — NOT NULL
  • answer — TEXT — 관리자 답변 본문 - 답변 전 NULL
  • answered_at — TIMESTAMPTZ — 답변 시각 - 답변 전 NULL
  • created_at — TIMESTAMPTZ — NOT NULL

product_likes

  • like_id — BIGSERIAL — Primary key — NOT NULL
  • product_id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

products

  • product_id — BIGSERIAL — Primary key — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • title — VARCHAR(100)
  • category — VARCHAR(30)
  • price — INT
  • description — TEXT
  • image_urls — TEXT
  • is_delivery_available — BOOLEAN — NOT NULL
  • is_direct_available — BOOLEAN — NOT NULL
  • trade_location — VARCHAR(255)
  • status — VARCHAR(20) — selling / sold / deleted
  • latitude — DOUBLE PRECISION
  • longitude — DOUBLE PRECISION
  • purchased_at — DATE
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

support_info

  • support_id — BIGSERIAL — Primary key — NOT NULL
  • organization_name — VARCHAR(100)
  • title — VARCHAR(255)
  • content — TEXT
  • apply_start_date — DATE
  • apply_end_date — DATE
  • external_url — TEXT
  • status — VARCHAR(20)
  • view_count — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tasks

  • task_id — BIGSERIAL — Primary key — NOT NULL
  • registration_id — BIGINT — Foreign key → business_registrations.registration_id — NOT NULL
  • title — VARCHAR(100)
  • task_date — DATE — 할일의 경우 NULL 허용
  • task_time — TIME
  • is_completed — BOOLEAN — 'NULL 허용(일정/할일 구분) true=완료 / false=미완료',
  • source — VARCHAR(20) — 생성 출처: ai_generated / manual
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

terms

  • term_id — BIGSERIAL — Primary key — NOT NULL
  • type — VARCHAR(20)
  • version — VARCHAR(20)
  • content — TEXT
  • effective_date — DATE — '시행일자 화면 드롭다운 값',
  • is_required — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — 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 — TIMESTAMPTZ — NOT NULL

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(50)
  • nickname — VARCHAR(50)
  • kakao_id — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • email — VARCHAR(255)
  • profile_image_url — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — 탈퇴일시