Table: user_to_site

Article Id
kb63
Published
21 Aug 2012 at 14:39
Last Updated
27 Nov 2013 at 16:01

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
     
Copyright © 2011 - 2024 Calzada Media Limited. All Rights Reserved