싸피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