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