Finger_Print

Tables (4)

attendance_inf (학생들의 출석 데이터가 저장되는 테이블)

  • IDX (idx2) — int(11) — Foreign key → student_inf.IDX — NOT NULL
  • Student Number (std_num2) — varchar(20) — Foreign key → student_inf.Student Number
  • In Time (in_time) — time
  • Out Time (out_time) — time
  • When Created Data? (created) — timestamp
  • Attend (state_attend) — tinyint(1)
  • Late (state_late) — tinyint(1)
  • Early (state_early) — tinyint(1)
  • Absence (state_absence) — tinyint(1)

calendar_lunar_solar (2200년까지 모든 날짜 및 공휴일 데이터 테이블)

  • IDX (num) — int(11) — Primary key — NOT NULL
  • Date (solar_date) — date
  • Information about Day (memo) — varchar(50)
  • Was Created by Professor? (create) — tinyint(1)
  • Default Commuting Time (start_time) — time
  • Default Home Time (end_time) — time

professor_inf (교수님 관련 데이터 테이블)

  • IDX (idx) — int(11) — Primary key — NOT NULL
  • Professor Number (pfr_num) — varchar(20) — Primary key
  • Professor Name (pfr_name) — varchar(20)
  • Professor Password (pfr_password) — varchar(30)

student_inf (학생 관련 데이터 테이블)

  • IDX (idx) — int(11) — Primary key — NOT NULL
  • Student Number (std_num) — varchar(20) — Primary key
  • Student Name (std_name) — varchar(20)
  • Student Password (std_password) — varchar(20)
  • Finger Print Serial Number (serial_num) — varchar(30)