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