student

Tables (3)

Untitled (student)

  • Key (student_no) — char(8) — Primary key — NOT NULL
  • Field (student_name) — varchar2(30) — NOT NULL
  • Field2 (student_score) — number(3,2)
  • Field (student_major_name) — varchar2(50)

Untitled2 (subject)

  • Key (subject_no) — char(4) — Primary key — NOT NULL
  • Field (subject_name) — varchar2(50)
  • Field2 (subject_total_ea) — number

Untitled3 (sugang)

  • Key (student_no) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (subject_no) — char(4) — Foreign key → Untitled2.Key — NOT NULL
  • Field (sugang_register_date) — date