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 — 탈퇴일시