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)