Database – Source Company Users (source_company__users)
Description
This is a mapping table to show the relationship between users and source companies.
Table Values
Column | Data Type | Column Info | Value Notes |
id | int(11) | The id of the record | |
source_company_id | int(11) | The ID for the source company | |
user_id | int(11) | The ID for the individual user | |
full_name | varchar(255) | The user's full name | |
varchar(255) | The user's email | ||
created | timestamp | The time when the record was created | |
lastUpdated | timestamp | The time when the record was last updated | |
deleted | tinyint(1) | Whether the record has been deleted | 1 - deleted; 0 - not deleted |