uploaded_file_access

Log of PHI access to uploaded file contents

Primary Key:

• uploaded_file_access_id

Checks:

• uploaded_file_access_row_check - CASE WHEN (access_type = 'Read'::text) THEN (row_count IS NOT NULL) WHEN (access_type = 'Analyze'::text) THEN ((row_offset = 0) AND (row_count IS NULL)) ELSE NULL::boolean END

Foreign Keys:

• accessed_by => login.login_id
• uploaded_file_id => uploaded_file.id

Indexes:

• uploaded_file_access_uploaded_file_id_idx - uploaded_file_id
• uploaded_file_accessed_by_idx - accessed_by

Column	Data Type	Nullable	Indexed	Description
uploaded_file_access_id	bigint	No	Yes	Snowflake ID of the access record
uploaded_file_id	bigint	No	Yes	ID of the uploaded file that was accessed
access_type	text	No	No	Type of access performed: 'Read' for raw data, 'Analyze' for data type inference
columns	text[]	Yes	No	Columns requested, if not set will give all columns.
row_offset	bigint	No	No	Offset of the rows served.
row_count	bigint	Yes	No	Number of rows served. NULL means the entire file.
accessed_by	bigint	No	Yes	ID of the user who accessed the file
accessed_at	timestamp with time zone	No	No	When the access occurred.