pjt_day01

Tables (7)

GRADE (grade)

  • Key (ID) — INT — Primary key — NOT NULL
  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.Key — NOT NULL
  • Field (GRADE_FIRST_EXAM) — VARCHAR(3)
  • Field (GRADE_SECOND_EXAM) — VARCHAR(3)
  • Field (GRADE_THIRD_EXAM) — VARCHAR(3)
  • Field (GRADE_PROJECT) — VARCHAR(3)
  • Field (ALGORITHM_GRADE) — VARCHAR(20)
  • Field (ALGORITHM_ACQUISITION_DATE) — DATETIME

PROJECT01 (project01)

  • PK (PROJECT_NAME) — VARCHAR(50) — Primary key — NOT NULL
  • (PROJECT_DEPLOY_URL) — VARCHAR(50)
  • (PROJECT_CATEGORY)

REGION (region)

  • PK (ID) — INT — Primary key — NOT NULL
  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.Key — NOT NULL
  • PK (STUDENT_REGION) — VARCHAR(20) — Foreign key → TEACHER.PK — NOT NULL

STUDENT (student)

  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
  • (STUDENT_NAME) — VARCHAR(100)
  • (STUDENT_HP) — VARCHAR(20)
  • (STUDENT_AGE) — VARCHAR(5)
  • (STUDENT_GENDER) — VARCHAR(20)
  • (STUDENT_REGION) — VARCHAR(20)
  • (REG_USER) — VARCHAR(20)
  • (REG_DT) — DATETIME
  • (LAST_USER) — VARCHAR(20)
  • (LAST_DT) — DATETIME

STUDENT_PROJECT01 (student_proejct01)

  • Key (ID) — INT — Primary key — NOT NULL
  • FK (PROJECT_NAME) — VARCHAR(50) — Foreign key → PROJECT01.PK — NOT NULL
  • Key (STUDENT_ACOUNT) — VARCHAR(20) — Foreign key → STUDENT.Key — NOT NULL

TEACHER (teacher)

  • PK (REGION) — VARCHAR(20) — Primary key — NOT NULL
  • Field (TEACHER_ID) — VARCHAR(20)
  • (TEACHER_NAME) — VARCHAR(20)
  • (TEACHER_HP) — VARCHAR(20)

Untitled (attendance)

  • Key (ID) — INT — Primary key — NOT NULL
  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.Key — NOT NULL
  • Field (ATTENDANCE_1/1) — TINYINT(1)
  • Field (ATTENDANCE_1/1_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/1_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/2) — TINYINT(1)
  • Field (ATTENDANCE_1/2_SIGN_IN) — DATETIME
  • Field2 (ATTENDANCE_1/2_SIGN_OUT) — DATETIME
  • Field2 (ATTENDANCE_1/3) — TINYINT(1)
  • Field (ATTENDANCE_1/3_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/3_SIGN_OUT) — DATETIME
  • Field (이하생략)