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