5. SQL common attibutes

Last page update: November 23, 2011

• pkey
• relationDict

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...

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).