LMS

Tables (5)

attend class (수강내역)

  • s_id (Key) — bigint — Foreign key → student.s_id — NOT NULL
  • c_id (Key3) — bigint — Foreign key → class.c_id — NOT NULL
  • p_id (Key2) — bigint — Foreign key → professor.p_id — NOT NULL
  • attendance (Field) — integer
  • middle (Field2) — integer
  • last (Field3) — integer
  • etc (Field4) — integer
  • all (Field5) — integer
  • aver (Field6) — varchar(20)

class (강좌)

  • c_id (Key) — bigint — Primary key — NOT NULL
  • p_id (Key2) — bigint — Foreign key → professor.p_id — NOT NULL
  • name (Field) — varchar(20)
  • grade (Field2) — varchar(20)
  • time (Field3) — varchar(20)
  • infor (Field4) — varchar(20)
  • d_id (Key3) — bigint — Foreign key → department.d_id — NOT NULL

department (학과)

  • d_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • phone (Field2) — varchar(20)

professor (Untitled2)

  • p_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • jumin (Field2) — varchar(40)
  • address (Field3) — varchar(50)
  • phone (Field4) — varchar(20)
  • e-mail (Field5) — varchar(30)
  • picture (Field6) — varchar(20)
  • d_id (Key2) — bigint — Foreign key → department.d_id — NOT NULL

student (학생)

  • s_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • jumin (Field2) — varchar(40)
  • address (Field3) — varchar(50)
  • phone (Field4) — varchar(20)
  • e-mail (Field5) — varchar(30)
  • picture (Field6) — varchar(20)
  • p_id (Key3) — bigint — Foreign key → professor.p_id — NOT NULL
  • d_id (Key2) — bigint — Foreign key → department.d_id — NOT NULL