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