myClub

Tables (10)

Club

  • club_no — INT — Primary key — NOT NULL
  • club_name — varchar
  • club_description — varchar
  • created_at — datetime
  • club_category — varchar
  • user_no — INT — Foreign key → User.user_no — NOT NULL
  • is_private (Field) — INT
  • is_deactivated — INT
  • deactivated_at — datetime

User

  • user_no — INT — Primary key — NOT NULL
  • user_id — varchar
  • user_email — varchar
  • user_name — varchar
  • user_password — varchar
  • user_birth_date — varchar
  • profile_image — varchar
  • created_at — datetime
  • updated_at — datetime
  • thumbnail_image — varchar
  • deactivated_at — datetime
  • is_deactivated — INT

chat_member

  • chat_member_no — INT — Primary key — NOT NULL
  • joined_at — datetime
  • chatroom_no — INT — Foreign key → chatroom.chatroom_no — NOT NULL
  • user_no — INT — Foreign key → User.user_no — NOT NULL

chat_message (dms)

  • chat_message_no — INT — Primary key — NOT NULL
  • content — text
  • sent_at — datetime
  • chatroom_no — INT — Foreign key → chatroom.chatroom_no — NOT NULL
  • sender_no — INT — Foreign key → User.user_no — NOT NULL

chatroom (private/groupchats)

  • chatroom_no — INT — Primary key — NOT NULL
  • is_group — boolean
  • chat_name — optional
  • created_at — datetime

club_event (event)

  • event_no — INT — Primary key — NOT NULL
  • event_description — mediumtext
  • event_start_dt — datetime
  • event_end_dt — datetime
  • created_at — datetime
  • updated_at — datetime
  • participant_num (number of participants) — INT
  • event_title — varchar
  • location — varchar
  • max_participant — INT
  • recruit_start_dt — datetime
  • recruit_end_dt — datetime
  • club_no — INT — Foreign key → Club.club_no — NOT NULL
  • host_user_no — INT — Foreign key → User.user_no — NOT NULL

club_event_user (event_user)

  • event_participant_no — INT — Primary key — NOT NULL
  • event_user_status — varchar
  • created_at — datetime
  • updated_at — datetime
  • event_no — INT — Foreign key → club_event.event_no — NOT NULL
  • user_no — INT — Foreign key → User.user_no — NOT NULL
  • is_attending — INT

club_message (messages in the club chat)

  • club_message_no — INT — Primary key — NOT NULL
  • msg_content — varchar
  • sent_at — datetime
  • club_no — INT — Foreign key → Club.club_no — NOT NULL
  • sender_no — INT — Foreign key → User.user_no — NOT NULL

club_subscribers (club subscribers)

  • club_member_no — INT — Primary key — NOT NULL
  • joined_at — datetime
  • role — varchar
  • club_no — INT — Foreign key → Club.club_no — NOT NULL
  • user_no — INT — Foreign key → User.user_no — NOT NULL
  • join_state — varchar
  • dropped_at — datetime
  • is_dropped — INT

club_tags (table to filter clubs by tags)