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
NameTypeConstraintsDescription
client_file_exchange_portal_ems_user_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLThe ACS client that has an associated NetClient user.
ems_user_idint (4)NOT NULLThe NetClient user being associated with the ACS client.
Primary key
NameColumnsDescription
PK_Client_File_Exchange_Portal_Ems_Userclient_file_exchange_portal_ems_user_KEY
Unique constraints
NameColumnsDescription
UK_Client_File_Exchange_Portal_Ems_User$client_KEY$ems_user_idclient_KEY, ems_user_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_File_Exchange_Portal_Ems_User__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_File_Exchange_Portal_Ems_User__Ems_User__ems_user_idems_user_idEms_User (ems_user_id)

Schema diagram