2

Tables (3)

Comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — VARCHAR(500)
  • date — TIMESTAMP

Post

  • post_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • likes — INT
  • image — VARCHAR(255)
  • views — INT
  • date — TIMESTAMP

User

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • username — VARCHAR(100)
  • password — VARCHAR(255)
  • profile — VARCHAR(255)