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)