Database – Source Company Users (source_company__users)
Updated 4 months ago
Description
This is a mapping table to show the relationship between users and source companies.
Table Values
Column | Data Type | Column Info | Value Notes | Other |
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 | ||
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 |