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