Am 25.05.12 18:00, schrieb Paul Poulain:
> In the wiki page http://wiki.koha-community.org/wiki/DB_schema_bugs, anTechnically, the name of a column does not matter much, since you can
> insconsistency has been noticed:
> primary keys column name can be: id (in authorised_values table), xxxid
> (cityid), xxx_id (label_id), xxxId (limitId), xxxcode (branchcode),
> xxxnumber (borrowernumber) => choose how to name PK and update schema
> accordingly
always refer to it as <tablename>.<columnname> to make it unambigous.
In some databases that support schemas, like PostgreSQL, you can refer
to columns even as <schemaname>.<tablename>.<columnname>.