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
3
Please wait, loading ...
Copyright © 2011 - 2017 Calzada Media Limited. All Rights Reserved.