DevBridge_ver2
Tables (16)
attachments
- id — UUID
- post_id — UUID — Foreign key → posts.id — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_url — VARCHAR(1000) — NOT NULL
- file_size_kb — INT
- created_at — TIMESTAMP
chat_messages
- id — UUID
- session_id — UUID — Foreign key → chat_sessions.id — NOT NULL
- sender_type — VARCHAR(50) — NOT NULL — USER, AI, HUMAN
- content — TEXT — NOT NULL
- intent_type — VARCHAR(100) — 질문 의도 분류
- created_at — TIMESTAMP
chat_sessions
- id — UUID
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- session_title — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
comments
- id — UUID
- post_id — UUID — Foreign key → posts.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
data_sources
- id — UUID
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
- source_type — VARCHAR(50) — NOT NULL — GIT, FIGMA, DOC 등
- status — VARCHAR(50) — NOT NULL — 연동 상태 (SYNCING, SUCCESS, FAILED)
- sync_error_log — TEXT — 동기화 실패 에러 로그
- created_at — TIMESTAMP
human_reviews
- id — UUID
- feedback_id — UUID — Foreign key → message_feedbacks.id — NOT NULL
- assigned_user_id — UUID — Foreign key → users.id
- status — VARCHAR(50) — NOT NULL — PENDING, RESOLVED
- resolved_at — TIMESTAMP
- created_at — TIMESTAMP
knowledge_documents
- id — UUID
- source_id — UUID — Foreign key → data_sources.id — NOT NULL
- document_title — VARCHAR(255) — NOT NULL
- vector_id — VARCHAR(255) — Vector DB 매핑용 ID
- last_synced_at — TIMESTAMP
message_citations
- id — UUID
- message_id — UUID — Foreign key → chat_messages.id — NOT NULL
- document_id — UUID — Foreign key → knowledge_documents.id — NOT NULL
- similarity_score — DECIMAL(5, 4) — RAG 검색 유사도/신뢰도
message_feedbacks
- id — UUID
- message_id — UUID — Foreign key → chat_messages.id — NOT NULL
- is_helpful — BOOLEAN
- needs_human_review — BOOLEAN
- feedback_note — TEXT
- created_at — TIMESTAMP
notifications
- id — UUID
- user_id — UUID — Foreign key → users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL — HUMAN_REVIEW_REQ, MEETING_SYNC 등
- reference_id — UUID — 관련 엔티티의 ID
- is_read — BOOLEAN
- created_at — TIMESTAMP
posts
- id — UUID
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
- author_id — UUID — Foreign key → users.id — NOT NULL
- category — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
schedule_attendees
- id — UUID
- schedule_id — UUID — Foreign key → smart_schedules.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- response_status — VARCHAR(50) — NOT NULL — PENDING, ACCEPTED, DECLINED
- UNIQUE(schedule_id, — user_id)
smart_schedules
- id — UUID
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- proposed_times — JSONB — 제안된 후보 시간대 배열
- confirmed_time — TIMESTAMP
- status — VARCHAR(50) — NOT NULL — PENDING, CONFIRMED, CANCELLED
- created_at — TIMESTAMP
users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(50) — NOT NULL — 시스템 권한 (ADMIN, USER 등)
- created_at — TIMESTAMP
workspace_members
- id — UUID
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- member_role — VARCHAR(50) — NOT NULL — 워크스페이스 내 권한 (OWNER, MEMBER, VIEWER)
- joined_at — TIMESTAMP
- UNIQUE(workspace_id, — user_id)
workspaces
- id — UUID
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP