test
Tables (6)
algorithm
- 계정 (STUDENT_ACCOUNT) — varchar(20) — Foreign key → student.계정 — NOT NULL
- 선생님아이디 (TEACHER_ID) — varchar(20) — Foreign key → student.선생님아이디 — NOT NULL
- 선생님이름 (TEACHER_NAME) — varchar(20) — Foreign key → student.선생님이름 — NOT NULL
- 선생님전화번호 (TEACHER_HP) — varchar(20) — Foreign key → student.선생님전화번호 — NOT NULL
- 등급 (ALGORITHM_GRADE) — varchar(20)
- 취득일자 (ALGORITHM_ACQUISITION_DATE) — datetime
attendance
- 계정 (STUDENT_ACCOUNT) — varchar(20) — Foreign key → student.계정 — NOT NULL
- 선생님아이디 (TEACHER_ID) — varchar(20) — Foreign key → student.선생님아이디 — NOT NULL
- 선생님이름 (TEACHER_NAME) — varchar(20) — Foreign key → student.선생님이름 — NOT NULL
- 선생님전화번호 (TEACHER_HP) — varchar(20) — Foreign key → student.선생님전화번호 — NOT NULL
- ATTENDANCE_1/1 — tinyint(1)
- ATTENDANCE_1/1_SIGN_IN — datetime
- ATTENDANCE_1/1_SIGN_OUT — datetime
- ATTENDANCE_1/2 — tinyint(1)
- ATTENDANCE_1/2_SIGN_IN — datetime
- ATTENDANCE_1/2_SIGN_OUT — datetime
- ATTENDANCE_1/3 — tinyint(1)
- ATTENDANCE_1/3_SIGN_IN — datetime
- ATTENDANCE_1/3_SIGN_OUT — datetime
- ATTENDANCE_1/4 — tinyint(1)
- ATTENDANCE_1/4_SIGN_IN — datetime
- ATTENDANCE_1/4_SIGN_OUT — datetime
- ATTENDANCE_1/5 — tinyint(1)
- ATTENDANCE_1/5_SIGN_IN — datetime
- ATTENDANCE_1/5_SIGN_OUT — datetime
- ATTENDANCE_1/6 — tinyint(1)
- ATTENDANCE_1/6_SIGN_IN — datetime
- ATTENDANCE_1/6_SIGN_OUT — datetime
- ATTENDANCE_1/7 — tinyint(1)
- ATTENDANCE_1/7_SIGN_IN — datetime
- ATTENDANCE_1/7_SIGN_OUT — datetime
- ATTENDANCE_1/8 — tinyint(1)
- ATTENDANCE_1/8_SIGN_IN — datetime
- ATTENDANCE_1/8_SIGN_OUT — datetime
- ATTENDANCE_1/9 — tinyint(1)
- ATTENDANCE_1/9_SIGN_IN — datetime
- ATTENDANCE_1/9_SIGN_OUT — datetime
- ATTENDANCE_1/10 — tinyint(1)
- ATTENDANCE_1/10_SIGN_IN — datetime
- ATTENDANCE_1/10_SIGN_OUT — datetime
exam
- 계정 (STUDENT_ACCOUNT) — varchar(20) — Foreign key → student.계정 — NOT NULL
- 선생님아이디 (TEACHER_ID) — varchar(20) — Foreign key → student.선생님아이디 — NOT NULL
- 선생님이름 (TEACHER_NAME) — varchar(20) — Foreign key → student.선생님이름 — NOT NULL
- 선생님전화번호 (TEACHER_HP) — varchar(20) — Foreign key → student.선생님전화번호 — NOT NULL
- 1차시험 (FIRST_EXAM) — varchar(3)
- 2차시험 (SECOND_EXAM) — varchar(3)
- 3차시험 (THIRD_EXAM) — varchar(3)
project
- 프로젝트아이디 (PROJECT_ID) — varchar(20) — Primary key — NOT NULL
- 계정 (STUDENT_ACCOUNT) — varchar(20) — Foreign key → student.계정 — NOT NULL
- 선생님아이디 (TEACHER_ID) — varchar(20) — Foreign key → student.선생님아이디 — NOT NULL
- 선생님이름 (TEACHER_NAME) — varchar(20) — Foreign key → student.선생님이름 — NOT NULL
- 선생님전화번호 (TEACHER_HP) — varchar(20) — Foreign key → student.선생님전화번호 — NOT NULL
- 팀명 (PROJECT_NAME) — varchar(20)
- 프로젝트명 (PROJECT_TITLE) — varchar(20)
- 프로젝트내용 (PROJECT_CONTENT) — varchar(20)
student
- 계정 (STUDENT_ACCOUNT) — varchar(20) — Primary key — NOT NULL
- 선생님아이디 (TEACHER_ID) — varchar(20) — Foreign key → teacher.선생님아이디 — NOT NULL
- 선생님이름 (TEACHER_NAME) — varchar(20) — Foreign key → teacher.선생님이름 — NOT NULL
- 선생님전화번호 (TEACHER_HP) — varchar(20) — Foreign key → teacher.선생님전화번호 — NOT NULL
- 이름 (STUDENT_NAME) — varchar(100)
- 전화번호 (STUDENT_HP) — varchar(20)
- 나이 (STUDENT_AGE) — varchar(5)
- 성별 (STUDENT_GENDER) — varchar(20)
- 커리큘럼 (STUDENT_CURRICULUM) — varchar(20)
- 지역 (STUDENT_REGION) — varchar(20)
- 반 (STUDENT_GROUP) — varchar(20)
- 최초등록자 (REG_USER) — varchar(20)
- 최초등록일시 (REG_DT) — datetime
- 최종수정자 (LAST_USER) — varchar(20)
- 최종수정일시 (LAST_DT) — datetime
teacher
- 선생님아이디 (TEACHER_ID) — varchar(20) — Primary key — NOT NULL
- 선생님이름 (TEACHER_NAME) — varchar(20) — Primary key — NOT NULL
- 선생님전화번호 (TEACHER_HP) — varchar(20) — Primary key — NOT NULL