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