Table: user_to_site
Published:
21 Aug 2012, last updated 27 Nov 2013
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 |
|