SSAFY_USER

Tables (7)

ALGORITHM

  • Key (ALGORITHM_ID) — AUTO INCREMENT — Primary key — NOT NULL
  • Field (ALGORITHM_GRADE) — DEFAULT NULL
  • Field (ALGORITHM_ACQUISITION_DATE) — DEFAULT NULL
  • Key (STUDENT_ID) — AUTO INCREMENT — Foreign key → STUDENT.Key — NOT NULL

ATTENDANCE

  • Key (ATTENDANCE_ID) — AUTO INCREMENT — Primary key — NOT NULL
  • Field (ATTENDANCE_TF) — DEFAULT NULL
  • Field (ATTENDANCE_SIGN_IN) — DEFAULT NULL
  • Field (ATTENDANCE_SIGN_OUT) — DEFAULT NULL
  • Key (STUDENT_ID) — AUTO INCREMENT — Foreign key → STUDENT.Key — NOT NULL

GROUP

  • Key (GROUP_ID) — AUTO INCREMENT — Primary key — NOT NULL
  • Field (STUDENT_GROUP) — NOT NULL

GROUP_TEACHER

  • Key (GROUP_TEACHER_ID) — AUTO INCREMENT — Primary key
  • Field (GROUP_TEACHER_NAME) — NOT NULL
  • Field (GROUP_TEACHER_HP) — NOT NULL
  • Key (REGION_ID) — AUTO INCREMENT — Foreign key → REGION.Key — NOT NULL

PROJECT

  • Key (PROJECT_ID) — AUTO INCREMENT — Primary key — NOT NULL
  • Field (PROJECT_GRADE) — DEFAULT NULL
  • Key (GROUP_ID) — AUTO INCREMENT — Foreign key → GROUP.Key — NOT NULL

REGION

  • Key (REGION_ID) — AUTO INCREMENT — Primary key — NOT NULL
  • Field (STUDENT_REGION) — DEFAULT NULL

STUDENT

  • Key (STUDENT_ID) — AUTO INCREMENT — Primary key — NOT NULL
  • Field (STUDENT_ACCOUNT) — NOT NULL
  • Field (STUDENT_NAME) — NOT NULL
  • Field (STUDENT_HP) — DEFAULT NULL
  • Field (STUDENT_AGE) — DEFAULT NULL
  • Field (STUDENT_GENDER) — DEFAULT NULL
  • Field (STUDENT_CURRICULUM) — DEFAULT NULL
  • Field (GRADE_FIRST_EXAM) — DEFAULT NULL
  • Field (GRADE_SECOND_EXAM) — DEFAULT NULL
  • Field (GRADE_THIRD_EXAM) — DEFAULT NULL
  • Field (REG_USER) — DEFAULT NULL
  • Field (REG_DT) — DEFAULT NULL
  • Field (LAST_USER) — DEFAULT NULL
  • Field (LAST_DT) — DEFAULT NULL
  • Key (REGION_ID) — AUTO INCREMENT — Foreign key → REGION.Key — NOT NULL
  • Key (GROUP_ID) — AUTO INCREMENT — Foreign key → GROUP.Key — NOT NULL