Visual query builder icon definitions

[Pingu]

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.

[VojtechT]

My guess would be Database -> Schema -> Table -> Column.

[Pingu]

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.

[jeprime]

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?

[aihnen · Accepted solution]

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.