190309
Tables (6)
Untitled (region)
- Key (id) — int — Primary key — NOT NULL — regionidx
- Field (region_name) — varchar(20) — NOT NULL — 지역이름
Untitled (class)
- Key (id) — int — Primary key — NOT NULL — classidx
- Field (class_number) — int — NOT NULL — 반번호
- Key (class_teacher) — int — Foreign key → Untitled.Key — NOT NULL — teacheridx
- Key (class_region) — int — Foreign key → Untitled.Key — NOT NULL — regionidx
Untitled (teacher)
- Key (id) — int — Primary key — NOT NULL — teacheridx
- Field (teacher_name) — varchar(100) — NOT NULL — 교수이름
- Field (teacher_hp) — varchar(20) — 교수전화번호
- Field (teacher_id) — varchar(100) — NOT NULL — 교수아이디
Untitled (grade)
- Key (id) — int — Primary key — NOT NULL — gradeidx
- Field (grade_first_exam) — int — 1학기성적1
- Field (grade_second_exam) — int — 1학기성적2
- Field (grade_third_exam) — int — 1학기성적3
- Field (algorithm_grade) — varchar(5) — 알고리즘성적
- Field (algorithm_date) — date — 알고리즘취득날짜
- Field (grade_first_project) — int — 2학기성적1
- Field (grade_second_project) — int — 2학기성적2
- Field (grade_third_project) — int — 2학기성적3
Untitled (attendance)
- Key (id) — int — Primary key — NOT NULL — attendanceidx
- Field (attendance_date) — date — 출석일
- Field (attendance_signin) — datetime — 출근시간
- Field (attendance_signout) — datetime — 퇴근시간
- Field (attendance_check) — tinyint — 출석여부
- Key (attendance_studentid) — int — Foreign key → user.Key — NOT NULL — studentidx
user (student)
- Key (id) — int — Primary key — NOT NULL — studentidx
- Field (student_account) — varchar(20) — NOT NULL — 아이디
- Field (student_name) — varchar(100) — NOT NULL — 이름
- Field (student_hp) — varchar(20) — 전화번호
- Field (student_age) — int — 나이
- Field (student_gender) — varchar(5) — 성별
- Field (student_curriculum) — int — 기수
- Key (student_region) — int — Foreign key → Untitled.Key — 지역
- Key (student_class) — int — Foreign key → Untitled.Key — 반
- Field (student_regdate) — datetime — NOT NULL — 가입시간
- Field (student_logdate) — datetime — 마지막로그인시간
- Field (student_logip) — varchar(100) — 마지막로그인IP
- Key (student_grade) — int — Foreign key → Untitled.Key — NOT NULL — 성적