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)