prac

Tables (7)

comments

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (post__id) — BIGINT — Foreign key → user.Key — NOT NULL
  • Key (user__id) — BIGINT — Foreign key → posts.Key — NOT NULL
  • Field (content) — ARCHAR(100)
  • Field2 (timestamp) — TIMESTAMP

follower_map

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (target_id) — BIGINT — Foreign key → user.Key — NOT NULL

likes

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user__id) — BIGINT — Foreign key → user.Key — NOT NULL
  • Key (target_id) — BIGINT — Foreign key → posts.Key — NOT NULL
  • Field4 (target_type) — INTEGER
  • t (mestamp) — TIMESTAMP

posts

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

tag_post_map

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (tag__id) — BIGINT — Foreign key → posts.Key — NOT NULL
  • Key (user__id) — BIGINT — Foreign key → posts.Key — NOT NULL
  • Key (id2) — BIGINT — Foreign key → tags.Key — NOT NULL

tags

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

user (users)

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