View Issue Details

IDProjectCategoryView StatusLast Update
0005450CaseTalk ModelerUser Interfacepublic2026-04-15 17:18
ReporterMarco Wobben Assigned ToMarco Wobben  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status resolvedResolutionreopened 
Fixed in Version15.0 
Summary0005450: Show primary keys and foreign keys in SQL catalog browser
Description

When browsing a connected SQL database catalog, CaseTalk now shows which columns are part of a primary key and which columns participate in foreign key relationships. Primary key columns are marked with a key icon. Foreign key relationships are shown as child nodes under each column, indicating the referenced table and column. This makes it easier to understand the structure and relationships of a database before importing it into a model.

TagsNo tags attached.
CaseTalk EditionCorporate

Activities

Marco Wobben

Marco Wobben

2026-03-20 12:59

administrator   ~0005848

Implemented and compiled clean. Primary keys detected via three-level fallback (FDMeta -> ODBC escape -> INFORMATION_SCHEMA). Foreign keys likewise. Both shown in the SQL catalog tree view.

Issue History

Date Modified Username Field Change
2026-03-20 12:59 Marco Wobben New Issue
2026-03-20 12:59 Marco Wobben Note Added: 0005848
2026-03-20 12:59 Marco Wobben Status new => resolved
2026-03-20 12:59 Marco Wobben Resolution open => fixed
2026-03-20 13:00 Marco Wobben Fixed in Version => 15.0
2026-03-20 18:33 Marco Wobben Assigned To => Marco Wobben
2026-03-20 18:33 Marco Wobben Status resolved => feedback
2026-03-20 18:33 Marco Wobben Resolution fixed => reopened
2026-03-23 09:05 Marco Wobben Status feedback => acknowledged
2026-04-15 17:18 Marco Wobben Status acknowledged => resolved