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