과외
테이블 (16)
Assignment File (Untitled15)
- assignment_file_id (Key) — 기본 키 — NOT NULL
- assignment_id (Key2) — 외래 키 → assignment.assignment_id
- file_url (Field)
Attendance (Untitled3)
- attendance_id (Key) — 기본 키 — NOT NULL
- channel_id (Key2) — 외래 키 → channel.channel_id — NOT NULL
- schedule_id (Key3) — 외래 키 → class schedule.schedule_id — NOT NULL
- status (Field)
- Field2
ChatRoom (Untitled9)
- room_id (Key) — 기본 키 — NOT NULL
- room_name (Field)
- created_date (Field2)
ChatRoomUser (Untitled12)
- room_id (Key2) — 외래 키 → ChatRoom.room_id — NOT NULL
- user_id (Key3) — 외래 키 → user.user_id — NOT NULL
Learning Material (Untitled4)
- material_id (Key) — 기본 키
- channel_id (Key2) — 외래 키 → channel.channel_id — NOT NULL
- material_name (Field2)
- description (Field)
- file_url (Field3)
- uploaded_date (Field4)
- Field5
Learning Material File (Untitled16)
- learning_meterial_file_id (Key) — 기본 키 — NOT NULL
- material_id (Key2) — 외래 키 → Learning Material.material_id
- file_url (Field)
Message (Untitled13)
- message_id (Key) — 기본 키 — NOT NULL
- room_id (Key2) — 외래 키 → ChatRoomUser.room_id — NOT NULL
- sender_id (Key3) — 외래 키 → ChatRoomUser.user_id — NOT NULL
- content (Field)
- sent_time (Field2)
- is_read (Field3) — boolean
- Field4
Message File (Untitled14)
- Message_file_id (Key) — 기본 키 — NOT NULL
- message_id (Key2) — 외래 키 → Message.message_id — NOT NULL
- file_url (Field)
Submission (Untitled10)
- submission_id (Key) — 기본 키 — NOT NULL
- assignment_id (Key2) — 외래 키 → assignment.assignment_id
- title (Field)
- description (Field2)
- submit_date (Field3)
Submission File (Untitled11)
- submission_file_id (Key) — 기본 키 — NOT NULL
- submission_id (Key2) — 외래 키 → Submission.submission_id — NOT NULL
- file_url (Field)
To do (Untitled8)
- todo_id (Key) — 기본 키 — NOT NULL
- user_id (Key2) — 외래 키 → user.user_id — NOT NULL
- status (Field)
- description (Field2)
- created_date (Field3)
- Field4
assignment (Untitled5)
- assignment_id (Key) — 기본 키
- channel_id (Key2) — 외래 키 → channel.channel_id — NOT NULL
- assignment_name (Field2)
- description (Field3)
- due_date (Field)
- created_date (Field4)
- is_check (Field5)
- evaluation (Field6)
- Field7
channel (Untitled2)
- channel_id (Key) — 기본 키 — NOT NULL
- tutor_id (Key2) — 외래 키 → user.user_id — NOT NULL
- student_id (Field)
- parents_id (Field4)
- subject (Field2)
- created_date (Field3)
- Field5
class schedule (Untitled7)
- schedule_id (Key) — 기본 키 — NOT NULL
- channel_id (Key2) — 외래 키 → channel.channel_id — NOT NULL
- date (Field)
- start_time (Field2)
- end_time (Field3)
- location (Field4)
- Field5
school grade (Untitled6)
- grade_id (Key) — 기본 키 — NOT NULL
- channel_id (Key2) — 외래 키 → channel.channel_id — NOT NULL
- student_id (Key3) — 외래 키 → user.user_id — NOT NULL
- subject_name (Field)
- grade (Field2)
- semester (Field3)
- recorded_date (Field4)
- Field5
user (Untitled)
- user_id (Key) — 기본 키 — NOT NULL
- email (Field)
- password (Field2)
- age (Field3)
- user_name (Field4)
- gender (Field5)
- created_date (Field6)
- update_date (Field7)
- Field8