kedu

Tables (11)

academy

  • academy_id — Primary key — NOT NULL
  • district_id — Foreign key → district.district_id — NOT NULL
  • academy_name

academy_comment

  • academy_comment_id — Primary key — NOT NULL
  • academy_id — Foreign key → academy.academy_id — NOT NULL
  • employee_outcome
  • comment
  • pros
  • cons
  • satisfaction
  • member_id — Foreign key → members.member_id — NOT NULL

board

  • board_id — INT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — VARCHAR(255)
  • reg_date — Date
  • member_id — Foreign key → members.member_id — NOT NULL
  • academy_id — Foreign key → academy.academy_id — NOT NULL
  • course_id — Foreign key → course.course_id — NOT NULL

board_comment

  • board_comment_id — INT — Primary key — NOT NULL
  • content — VARCHAR(255)
  • reg_date — Date
  • member_id — Foreign key → members.member_id — NOT NULL
  • board_id — INT — Foreign key → board.board_id — NOT NULL

course

  • course_id — Primary key — NOT NULL
  • academy_id — Foreign key → academy.academy_id — NOT NULL
  • couse_name
  • employee_outcome

course_comment

  • course_comment_id — Primary key — NOT NULL
  • course_id — Foreign key → course.course_id — NOT NULL
  • teacher
  • lecture
  • employee_outcome
  • ficilities
  • contents
  • member_id — Foreign key → members.member_id — NOT NULL

district

  • district_id — Primary key — NOT NULL
  • region_id — Foreign key → region.region_id — NOT NULL
  • district

members

  • member_id — Primary key — NOT NULL
  • academy_id — Foreign key → academy.academy_id — NOT NULL
  • course_id — Foreign key → course.course_id — NOT NULL

region

  • region_id — Primary key — NOT NULL
  • region

survey

  • survey_id — Primary key — NOT NULL
  • teacher
  • employee_outcome
  • facilities
  • contents
  • member_id — Foreign key → members.member_id — NOT NULL

survey_answer

  • survey_id — Foreign key → survey.survey_id — NOT NULL
  • teacher — INT
  • lecture — INT
  • employee_outcome — INT
  • facilities — INT
  • contents — INT