Table: dbo.Magnetic_Media_File_Client
Columns
NameTypeConstraintsDescription
magnetic_media_file_client_KEYint (4)NOT NULLKey for the Magnetic Media File Client
magnetic_media_file_KEYint (4)NOT NULLKey into the associated Magnetic Media File table for the current row
client_KEYint (4)NOT NULLThe client id for this client record
descriptionnvarchar (60)NOT NULLThe description of the client to display in the client listing. This is different from the client name.
magnetic_media_file_client_type_KEYint (4)NOT NULL
payment_datesmalldatetime (4)The payment date for files that include a payment. Will be null for any files that do not include a payment.
client_idnvarchar (22)NOT NULLColumn 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
NameColumnsDescription
PK_Magnetic_Media_File_Clientmagnetic_media_file_client_KEY
Unique constraints
NameColumnsDescription
UK_Magnetic_Media_File_Client$magnetic_media_file_KEY$client_KEY$magnetic_media_file_client_type_KEYmagnetic_media_file_KEY, client_KEY, magnetic_media_file_client_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Magnetic_Media_File_Client__Client__client_KEYclient_KEYClient (client_KEY)
FK_Magnetic_Media_File_Client__Magnetic_Media_File__magnetic_media_file_KEYmagnetic_media_file_KEYMagnetic_Media_File (magnetic_media_file_KEY)
FK_Magnetic_Media_File_Client__Magnetic_Media_File_Client_Type__magnetic_media_file_client_type_KEYmagnetic_media_file_client_type_KEYMagnetic_Media_File_Client_Type (magnetic_media_file_client_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Magnetic_Media_Client_Record__Magnetic_Media_File_Client__magnetic_media_file_client_KEYmagnetic_media_file_client_KEYMagnetic_Media_Client_Record
FK_Payable_Transaction_N_Magnetic_Media_File_Client__Magnetic_Media_File_Client__magnetic_media_file_client_KEYmagnetic_media_file_client_KEYPayable_Transaction_N_Magnetic_Media_File_Client

Schema diagram