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