Probono

Tables (9)

Announcement

  • announcement_id — VARHCAR(255) — Primary key — NOT NULL
  • announcement_title — VARHCAR(255)
  • announcement_content — VARHCAR(255)
  • announcement_author — VARHCAR(255)
  • announcement_date — VARHCAR(255)

Chat

  • Chatroom_id — VARCHAR(255) — Foreign key → Chatroom.Chatroom_id — NOT NULL
  • member_id — VARCHAR(255) — Foreign key → Chatroom.member_id — NOT NULL
  • Chat

Chatroom (Member_Chatroom)

  • Chatroom_id — VARCHAR(255) — Primary key — NOT NULL
  • member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL

Member

  • member_id — VARCHAR(255) — Primary key — NOT NULL
  • member_name — VARCHAR(255)
  • member_email — VARCHAR(255)
  • member_password — VARCHAR(255)
  • member_schoolCode — VARCHAR(255)
  • member_nationality — VARCHAR(255)

PersonalizedLearning

  • PersonalizedLearningList_id — VARHCAR(255) — Foreign key → PersonalizedLearningList.PersonalizedLearningList_id — NOT NULL
  • schedule_id — VARCHAR(255) — Foreign key → PersonalizedLearningList.schedule_id — NOT NULL
  • member_id — VARCHAR(255) — Foreign key → PersonalizedLearningList.member_id — NOT NULL
  • content — VARHCAR(255)

PersonalizedLearningList

  • PersonalizedLearningList_id — VARHCAR(255) — Primary key — NOT NULL
  • schedule_id — VARCHAR(255) — Foreign key → Schedule.schedule_id — NOT NULL
  • member_id — VARCHAR(255) — Foreign key → Schedule.member_id — NOT NULL

QnA

  • post_id — VARCHAR(255) — Primary key — NOT NULL
  • member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
  • post_title — VARCHAR(255)
  • post_contents — VARCHAR(255)
  • post_date — VARCHAR(255)

Schedule

  • schedule_id — VARCHAR(255) — Primary key — NOT NULL
  • member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
  • content — VARCHAR(255)
  • endTime — VARCHAR(255)

Timetable

  • timetable_id — VARHCAR(255) — Primary key — NOT NULL
  • member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
  • content — VARHCAR(255)