This website uses cookies We use cookies on this website to provide services, features and to analyze our traffic. You consent to our cookies if you continue to use our website. 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 ...
Copyright © 2018 . All Rights Reserved