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