ssafy_user
Tables (8)
attendance
- ATTENDANCE_NO — int — Primary key — NOT NULL
- STUDENT_NO — int — Foreign key → student.STUDENT_NO — NOT NULL
- ATTENDANCE_DATE — datetime
- ATTENDANCE_SIGN_IN — datetime
- ATTENDANCE_SIGN_OUT — datetime
grade
- GRADE_NO — int — Primary key — NOT NULL
- STUDENT_NO — int — Foreign key → student.STUDENT_NO — NOT NULL
- SUBJECT_NO — int — Foreign key → subject.SUBJECT_NO — NOT NULL
- GRADE_SCORE — varchar(3)
project_category
- PROJECT_CATEGORY_NO — int — Primary key — NOT NULL
- PROJECT_CATEGORY_NAME — varchar(20)
- PROJECT_CATEGORY_PROCESS — varchar(20)
project_group
- PROJECT_GROUP_NO — int — Primary key — NOT NULL
- PROJECT_CATEGORY_NO — int — Foreign key → project_category.PROJECT_CATEGORY_NO — NOT NULL
- PROJECT_GROUP_REGION — varchar(20)
- PROJECT_GROUP_NAME — varchar(20)
project_organization
- PROJECT_ORGANIZATION_NO — int — Primary key — NOT NULL
- STUDENT_NO — int — Foreign key → student.STUDENT_NO — NOT NULL
- PROJECT_GROUP_NO — int — Foreign key → project_group.PROJECT_GROUP_NO — NOT NULL
student
- STUDENT_NO — int — Primary key — NOT NULL
- STUDENT_ACCOUNT — varchar(20) — NOT NULL
- STUDENT_NAME — varchar(100) — NOT NULL
- STUDENT_HP — varchar(20)
- STUDENT_AGE — varchar(5)
- STUDENT_GENDER — varchar(20)
- STUDENT_CURRICULUM — varchar(20)
- STUDENT_REGION — varchar(20)
- STUDENT_GROUP — varchar(20) — NOT NULL
- ALGORITHM_GRADE — varchar(20)
- ALGORITHM_ACQUISITION_DATE — datetime
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime
- TEACHER_NO — int — Foreign key → teacher.TEACHER_NO — NOT NULL
subject
- SUBJECT_NO — int — Primary key — NOT NULL
- SUBJECT_NAME — varchar(20)
- SUBJECT_DATE — datetime
teacher
- TEACHER_NO — int — Primary key — NOT NULL
- TEACHER_ID — varchar(20) — NOT NULL
- TEACHER_NAME — varchar(20) — NOT NULL
- TEACHER_HP — varchar(20) — NOT NULL