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