BNKnowledgeMap

Tables (8)

Certification

  • certification_id — INT
  • certification_name — VARCHAR(200) — NOT NULL
  • issuing_organization — VARCHAR(100)
  • related_role — INT
  • difficulty — ENUM('Beginner', 'Intermediate', 'Advanced')

Course

  • course_id — INT
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • provider — VARCHAR(100)
  • link — VARCHAR(255)
  • related_role — INT
  • difficulty — ENUM('Beginner', 'Intermediate', 'Advanced')

JobRole

  • job_role_id — INT
  • role_name — VARCHAR(100) — NOT NULL
  • required_skills — TEXT
  • description — TEXT

Member

  • member_id — INT
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • join_date — DATETIME
  • interested_role — VARCHAR(100)
  • current_skills — TEXT
  • certifications — TEXT

MemberCertification

  • member_id — INT
  • certification_id — INT
  • acquisition_date — DATETIME
  • expiration_date — DATE

MemberCourseProgress

  • member_id — INT
  • course_id — INT
  • progress_status — ENUM('In Progress', 'Completed') — NOT NULL
  • start_date — DATETIME
  • completion_date — DATETIME

Roadmap

  • roadmap_id — INT
  • job_role_id — INT
  • title — VARCHAR(200) — NOT NULL
  • creation_date — DATETIME
  • description — TEXT

RoadmapStep

  • step_id — INT
  • roadmap_id — INT
  • step_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • recommended_course_id — INT
  • recommended_certification_id — INT