DECAKOREA

Tables (6)

Class (반)

  • id (아이디) — Primary key — NOT NULL
  • name (반이름)
  • email (이메일) — Foreign key → Teacher.email — NOT NULL

Homework (과제)

  • id (아이디) — Primary key — NOT NULL
  • email (이메일) — Foreign key → Student.email — NOT NULL
  • title (제목)
  • content (내용)
  • type (분류)
  • end (마감일)
  • start (시작일)

Member (계정)

  • email (이메일) — Primary key — NOT NULL
  • password (비밀번호)
  • roles (권한)
  • name (이름)
  • phone (전화번호)

Student (학생)

  • email (이메일) — Foreign key → Member.email — NOT NULL
  • id (아이디) — Foreign key → Class.id — NOT NULL
  • grade (학년) — int
  • phone_parent (부모님전화번호)

Submit (제출)

  • id (아이디) — Foreign key → Homework.id — NOT NULL
  • url (이미지)
  • submit (제출일)

Teacher (선생님)

  • email (이메일) — Foreign key → Member.email — NOT NULL