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