싸피0309ERD

테이블 (5)

attendence (Untitled4)

  • ATTENDENCE_NO (KEY) — 기본 키 — NOT NULL
  • STUDENT_ACCOUNT (Key) — 외래 키 → user.STUDENT_ACCOUNT — NOT NULL
  • DATE (Field)
  • SIGN_IN (Field2)
  • SIGN_OUT (Field3)
  • STUDENT_ACCOUNT (Field4)

grade (Untitled5)

  • GRADE_NO (Key) — 기본 키 — NOT NULL
  • STUDENT_ACCOUNT (Key2) — 외래 키 → user.STUDENT_ACCOUNT — NOT NULL
  • STUDENT_ACCOUNT (Field)
  • GRADE_CURRICULUM (Field2)
  • GRADE_FIRST_EXAM (Field3)
  • GRADE_SECOND_EXAM (Field4)
  • GRADE_THIRD_EXAM (Field5)
  • ALGORITHM_GRADE (Field6)
  • ALGORITHM_ACQUISITION_DATE (Field7)

teacher (Untitled3)

  • GROUP_TEACHER_ID (Key) — 기본 키 — NOT NULL
  • GROUP_TEACHER_NAME (Field)
  • GROUP_TEACHER_HP (Field2)

team (Untitled2)

  • TEAM_NO (Key) — 기본 키 — NOT NULL
  • TEAM_CODE (Field)
  • STUDENT_NAME (Field2)
  • POSITION (Field3)

user (Untitled)

  • STUDENT_ACCOUNT (Key) — 기본 키 — NOT NULL
  • STUDENT_NAME (Field)
  • STUDENT_HP (Field2)
  • STUDENT_AGE (Field3)
  • STUDENT_GENDER (Field4)
  • STUDENT__CURRICULUM (Field5)
  • STUDENT_REGION (Field6)
  • STUDENT_GROUP (Field7)
  • GROUP_TEACHER_ID (Field9)
  • REG_USER (Field11)
  • REG_DT (Field12)
  • LAST_USER (Field13)
  • LAST_DT (Field14)
  • TEAM_NO (Field8)
  • GRADE_NO (Field10)
  • TEAM_NO (Key2) — 외래 키 → team.TEAM_NO — NOT NULL
  • GROUP_TEACHER_ID (Key3) — 외래 키 → teacher.GROUP_TEACHER_ID — NOT NULL