LMS

Tables (8)

project (Untitled2)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • teacher_id (id) — bigint(20) — Foreign key → user_teacher.id — NOT NULL
  • name (Field) — varchar(100)

school (Untitled)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • address (Field2) — varchar(500)
  • type (Field3) — varchar(50)
  • code (Field4) — varchar(10)

school_admin (Untitled4)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (id) — bigint(20) — Foreign key → user.id — NOT NULL
  • school_id (Key2) — bigint(20) — Foreign key → school.id — NOT NULL

school_token (Untitled3)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • school_id (school_i) — bigint(20) — Foreign key → school.id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • token (Field) — varchar(20)
  • sign_up_times (Field2) — int

student_group (선생-학생 기록)

  • id — bigint(20) — Primary key — NOT NULL
  • project_id (Key) — bigint(20) — Foreign key → project.id — NOT NULL
  • student_id (id2) — bigint(20) — Foreign key → user_student.id — NOT NULL
  • Field

user

  • id — bigint(20) — Primary key — NOT NULL
  • Field

user_student (CopyOf선생님)

  • id — bigint(20) — Primary key — NOT NULL
  • user_id (id2) — bigint(20) — Foreign key → user.id — NOT NULL
  • school_id (Key2) — bigint(20) — Foreign key → school.id — NOT NULL
  • grade (Field)
  • classNum (Field2)

user_teacher (선생님)

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • school_id (Key) — bigint(20) — Foreign key → school.id — NOT NULL
  • Field