DevBridge_ver.4
Tables (19)
CHAT_MESSAGES
- id — VARCHAR(36)
- session_id — VARCHAR(36) — Foreign key → CHAT_SESSIONS.id — NOT NULL
- sender_type — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- prompt_tokens — INT
- completion_tokens — INT
- created_at — DATETIME — NOT NULL
CHAT_SESSIONS
- id — VARCHAR(36)
- workspace_id — VARCHAR(36) — Foreign key → WORKSPACES.id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- session_title — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
DATABASE_SCHEMAS
- id — VARCHAR(36)
- source_id — VARCHAR(36) — Foreign key → DATA_SOURCES.id — NOT NULL
- db_name — VARCHAR(100) — NOT NULL
- schema_ddl — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
DATA_SOURCES
- id — VARCHAR(36)
- workspace_id — VARCHAR(36) — Foreign key → WORKSPACES.id — NOT NULL
- source_type — VARCHAR(50) — NOT NULL
- source_name — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
GIT_COMMITS
- id — VARCHAR(36)
- source_id — VARCHAR(36) — Foreign key → DATA_SOURCES.id — NOT NULL
- author_id — VARCHAR(36) — Foreign key → USERS.id
- commit_hash — VARCHAR(100) — NOT NULL
- commit_message — TEXT — NOT NULL
- pushed_at — DATETIME — NOT NULL
KNOWLEDGE_DOCUMENTS
- id — VARCHAR(36)
- source_id — VARCHAR(36) — Foreign key → DATA_SOURCES.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- vector_id — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
MESSAGE_CITATIONS
- id — VARCHAR(36)
- message_id — VARCHAR(36) — Foreign key → CHAT_MESSAGES.id — NOT NULL
- document_id — VARCHAR(36) — Foreign key → KNOWLEDGE_DOCUMENTS.id
- db_schema_id — VARCHAR(36) — Foreign key → DATABASE_SCHEMAS.id
- git_commit_id — VARCHAR(36) — Foreign key → GIT_COMMITS.id
- vector_chunk_id — VARCHAR(255)
- similarity_score — DECIMAL(5, 4)
NOTIFICATIONS
- id — VARCHAR(36)
- user_id — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- reference_id — VARCHAR(36)
- is_read — BOOLEAN
- created_at — DATETIME — NOT NULL
OWNER_CONFIRMATIONS
- id — VARCHAR(36)
- workspace_id — VARCHAR(36) — Foreign key → WORKSPACES.id — NOT NULL
- task_id — VARCHAR(36) — Foreign key → TASKS.id
- question_message_id — VARCHAR(36) — Foreign key → CHAT_MESSAGES.id — NOT NULL
- assigned_owner_id — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- status — VARCHAR(50) — NOT NULL
- answer_content — TEXT
- is_faq — BOOLEAN
- target_role — VARCHAR(100)
- answered_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
SCHEDULE_ATTENDEES
- id — VARCHAR(36)
- schedule_id — VARCHAR(36) — Foreign key → SMART_SCHEDULES.id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- available_times — JSON
- response_status — VARCHAR(50) — NOT NULL
SCHEDULE_REFERENCES
- id — VARCHAR(36)
- schedule_id — VARCHAR(36) — Foreign key → SMART_SCHEDULES.id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- reference_type — VARCHAR(50) — NOT NULL
- document_id — VARCHAR(36) — Foreign key → KNOWLEDGE_DOCUMENTS.id
- file_url — VARCHAR(1000)
- title — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
SMART_SCHEDULES
- id — VARCHAR(36)
- workspace_id — VARCHAR(36) — Foreign key → WORKSPACES.id — NOT NULL
- requester_id — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- top_candidate_times — JSON
- confirmed_time — DATETIME
- meeting_link — VARCHAR(1000)
- ai_summary — TEXT
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
TASKS
- id — VARCHAR(36)
- workspace_id — VARCHAR(36) — Foreign key → WORKSPACES.id — NOT NULL
- requester_id — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- assignee_id — VARCHAR(36) — Foreign key → USERS.id
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- status — VARCHAR(50) — NOT NULL
- due_date — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
TASK_DELIVERABLES
- id — VARCHAR(36)
- task_id — VARCHAR(36) — Foreign key → TASKS.id — NOT NULL
- submitted_by — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- file_url — VARCHAR(1000) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
TASK_STATUS_LOGS
- id — VARCHAR(36)
- task_id — VARCHAR(36) — Foreign key → TASKS.id — NOT NULL
- status — VARCHAR(50) — NOT NULL
- changed_by — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- created_at — DATETIME — NOT NULL
USERS
- id — VARCHAR(36)
- employee_id — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- auth_provider — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- position — VARCHAR(100)
- system_role — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
WORKSPACES
- id — VARCHAR(36)
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
WORKSPACE_INVITATIONS
- id — VARCHAR(36)
- workspace_id — VARCHAR(36) — Foreign key → WORKSPACES.id — NOT NULL
- invited_email — VARCHAR(255) — NOT NULL
- invited_by — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- assigned_role — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
WORKSPACE_MEMBERS
- id — VARCHAR(36)
- workspace_id — VARCHAR(36) — Foreign key → WORKSPACES.id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → USERS.id — NOT NULL
- member_role — VARCHAR(50) — NOT NULL
- joined_at — DATETIME — NOT NULL