DEmo
Tables (3)
documents
- id — SERIAL
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- user_id — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- status — TEXT — NOT NULL
- tags — TEXT
- is_published — BOOLEAN — NOT NULL
- metadata — TEXT
- is_html — BOOLEAN
users
- id — VARCHAR — NOT NULL
- username — TEXT
- email — TEXT
- display_name — TEXT
- avatar — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
versions
- id — SERIAL
- document_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — INTEGER — NOT NULL
- version_number — TEXT — NOT NULL
- change_description — TEXT
- is_ai_generated — BOOLEAN