3.2.5. SQL common attibutes

Last page update: September 22, 2015

• pkey
• relationDict

3.2.5.1. pkey

The primary key of a table.

CLIPBOARD:

TODO parlare del fatto che si può usare l'id come una qualsiasi altra
colonna attraverso il sysFields...

3.2.5.2. relationDict

A dict to assign a symbolic name to a relation.

Example:

dict(myname='@relname.colname')

myname can be used as $myname in all clauses to refer to the related column @relname.colname. myname is also the name of the related column in the result of the select (relatedcol AS myname).