draw.io
Tables (4)
categories
- id — INT
- name — VARCHAR(50) — NOT NULL
comments
- id — INT
- content — TEXT — NOT NULL
- posts_id — INT — NOT NULL
- users_id — INT — NOT NULL
- created_at — TIMESTAMP
posts
- id — INT
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- users_id — INT — NOT NULL
- categories_id — INT — NOT NULL
- created_at — TIMESTAMP
users
- id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP