bk21
Tables (4)
td_faculty
- faculty_id — int(11) — Primary key — NOT NULL
- faculty_sort — varchar(20)
- faculty_name — varchar(50)
- faculty_native — varchar(50)
- faculty_start_date — datetime
- faculty_end_date — datetime
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
td_participation
- participation_id — int(11) — Primary key — NOT NULL
- participation_sort — varchar(20) — NOT NULL
- participation_year — varchar(20) — NOT NULL
- participation_master_all — int(11)
- participation_master_participate — int(11)
- participation_master_participate_rate — int(11)
- participation_doctor_all — int(11)
- participation_doctor_participate — int(11)
- participation_doctor_participate_rate — int(11)
- participation_master_doctor_all — int(11)
- participation_master_doctor_participate — int(11)
- participation_master_doctor_participate_rate — int(11)
- participation_sum_all — int(11)
- participation_sum_participate — int(11)
- participation_sum_participate_rate — int(11)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
td_professor
- professor_id — int(11) — Primary key — NOT NULL
- professor_name — varchar(20)
- professor_field — varchar(20)
- professor_contact — varchar(20)
- professor_email — varchar(50)
- professor_address — varchar(100)
- professor_img — varchar(100)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
td_student
- student_id — int(11) — Primary key — NOT NULL
- student_name — text
- student_sort — varchar(20)