SOLVED What is AI, PK, UQ when creating new column?

[Thomas D]

There's nothing in help and nothing in the app showing what it is and what it does?

[Daniel Mulroy]

Hello Thomas!

These are SQL parameters.

AI: Auto Increments the field on each new insertion
PK: Primary Key - this is the field that will be used when doing joins (like linked fields)
UQ: Unique - the SQL operation will fail it would cause two rows to have the same value in this column. This is best used for things like social security numbers, customer id numbers, and other things that are VERY IMPORTANT never to have conflict or duplicated.

Hope this helps!

@Wassim-Samad or @Joseph-Benguira, it'd be really nice to have these as tooltips.

[Daniel Mulroy]

Hello Thomas!

These are SQL parameters.

AI: Auto Increments the field on each new insertion
PK: Primary Key - this is the field that will be used when doing joins (like linked fields)
UQ: Unique - the SQL operation will fail it would cause two rows to have the same value in this column. This is best used for things like social security numbers, customer id numbers, and other things that are VERY IMPORTANT never to have conflict or duplicated.

Hope this helps!

@Wassim-Samad or @Joseph-Benguira, it'd be really nice to have these as tooltips.

[Wassim]

@Daniel-Mulroy said in What is AI, PK, UQ when creating new column?:

to have these as tooltips.

Actually I wanted to add the tooltips, and.. they are already here if you put your cursor on AI, PK or UQ..

[Thomas D]

@wassim Hm, that's odd, I checked for tool-tips twice, but now they appear

[Daniel Mulroy]

@ThomasD I also checked for tooltips before answering and didn't find them.

[Wassim]

Is this a conspiracy?