111

Tables (31)

Alarms

  • alarm_id — BIGINT — Primary key — NOT NULL
  • actor_id — BIGINT
  • target_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • comment_id — BIGINT — NOT NULL
  • follow_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

Blocks

  • block_id — BIGINT — Primary key — NOT NULL
  • blocker_id — BIGINT
  • blockee_id — BIGINT

ChatroomMembers

  • chatroom_member_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • chatroom_id — BIGINT — NOT NULL

Chatrooms

  • chatroom_id — BIGINT — Primary key — NOT NULL
  • owner_id — BIGINT

CommentLikes

  • comment_like_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • comment_id — BIGINT — NOT NULL

Comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • parent_comment_id — BIGINT — NOT NULL
  • content — VARCHAR(255)
  • created_at — TIMESTAMP

FollowHashtags

  • follow_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • hashtag_id — BIGINT — NOT NULL

Follows

  • follow_id — BIGINT — Primary key — NOT NULL
  • follower_id — BIGINT
  • followee_id — BIGINT

Hashtags

  • hashtag_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • count — BIGINT

JoinedChatrooms

  • joined_chatroom_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • chatroom_id — BIGINT — NOT NULL
  • message_id — BIGINT — NOT NULL
  • joined_at — TIMESTAMP

Mentions

  • mention_id — BIGINT — Primary key — NOT NULL
  • actor_id — BIGINT
  • target_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • comment_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • type — VARCHAR(50)

MessageImages

  • message_id — BIGINT — Primary key — NOT NULL
  • url — VARCHAR(2048)
  • type — VARCHAR(100)
  • name — VARCHAR(255)
  • uuid — VARCHAR(255)

MessageLikes

  • message_like_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • message_id — BIGINT — NOT NULL

MessagePosts

  • message_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — NOT NULL

MessageStories

  • message_id — BIGINT — Primary key — NOT NULL
  • visitor_id — BIGINT — NOT NULL

MessageTexts

  • message_id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(255)

Messages

  • message_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • chatroom_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • type — VARCHAR(50)

PostHashtags

  • post_hashtag_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — NOT NULL
  • hashtag_id — BIGINT — NOT NULL

PostImages

  • post_image_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — NOT NULL
  • url — VARCHAR(2048)
  • type — VARCHAR(100)
  • name — VARCHAR(255)
  • uuid — VARCHAR(255)
  • alt_text — VARCHAR(500)

PostLatestComments

  • plc_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • comment_id2 — BIGINT — NOT NULL

PostLikes

  • post_like_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • post_id — BIGINT — NOT NULL

PostSaves

  • post_save_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • post_id — BIGINT — NOT NULL

PostTags

  • post_tag_id — BIGINT — Primary key — NOT NULL
  • post_image_id — BIGINT — NOT NULL
  • pos_y — INT
  • pos_x — INT
  • username — VARCHAR(255)

Posts

  • post_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • content — TEXT
  • created_at — TIMESTAMP
  • comments_enabled — TINYINT

SearchHashtags

  • search_id — BIGINT — Primary key — NOT NULL
  • hashtag_id — BIGINT — NOT NULL

SearchUsers

  • search_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT

Searches

  • search_id — BIGINT — Primary key — NOT NULL
  • count — BIGINT
  • type — VARCHAR(50)

Stories

  • story_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • url — VARCHAR(2048)
  • type — VARCHAR(100)
  • name — VARCHAR(255)
  • uuid — VARCHAR(255)
  • created_at — TIMESTAMP

StoryVisitors

  • visitor_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • story_id — BIGINT — NOT NULL

UnreadMessages

  • unread_id — BIGINT — Primary key — NOT NULL
  • chatroom_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • message_id — BIGINT — NOT NULL

Users

  • user_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(255)
  • role — VARCHAR(50)
  • password — VARCHAR(255)
  • name — VARCHAR(100)
  • website — VARCHAR(255)
  • bio — VARCHAR(1000)
  • phone — VARCHAR(50)
  • gender — VARCHAR(20)
  • image_url — VARCHAR(2048)
  • image_type — VARCHAR(100)
  • image_name — VARCHAR(255)
  • image_uuid — VARCHAR(255)