DataX
Tables (5)
categories
- id — INT — Primary key
- name — VARCHAR(255) — NOT NULL
comments
- id — INT — Primary key
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
posts
- id — INT — Primary key
- user_id — INT — NOT NULL
- category_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- id (id2) — INT — Foreign key → users.id
tags
- id — INT — Primary key
- name — VARCHAR(255) — NOT NULL
users
- id — INT — Primary key
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- Field
- Key — NOT NULL