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