UniGo
Tables (8)
all_chat
- allchat_idx — bigint — Primary key — NOT NULL
- sender_id — bigint — Foreign key → users.user_idx — NOT NULL
- sender_name — varchar(255)
- content — varchar(255)
- time_stamp — datetime — NOT NULL
chat_message
- message_id — bigint — Primary key — NOT NULL
- chatRoom_idx — bigint — Foreign key → chatroom.chatroom_idx — NOT NULL
- sender_id — bigint — Foreign key → users.user_idx — NOT NULL
- message — varchar(255) — NOT NULL
- sent_at — timestamp — NOT NULL
chatroom
- chatroom_idx — bigint — Primary key — NOT NULL
- user1_idx — bigint — Foreign key → users.user_idx — NOT NULL
- user2_idx — bigint — Foreign key → users.user_idx — NOT NULL
fcm_token
- token_id — bigint — Primary key — NOT NULL
- token — varchar(255)
- user_id — bigint
interest
- interest_idx — bigint — Primary key — NOT NULL
- name — varchar(255)
major
- major_idx — int — Primary key — NOT NULL
- name — varchar(255)
user_interest
- user_interest_idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → users.user_idx — NOT NULL
- interest_idx — bigint — Foreign key → interest.interest_idx — NOT NULL
users
- user_idx — bigint — Primary key — NOT NULL
- name — varchar(255)
- login_id — varchar(255)
- pw — varchar(255)
- major_idx — int — Foreign key → major.major_idx — NOT NULL
- gender — varchar(255)
- avatar_url — varchar(255)