skilweaver

Tables (10)

learning_goal

  • learning_goal_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • due_date — DATE
  • priority — VARCHAR(20) — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • target_track — VARCHAR(20) — NOT NULL
  • experience_level — VARCHAR(20) — NOT NULL
  • daily_minutes — INT — NOT NULL
  • prefer_korean — TINYINT(1) — NOT NULL
  • learning_style — VARCHAR(20) — NOT NULL
  • weekend_boost — TINYINT(1) — NOT NULL

member_skill

  • member_skill_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • technology_id — BIGINT
  • custom_name — VARCHAR(100)
  • level — VARCHAR(50) — NOT NULL
  • years_of_use — DOUBLE — NOT NULL
  • last_used_at — DATE
  • note — TEXT

tech_prerequisite

  • tech_prerequisite_id — BIGINT — Primary key — NOT NULL
  • knowledge_id — BIGINT — NOT NULL
  • prerequisite_key — VARCHAR(100) — NOT NULL

tech_relationship

  • tech_relationship_id — BIGINT — Primary key — NOT NULL
  • from_id — BIGINT — NOT NULL
  • to_id — BIGINT — NOT NULL
  • relation_type — VARCHAR(20) — NOT NULL
  • weight — INT — NOT NULL

tech_use_case

  • tech_use_case_id — BIGINT — Primary key — NOT NULL
  • knowledge_id — BIGINT — NOT NULL
  • use_case — VARCHAR(255) — NOT NULL

technology

  • technology_id — BIGINT — Primary key — NOT NULL
  • key — VARCHAR(100) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • ecosystem — VARCHAR(100)
  • official_site — VARCHAR(255)
  • active — TINYINT(1) — NOT NULL

technology_edit

  • technology_edit_id — BIGINT — Primary key — NOT NULL
  • technology_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • proposed_summary — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

technology_edit_prerequisite

  • technology_edit_prerequisite_id — BIGINT — Primary key — NOT NULL
  • edit_id — BIGINT — NOT NULL
  • prerequisite — VARCHAR(100) — NOT NULL

technology_knowledge

  • technology_knowledge_id — BIGINT — Primary key — NOT NULL
  • technology_id — BIGINT — NOT NULL
  • summary — TEXT
  • learning_tips — TEXT
  • source_type — VARCHAR(20) — NOT NULL