x_clone
Tables (8)
direct_messages
- dm_id — BIGINT — Primary key — NOT NULL
- from_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- to_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- sent_at — DATETIME — NOT NULL
poll_lists (Untitled)
- poll_id — BIGINT — Primary key — NOT NULL
- option_id — TINYINT — Primary key — NOT NULL
- posts_id — BIGINT — Foreign key → posts.posts_id — NOT NULL
- poll_name — VARCHAR(255)
- poll_option — VARCHAR(255)
poll_options
- poll_option_id — BIGINT — Primary key — NOT NULL
- poll_id — BIGINT — Foreign key → poll_lists.poll_id — NOT NULL
- option_id — TINYINT — Foreign key → poll_lists.option_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- option_val — TINYINT
post_actions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- post_id — BIGINT — Foreign key → posts.posts_id — NOT NULL
- actions — ENUM — NOT NULL
- created_at — DATETIME — NOT NULL
post_media
- media_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → posts.posts_id — NOT NULL
- media_type — ENUM — NOT NULL
- url — VARCHAR2(2048) — NOT NULL
- position — TINYINT — NOT NULL
posts
- posts_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- reply_to_id — BIGINT — Foreign key → posts.posts_id
- quote_id — BIGINT — Foreign key → posts.posts_id
- content — TEXT
- views — BIGINT — NOT NULL
- deleted_at — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- poll_end_at — DATETIME
- poll_state — VARCHAR(20)
user_block
- from_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- to_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- block_at — DATETIME — NOT NULL
users
- user_id (id) — BIGINT — Primary key — NOT NULL
- user_tag — VARCHAR(100)
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL