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