apppppp

Tables (7)

Untitled (posts)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (content) — VARCHAR(100)
  • Field

Untitled (likes)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
  • Key (target_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (target_type) — INTEGER
  • Field

Untitled (tags)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name)

Untitled (tag_post_map)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (tag_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

comments

  • key (id) — BIGINT — Primary key — NOT NULL
  • Key (id2) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • field (content) — VARCHAR(100)
  • Field (timestamp) — TIMESTAMP
  • Field

follower_map (follwer_map)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL

users

  • Key (user_id) — BIGINT — Primary key — NOT NULL
  • Field (email) — VARCHAR(50)
  • Field2 (password) — VARCHAR(50)
  • Field3 (name) — VARCHAR(50)