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)