self-online day1

Tables (5)

Attendance (출석)

  • auto_key (INT) — Primary key — NOT NULL
  • student_account (학생 아이디) — varchar(100) — Foreign key → Student.student_account — NOT NULL
  • ATTENDANCE_Type (출석유형) — INT
  • ATTENDANCE_DATE (출석날짜) — DATETIME
  • ATTENDANCE_SIGN_IN (출석시간) — DATETIME
  • ATTENDANCE_SIGN_OUT (퇴실시간) — DATETIME

Grade (시험점수)

  • student_account (학생 아이디) — varchar(100) — Foreign key → Student.student_account — NOT NULL
  • grade_first_exam (1번째 시험점수) — INT
  • grade_second_exam (2번째 시험점수) — INT
  • grade_third_exam (3번째 시험점수) — INT
  • algorithm_grade (알고리즘 시험점수) — varchar(2)
  • ALGORITHM_ACQUISITION_DATE (Field) — DATETIME

Reg (등록)

  • student_account (학생 아이디) — varchar(100) — Foreign key → Student.student_account — NOT NULL
  • REG_USER (생성자) — varchar(100)
  • REG_DT (생성일시) — DATETIME
  • LAST_USER (수정자) — varchar(100)
  • LAST_DT (수정일시) — DATETIME

Student (학생)

  • student_account (학생 아이디) — varchar(100) — Primary key — NOT NULL
  • group_teacher_id (교사 아이디) — varchar(100) — Foreign key → Teacher.group_teacher_id — NOT NULL
  • student_name (이름) — varchar(20)
  • student_hp (전화번호) — INT
  • student_age (나이) — INT
  • student_gender (성별) — varchar(1)
  • student_curriculum (커리큘럼) — TINYINT
  • student_region (지역) — varchar
  • student_group (그룹) — TINYINT

Teacher (교사)

  • group_teacher_id (교사 아이디) — varchar(100) — Primary key — NOT NULL
  • group_teacher_name (교사 이름) — varchar(20)
  • group_teahcer_hp (전화번호) — INT