Troublog
Tables (15)
ai_summaries
- summary_id — INT
- troubleshooting_id — INT — NOT NULL
- summary_type_id — INT — NOT NULL
- summary_content — LONGTEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
category_fields
- field_id — INT
- field_name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
category_tags
- tag_id — INT
- field_id — INT — NOT NULL
- tag_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
comments
- comment_id — INT
- troubleshooting_id — INT — NOT NULL
- user_id — INT — NOT NULL
- parent_comment_id — INT
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_troubleshooting_created
- INDEX — idx_parent_comment — parent_comment_id
error_types
- error_type_id — INT
- error_name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
follows
- follow_id — INT
- follower_id — INT — NOT NULL
- following_id — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- CHECK — (follower_id != following_id)
likes
- like_id — INT
- user_id — INT — NOT NULL
- troubleshooting_id — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
notification_types
- type_id — INT
- type_name — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
notifications
- notification_id — INT
- user_id — INT — NOT NULL
- type_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- message — TEXT — NOT NULL
- reference_id — INT
- is_read — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_unread
projects
- project_id — INT
- user_id — INT — NOT NULL
- project_name — VARCHAR(200) — NOT NULL
- description — TEXT
- thumbnail_url — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_project
summary_types
- summary_type_id — INT
- type_name — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
troubleshooting_tags
- troubleshooting_tag_id — INT
- troubleshooting_id — INT — NOT NULL
- tag_id — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
troubleshootings
- troubleshooting_id — INT
- user_id — INT — NOT NULL
- project_id — INT — NOT NULL
- error_type_id — INT — NOT NULL
- title — VARCHAR(300) — NOT NULL
- content — LONGTEXT — NOT NULL
- thumbnail_url — VARCHAR(500)
- status — ENUM('writing', 'completed', 'summarized') — NOT NULL
- visibility — ENUM('public', 'private') — NOT NULL
- importance_rating — INT
- view_count — INT
- is_template — BOOLEAN
- completed_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_status
- INDEX — idx_visibility_created
- INDEX — idx_project_status
user_activities
- activity_id — INT
- user_id — INT — NOT NULL
- activity_type — ENUM('view', 'search', 'like', 'comment') — NOT NULL
- reference_id — INT
- search_keyword — VARCHAR(200)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_activity
- INDEX — idx_search_keyword
users
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- field — VARCHAR(100)
- bio — TEXT
- github_url — VARCHAR(255)
- profile_image_url — VARCHAR(500)
- login_type — ENUM('email', 'kakao') — NOT NULL
- social_id — VARCHAR(100)
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_email
- INDEX — idx_social