study_group

Tables (10)

chat (Untitled6)

  • message_id (Key) — NOT NULL — Primary key — NOT NULL
  • sender (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • payload (Field3) — NOT NULL

day_of_week (Untitled9)

  • day_of_week_id (PK) — NOT NULL — Primary key — NOT NULL
  • group_meeting_id (PK2) — NOT NULL — Foreign key → group_meeting.group_meeting_id — NOT NULL
  • study_group_id (PK22) — NOT NULL — Foreign key → group_meeting.study_group_id — NOT NULL

email_token (Untitled2)

  • token_id (PK) — NOT NULL — Primary key — NOT NULL
  • member_id (Fk) — NOT NULL — Foreign key → member.member_id — NOT NULL
  • live_study_group_member_id (PK2) — NOT NULL — Foreign key → member.live_study_group_member_id — NOT NULL
  • study_group_id (FK) — NOT NULL — Foreign key → member.study_group_id — NOT NULL
  • confirmationToken (Field1) — NOT NULL
  • token_type (Field2) — NOT NULL

group_meeting (Untitled7)

  • group_meeting_id (PK) — NOT NULL — Primary key — NOT NULL
  • study_group_id (PK2) — NOT NULL — Foreign key → study_group.study_group_id — NOT NULL
  • start_time (Field) — NOT NULL
  • end_time (Field2) — NOT NULL
  • DayOfWeek (Field3) — NOT NULL
  • intro (Field4) — NOT NULL

member (Untitled)

  • member_id (PK) — NOT NULL — Primary key — NOT NULL
  • live_study_group_member_id (PK2) — NOT NULL — Foreign key → study_group_member.live_study_group_member_id — NOT NULL
  • study_group_id (FK) — NOT NULL — Foreign key → study_group_member.study_group_id — NOT NULL
  • email (Field) — NOT NULL
  • password (Field2) — NOT NULL
  • name (Field3) — NOT NULL
  • email_verified (Field4) — NOT NULL
  • role (Field5) — NOT NULL
  • age (Field6) — NOT NULL
  • gender (Field7) — NOT NULL

room (Untitled5)

  • room_id (Key) — NOT NULL — Primary key — NOT NULL
  • message_id (Key2) — NOT NULL — Foreign key → chat.message_id — NOT NULL
  • name (Field) — NOT NULL
  • created_at (Filed2) — NOT NULL
  • room_type (Field2) — NOT NULL

room_member (Untitled11)

  • room_member_id (PK) — NOT NULL — Primary key — NOT NULL
  • member_id (FK) — NOT NULL — Foreign key → member.member_id — NOT NULL
  • room_id (FK2) — NOT NULL — Foreign key → room.room_id — NOT NULL
  • live_study_group_member_id (PK2) — NOT NULL — Foreign key → member.live_study_group_member_id — NOT NULL
  • study_group_id (FK3) — NOT NULL — Foreign key → member.study_group_id — NOT NULL
  • message_id (Key2) — NOT NULL — Foreign key → room.message_id — NOT NULL

study_group (Untitled3)

  • study_group_id (PK) — NOT NULL — Primary key — NOT NULL
  • subject (Field) — NOT NULL
  • gender (Field2) — NOT NULL
  • regular_meeting_date (Field3) — NOT NULL
  • limit_member_number (Field4) — NOT NULL
  • regular_meeting_schedule_start_time (Field5) — NOT NULL
  • regular_meeting_schedule_end_time (Field6) — NOT NULL
  • intro (Field7) — NOT NULL
  • name (Field8) — NOT NULL

study_group_member (Untitled4)

  • live_study_group_member_id (PK) — NOT NULL — Primary key — NOT NULL
  • study_group_id (FK) — NOT NULL — Foreign key → study_group.study_group_id — NOT NULL
  • nick_name (Field) — NOT NULL
  • warn_count (Field3) — NOT NULL
  • access_permission (Field2) — NOT NULL
  • intro (Field4) — NOT NULL
  • group_role (Field5) — NOT NULL

study_group_member_plan (Untitled8)

  • group_member_schedule_id (PK) — NOT NULL — Primary key — NOT NULL
  • live_study_group_member_id (PK2) — NOT NULL — Foreign key → study_group_member.live_study_group_member_id — NOT NULL
  • study_group_id (FK) — NOT NULL — Foreign key → study_group_member.study_group_id — NOT NULL
  • start_date_time (Field1) — NOT NULL
  • is_achieved (Field2) — NOT NULL
  • payload (Field3) — NOT NULL
  • end_date_time (Field4) — NOT NULL
  • title (Field5) — NOT NULL