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