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)