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