univ

Tables (5)

class_list (Untitled5)

  • s_id (Key) — int — Foreign key → student.s_id — NOT NULL
  • l_num (Key2) — integer — Foreign key → lecture.l_num
  • p_id (Key3) — varchar(10) — Foreign key → professor.p_id — NOT NULL
  • 출석점수 (Field) — int — NOT NULL
  • 중간점수 (Field2) — varchar(1) — NOT NULL
  • 기말점수 (Field3) — varchar(1) — NOT NULL
  • 총점 (Field4) — float — NOT NULL
  • 평점정보 (Field5) — varchar(10) — NOT NULL

department (Untitled3)

  • d_id (Key) — varchar(20) — Primary key — NOT NULL
  • d_name (Field) — varchar(20) — NOT NULL
  • s_id (Key2) — int — Foreign key → student.s_id — NOT NULL
  • d_tel (Field2) — int — NOT NULL

lecture (Untitled4)

  • l_num (Key) — integer — Primary key — NOT NULL
  • p_id (Key2) — varchar(10) — Foreign key → professor.p_id — NOT NULL
  • l_name (Field) — varchar(20) — NOT NULL
  • time (Field2) — time
  • class (Field3) — varchar(20)
  • 학점 (Field4) — varchar(1) — NOT NULL
  • year (Field5) — year — NOT NULL
  • term (Field6) — varchar(10) — NOT NULL

professor (Untitled)

  • p_id (Key) — varchar(10) — Primary key — NOT NULL
  • p_name (Field) — varchar(20) — NOT NULL
  • p_num (Field2) — varchar(13) — NOT NULL
  • p_address (Field3) — varchar(50) — NOT NULL
  • p_phone (Field5) — int — NOT NULL
  • p_email (Field4) — varchar(30) — NOT NULL
  • p_img (Field6) — varchar(500) — NOT NULL
  • d_id (Key2) — varchar(20) — Foreign key → department.d_id — NOT NULL

student (Untitled2)

  • s_id (Key) — int — Primary key — NOT NULL
  • s_name (Field) — varchar(20) — NOT NULL
  • s_num (Field2) — varchar(13) — NOT NULL
  • s_address (Field3) — varchar(50) — NOT NULL
  • s_phone (Field4) — integer — NOT NULL
  • s_email (Field5) — varchar(30) — NOT NULL
  • s_img (Field6) — varchar(500) — NOT NULL
  • grade (Field7) — varchar(10) — NOT NULL
  • term (Field8) — varchar(10) — NOT NULL
  • p_id (Key3) — varchar(10) — Foreign key → professor.p_id — NOT NULL