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