Table: dbo.Client_File_Exchange_Portal_Ems_User
This table says which NetClient users are associated with ACS Clients for File Exchange purposes. It lists which users will have their data available when accessing File Exchange data for an ACS client. An ACS Client may have many NetClient users associated with it.
Columns
Name | Type | Constraints | Description
client_file_exchange_portal_ems_user_KEY | int (4) | NOT NULL | Primary key for this table.
client_KEY | int (4) | NOT NULL | The ACS client that has an associated NetClient user.
ems_user_id | int (4) | NOT NULL | The NetClient user being associated with the ACS client.

Primary key
Name | Columns | Description
PK_Client_File_Exchange_Portal_Ems_User | client_file_exchange_portal_ems_user_KEY |
Unique constraints
Name | Columns | Description
UK_Client_File_Exchange_Portal_Ems_User$client_KEY$ems_user_id | client_KEY, ems_user_id |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_File_Exchange_Portal_Ems_User__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_File_Exchange_Portal_Ems_User__Ems_User__ems_user_id | ems_user_id | Ems_User (ems_user_id) |