This website uses cookies. Accept Cookies Find out more

Table: user_to_site

KB63 Last reviewed 27 November 2013
A description of the user_to_site table within the Camino CMS database schema.

Stores data linking individual users to a defined organisation (as stored in the organisation table).

Field Type Null Key Default Description
link_id int(10) No Primary The ID for the link
user_id int(10) No user_to_company 0 The User ID
organisation_id int(10) No user_to_company 0 The Organisation ID
link_created datetime No 0000-00-00 00:00:00 The MySQL timestamp of when the record was created

Indexes

Keyname Type Cardinality Field(s) Description
PRIMARY PRIMARY 0 link_id
user_to_company Index n/a organisation_id, user_id
 Loading ...