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