webservice_project
Tables (13)
approvals
- approval_id — CHAR(36)
- target_type — VARCHAR(50)
- target_id — CHAR(36) — NOT NULL
- approver_id — CHAR(36) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- comments — TEXT
- processed_at — TIMESTAMP
assignments
- assignment_id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- module_id — CHAR(36) — NOT NULL
- submission_content — TEXT
- submitted_at — TIMESTAMP
contents
- content_id — CHAR(36)
- title — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(50)
- s3_url — VARCHAR(500)
- vector_db_collection_name — VARCHAR(100)
- created_at — TIMESTAMP
curriculums
- id — CHAR(36)
- goal_id — VARCHAR(100) — NOT NULL
- employee_id — VARCHAR(100) — NOT NULL
- employee_name — VARCHAR(100) — NOT NULL
- department — VARCHAR(100) — NOT NULL
- role — VARCHAR(100) — NOT NULL
- career_level — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- total_weeks — INT
- status — VARCHAR(20) — NOT NULL
- revision_note — TEXT
- version — INT
- created_at — DATETIME
- updated_at — DATETIME
feedback
- id — CHAR(36)
- session_id — CHAR(36) — NOT NULL
- employee_id — VARCHAR(100) — NOT NULL
- feedback_type — VARCHAR(30) — NOT NULL
- score — FLOAT
- max_score — FLOAT
- passed — BOOLEAN
- summary — TEXT
- strengths — TEXT
- weaknesses — TEXT
- recommendations — TEXT
- detail — TEXT
- is_anomaly — BOOLEAN
- anomaly_type — VARCHAR(100)
- created_at — DATETIME
goals
- id — CHAR(36)
- employee_id — VARCHAR(100) — NOT NULL
- employee_name — VARCHAR(100) — NOT NULL
- department — VARCHAR(100) — NOT NULL
- role — VARCHAR(100) — NOT NULL
- career_level — VARCHAR(50) — NOT NULL
- experience_years — INT
- skills — TEXT — NOT NULL
- goals — TEXT
- status — VARCHAR(20) — NOT NULL
- rejection_reason — TEXT
- created_at — DATETIME
- updated_at — DATETIME
growth_reports
- report_id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- report_period — VARCHAR(50)
- strengths — TEXT
- weaknesses — TEXT
- mentoring_guide — TEXT
- generated_at — TIMESTAMP
learning_activities
- id — CHAR(36)
- employee_id — VARCHAR(100) — NOT NULL
- session_id — VARCHAR(100)
- activity_type — VARCHAR(100) — NOT NULL
- module_id — VARCHAR(100)
- score — FLOAT
- duration_minutes — INT
- metadata — TEXT
- logged_at — DATETIME
learning_progress
- progress_id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- module_id — CHAR(36) — NOT NULL
- status — VARCHAR(50)
- completion_rate — DECIMAL(5,2)
- last_accessed_at — TIMESTAMP
modules
- id — CHAR(36)
- curriculum_id — CHAR(36) — NOT NULL
- week_number — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- content — TEXT
- learning_objectives — TEXT
- resources — TEXT
- assignments — TEXT
- estimated_hours — INT
- created_at — DATETIME
profiles
- profile_id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- job_role — VARCHAR(100)
- resume_summary — TEXT
- updated_at — TIMESTAMP
tutor_sessions
- id — CHAR(36)
- employee_id — VARCHAR(100) — NOT NULL
- employee_name — VARCHAR(100) — NOT NULL
- curriculum_id — VARCHAR(100)
- module_id — VARCHAR(100)
- module_title — VARCHAR(200)
- session_type — VARCHAR(20) — NOT NULL
- messages — TEXT
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
users
- user_id — CHAR(36)
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP