test1202

Tables (15)

ai_entity_summary

  • id — BIGINT
  • entity_type — VARCHAR(50) — NOT NULL
  • entity_id — BIGINT — NOT NULL
  • summary_type — VARCHAR(50) — NOT NULL
  • summary — TEXT — NOT NULL
  • model — VARCHAR(100)
  • metadata — JSON
  • version — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • INDEX — idx_ai_entity

board

  • id — BIGINT
  • project_id — BIGINT — Foreign key → project.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

board_column

  • id — BIGINT
  • board_id — BIGINT — Foreign key → board.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • status_key — VARCHAR(50)
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_board_column_sort

chat_ai_summary

  • id — BIGINT
  • thread_id — BIGINT — Foreign key → chat_thread.id — NOT NULL
  • summary — TEXT — NOT NULL
  • version — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_summary_thread

chat_message

  • id — BIGINT
  • thread_id — BIGINT — Foreign key → chat_thread.id — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • message_type — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_thread_time

chat_thread

  • id — BIGINT
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_thread_target

project

  • id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • owner_id — BIGINT — NOT NULL
  • is_archived — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

schedule_event

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • owner_id — BIGINT — NOT NULL
  • related_task_id — BIGINT — Foreign key → task.id
  • location — VARCHAR(255)
  • is_all_day — TINYINT — NOT NULL
  • ai_created — TINYINT — NOT NULL
  • is_deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_schedule_owner
  • INDEX — idx_schedule_related_task

schedule_link

  • id — BIGINT
  • schedule_id — BIGINT — Foreign key → schedule_event.id — NOT NULL
  • url — VARCHAR(1000) — NOT NULL
  • label — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

task

  • id — BIGINT
  • project_id — BIGINT — Foreign key → project.id — NOT NULL
  • task_type — VARCHAR(30) — NOT NULL
  • parent_task_id — BIGINT — Foreign key → task.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL
  • priority — VARCHAR(20) — NOT NULL
  • due_date — DATE
  • reporter_id — BIGINT — NOT NULL
  • main_flag — TINYINT — NOT NULL
  • ai_created — TINYINT — NOT NULL
  • is_deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_task_project_status
  • INDEX — idx_task_due
  • INDEX — idx_task_parent

task_assignee

  • user_id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key → task.id — NOT NULL
  • assigned_at — DATETIME — NOT NULL
  • INDEX — idx_user_assign

task_board_status

  • task_id — BIGINT — Foreign key → task.id — NOT NULL
  • board_id — BIGINT — Foreign key → board.id — NOT NULL
  • column_id — BIGINT — Foreign key → board_column.id — NOT NULL
  • position — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_column_position

task_link

  • id — BIGINT
  • task_id — BIGINT — Foreign key → task.id — NOT NULL
  • url — VARCHAR(1000) — NOT NULL
  • label — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

task_relation

  • id — BIGINT
  • from_task_id — BIGINT — Foreign key → task.id — NOT NULL
  • to_task_id — BIGINT — Foreign key → task.id — NOT NULL
  • relation_type — VARCHAR(50) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_task_relation_from
  • INDEX — idx_task_relation_to

user

  • id — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • is_active — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL