MeetUDB
Tables (11)
evaluation_scores
- id — INT
- evaluation_id — VARCHAR(50) — NOT NULL
- score_type — VARCHAR(50) — NOT NULL
- score_value — INT — NOT NULL
- created_at — DATE
- id (id2) — VARCHAR(50) — Foreign key → evaluations.id
evaluations
- id — VARCHAR(50) — Primary key
- user_id — VARCHAR(50) — NOT NULL
- candidate_name — VARCHAR(100) — NOT NULL
- position — VARCHAR(100) — NOT NULL
- date — DATE — NOT NULL
- visit_reason — TEXT
- coaching_direction — TEXT
- notes — TEXT
- approved — BOOLEAN
- admin_comment — TEXT — EX
- mentor_id — VARCHAR(50)
- mentor_comment — TEXT — EXT NUL
- created_at — DATE
- updated_at — DATE
- id (id2) — VARCHAR(50) — Foreign key → users.id
guestbook
- id — VARCHAR(50) — Primary key
- author — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- visible — BOOLEAN
- created_at — DATE
- updated_at — DATE
inquiries
- id — VARCHAR(50) — Primary key
- user_id — VARCHAR(50)
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- subject — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('pending', 'answered', 'closed')
- admin_response — TEXT
- admin_responded_at — DATE
- created_at — DATE
- updated_at — DATE
- id (id2) — VARCHAR(50) — Foreign key → users.id
mock_interview_submissions
- id — VARCHAR(50) — Primary key
- user_id — VARCHAR(50) — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- user_email — VARCHAR(255) — NOT NULL
- type — ENUM('recording', 'ai-feedback', 'custom-questions', 'interview-detail') — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — JSON
- approved — BOOLEAN
- admin_comment — TEXT — EX
- submitted_at — DATE
- updated_at — DATE
- id (id2) — VARCHAR(50) — Foreign key → users.id
question_answers
- id — VARCHAR(50)
- question_id — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50)
- user_name — VARCHAR(100)
- content — TEXT — NOT NULL
- admin_response — TEXT
- admin_responded_at — DATE
- created_at — DATE
- updated_at — DATE
- id (id2) — VARCHAR(50) — Foreign key → reviews.id
- id (id3) — VARCHAR(50) — Foreign key → questions.id
questions
- id — VARCHAR(50) — Primary key
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- user_id — VARCHAR(50)
- content — TEXT — NOT NULL
- views — INT
- answers — INT
- solved — BOOLEAN
- visible — BOOLEAN
- admin_answer — TEXT
- admin_answered_at — DATE
- created_at — DATE
- updated_at — DATE
- id (id2) — VARCHAR(50) — Foreign key → users.id
review_likes
- id — INT
- review_id — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- created_at — DATE
- id (id2) — VARCHAR(50) — Foreign key → mock_interview_submissions.id
reviews
- id — VARCHAR(50) — Primary key
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- user_id — VARCHAR(50)
- company — VARCHAR(100) — NOT NULL
- position — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- views — INT
- likes — INT
- visible — BOOLEAN
- created_at — DATE
- updated_at — DATE
- id (id2) — VARCHAR(50) — Foreign key → users.id
users
- id — VARCHAR(50) — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — ENUM('user', 'admin', 'mentor')
- created_at — DATE
- updated_at — DATE
visitor_stats
- id — INT — Primary key
- date — DATE — NOT NULL
- visitor_count — INT
- visitor_ids — JSON
- last_reset — DATE
- updated_at — DATE