과외

테이블 (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