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) |