Draconai Documentation

dd_id_1684ee2db8
3. App Technical

Database

Table of Contents

Overview

  • Database: PostgreSQL 16 (image postgres:16-alpine).
  • UUIDv4 primary keys are used across all tables (see conventions.md, ID: DOC-CONV-UUID).
  • Container name: Db (service name db in server/var_www/docker-compose.yml).
  • Database name: draconai.
  • Database user: draconai.
  • Port: 5432.
  • Admin UI: phpMyAdmin at https://pma.ai.drawconclusions.org/ via Traefik.
  • phpMyAdmin container name: PhpMyAdmin.
  • Admin login is seeded from config.xml (admin/email + admin/password).
  • users.password_reset_token stores reset tokens for the forgot/reset flow.
  • users.password_reset_token_expires_at stores token expiry (1 hour).

Access (phpMyAdmin)

Pma

1. Open https://pma.ai.drawconclusions.org/. 2. Use:

  • Server: db (Docker service name).
  • Username: draconai
  • Password: draconai
  • Database: draconai

Tables

  • health_check
  • users
  • emails
  • thoughts
  • user_register
  • user_register.expires_at stores pending registration expiry (24 hours).
  • Table pages are the canonical source for schema details (purpose, columns, keys/indexes, relations, and usage).