ai erd

Tables (7)

chunks

  • id — BIGSERIAL — Primary key — NOT NULL
  • document_id — BIGINT — Foreign key → documents.id — NOT NULL
  • chunk_index — INT — NOT NULL
  • content — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • tsv — TSVECTOR

code_units

  • id — BIGSERIAL — Primary key — NOT NULL
  • project — TEXT — NOT NULL
  • module — TEXT
  • kind — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • file_path — TEXT
  • signature — TEXT
  • base_type — TEXT
  • summary — TEXT
  • uses — TEXT
  • tags — TEXT
  • saved_by — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • tsv — TSVECTOR
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

conventions

  • id — BIGSERIAL — Primary key — NOT NULL
  • project — TEXT — NOT NULL
  • module — TEXT
  • category — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • rule — TEXT — NOT NULL
  • anti_pattern — TEXT
  • rationale — TEXT
  • preferred — TEXT
  • deprecated — TEXT
  • support_count — INT — NOT NULL
  • counter_count — INT — NOT NULL
  • examples — JSONB
  • status — TEXT — NOT NULL
  • saved_by — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • tsv — TSVECTOR
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

daily_reports

  • id — BIGSERIAL — Primary key — NOT NULL
  • report_date — DATE — NOT NULL
  • author — TEXT — NOT NULL
  • project — TEXT
  • summary — TEXT — NOT NULL
  • detail — TEXT
  • tags — TEXT
  • saved_by — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • tsv — TSVECTOR
  • created_at — TIMESTAMPTZ — NOT NULL

db_objects

  • id — BIGSERIAL — Primary key — NOT NULL
  • project — TEXT — NOT NULL
  • db_name — TEXT — NOT NULL
  • object_type — TEXT — NOT NULL
  • schema_name — TEXT — NOT NULL
  • object_name — TEXT — NOT NULL
  • parent_object — TEXT
  • definition — TEXT
  • source_modified_at — TIMESTAMPTZ
  • params — JSONB
  • columns — JSONB
  • depends_on — TEXT
  • description — TEXT
  • tags — TEXT
  • saved_by — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • tsv — TSVECTOR
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

documents

  • id — BIGSERIAL — Primary key — NOT NULL
  • project — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • source — TEXT
  • body — TEXT — NOT NULL
  • tags — TEXT
  • saved_by — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

focus_stack

  • id — BIGSERIAL — Primary key — NOT NULL
  • project — TEXT — NOT NULL
  • depth — INT — NOT NULL
  • title — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • note — TEXT
  • saved_by — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • resolved_at — TIMESTAMPTZ