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 — 성적