mind_counselor
Tables (5)
mc_faq
- id — BIGINT
- user_id — BIGINT — NOT NULL — 작성 관리자
- category — VARCHAR(50) — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- order_num — INT
- created_at — DATETIME
- updated_at — DATETIME
mc_free_board
- id — BIGINT
- user_id — INT — Foreign key → mc_student.id — NOT NULL — 작성 학생 번호
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — DATETIME
mc_notice
- id — BIGINT
- user_id — BIGINT — NOT NULL — 작성 관리자
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- is_pinned — TINYINT
- view_count — INT
- created_at — DATETIME
- updated_at — DATETIME
mc_qna
- id — BIGINT
- user_id — INT — Foreign key → mc_student.id — NOT NULL — 질문 작성한 학생 번호
- answered_by — BIGINT — 답변 작성한 관리자 번호
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- answer — TEXT
- is_private — TINYINT
- status — VARCHAR(10)
- created_at — DATETIME
- answered_at — DATETIME
mc_student
- id — INT
- student_no — VARCHAR(30)
- password — VARCHAR(255)
- name — VARCHAR(30)
- registration_id — VARCHAR(18)
- birth — DATE
- gender — VARCHAR(1)
- email — VARCHAR(30)
- phone — VARCHAR(20)
- address — VARCHAR(400)
- id_photo_loc — VARCHAR(50)
- entrance_date — DATE
- grade — INT
- status — VARCHAR(20)
- nickname — VARCHAR(30)
- created_at — DATETIME