Table: dbo.Magnetic_Media_File_Client
Columns
Name | Type | Constraints | Description
magnetic_media_file_client_KEY | int (4) | NOT NULL | Key for the Magnetic Media File Client
magnetic_media_file_KEY | int (4) | NOT NULL | Key into the associated Magnetic Media File table for the current row
client_KEY | int (4) | NOT NULL | The client id for this client record
description | nvarchar (60) | NOT NULL | The description of the client to display in the client listing. This is different from the client name.
magnetic_media_file_client_type_KEY | int (4) | NOT NULL |
payment_date | smalldatetime (4) |  | The payment date for files that include a payment. Will be null for any files that do not include a payment.
client_id | nvarchar (22) | NOT NULL | Column value populates the Client ID that exists on the client at the time the v2023.2.0 release was applied or the form was processed, whichever is the latter. For internet files created prior to the release of v.2023.2.0, the value will be set to .

Primary key
Name | Columns | Description
PK_Magnetic_Media_File_Client | magnetic_media_file_client_KEY |
Unique constraints
Name | Columns | Description
UK_Magnetic_Media_File_Client$magnetic_media_file_KEY$client_KEY$magnetic_media_file_client_type_KEY | magnetic_media_file_KEY, client_KEY, magnetic_media_file_client_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Magnetic_Media_File_Client__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Magnetic_Media_File_Client__Magnetic_Media_File__magnetic_media_file_KEY | magnetic_media_file_KEY | Magnetic_Media_File (magnetic_media_file_KEY) |
FK_Magnetic_Media_File_Client__Magnetic_Media_File_Client_Type__magnetic_media_file_client_type_KEY | magnetic_media_file_client_type_KEY | Magnetic_Media_File_Client_Type (magnetic_media_file_client_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Magnetic_Media_Client_Record__Magnetic_Media_File_Client__magnetic_media_file_client_KEY | magnetic_media_file_client_KEY | Magnetic_Media_Client_Record |
FK_Payable_Transaction_N_Magnetic_Media_File_Client__Magnetic_Media_File_Client__magnetic_media_file_client_KEY | magnetic_media_file_client_KEY | Payable_Transaction_N_Magnetic_Media_File_Client |