3 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| showcases_dataset_version_id_fkey |
|
|
Cascade on delete | ||
| chart_specs_dataset_version_id_fkey |
|
|
Cascade on delete | ||
| dataset_versions_dataset_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| showcases | showcases_engine_check | (engine = ANY (ARRAY['metabase'::text, 'evidence'::text, 'observable'::text, 'grid'::text])) |
| showcases | showcases_status_check | (status = ANY (ARRAY['pending'::text, 'building'::text, 'ready'::text, 'failed'::text, 'unknown'::text])) |
| chart_specs | chart_specs_chart_type_check | (chart_type = ANY (ARRAY['line'::text, 'bar'::text, 'area'::text, 'scatter'::text, 'table'::text, 'map'::text])) |
| datasets | datasets_source_kind_check | (source_kind = ANY (ARRAY['upload'::text, 'pg_table'::text])) |