Visual query builder icon definitions
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I am struggling a bit with the correct names for some icons when using InDB connectoins and the visual Query Builder. I tried to google it but I could not find the official lingo.
What are the correct names for these 4 icons?
Many thanks.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My guess would be Database -> Schema -> Table -> Column.
Try our Beta data connectors at https://bit.ly/3Ae8HgY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. Schema seems about right. Googling it: ''The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases)". For Column I also hear people use the word Field! I thought it might be label with the icon hehe.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Along the same lines, and this may be an easy question to answer: on the column icon, what does it mean when it has red inside it. It shows a key next to the variable selection box in the Query Builder?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That should be the primary key columns associated with that table. They are the column or combination of columns that uniquely identifies each row in a table. No two rows can have the same key and keys should not ever be null. They provide structure and reliability of the table data by preventing duplicate records and also usually identify the level of detail of the table.
