대전_2반_서현택_Day01_DB프로젝트

테이블 (4)

Untitled (STUDENT)

  • Key (STUDENT_ACCOUNT) — 기본 키 — NOT NULL
  • Key (STUDENT_REGION) — 외래 키 → Untitled.Key — NOT NULL
  • Field (STUDENT_NAME)
  • Field (STUDENT_HP)
  • Field (STUDENT_AGE)
  • Field (STUDENT_GENDER)
  • Field (STUDENT_CURRICULUM)
  • Field (GRADE_FIRST_EXAM)
  • Field (GRADE_SECOND_EXAM)
  • Field (GRADE_THIRD_EXAM)
  • Field (ALGORITHM_GRADE)
  • Field (ALGORITHM_ACQUISTION_DATE)
  • Field (ATTENDANCE_1/N)
  • Field (ATTENDANCE_1/N_SIGN_IN)
  • Field (ATTENDANCE_1/N_SIGN_OUT)
  • Field (REG_USER)
  • Field (REG_DT)
  • Field (LAST_USER)
  • Field (LAST_DT)

Untitled (REGION)

  • Key (STUDENT_REGION) — 기본 키 — NOT NULL
  • Field (STUDENT_GROUP)

Untitled (TEACHER)

  • Key (GROUP_TEACHER_ID) — 기본 키 — NOT NULL
  • Key (STUDENT_REGION) — 외래 키 → Untitled.Key — NOT NULL
  • Field (GROUP_TEACHER_NAME)
  • Field (GROUP_TEACHER_HP)

Untitled (PROJECT)

  • Key (PROJECT_ID) — 기본 키 — NOT NULL
  • Key (STUDENT_ACCOUNT) — 외래 키 → Untitled.Key — NOT NULL
  • Key (STUDENT_REGION) — 외래 키 → Untitled.Key — NOT NULL
  • Field (PROJECT_NAME)
  • Field (PROJECT_GRADE)