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)