Document Script activation status

Tabelle public.document_script_activation_status

Spalten

• id: internal

• org_id: ID to organisation

• sort_order: integer

• is_active: boolean

• created_by: integer

• created_on: timestamp with time zone

• last_modified_on: timestamp with time zone

• is_deleted: boolean

• script_id: internal

Analyse & Beschreibung

Table Documentation: public.document_script_activation_status

Introduction

The public.document_script_activation_status table is designed to manage the activation status of scripts associated with documents within an organization. Each entry in the table corresponds to a specific script and its current activation status, potentially allowing organizations to control and organize the execution of scripts in relation to their documents.

Column Descriptions

id

• Meaning: This column stores a unique identifier for each entry in the table.

• Role: Primary key.

• Typical Contents: Universally unique identifier (UUID) such as c599a3fa-a784-446a-a48e-cf37b95d93cd.

• Note: Ensures that each record is uniquely identifiable.

org_id

• Meaning: Represents the identifier for an organization.

• Role: Foreign key, likely referencing an organization table.

• Typical Contents: UUID that identifies the organization, e.g., 23f3d697-7411-4c95-981d-faf089d266be.

• Note: Links the script activation status to a specific organization.

sort_order

• Meaning: Indicates the order in which scripts should be executed or displayed.

• Role: Technical field.

• Typical Contents: Integer values representing the sequence, such as 0.

• Note: May be used to prioritize or organize scripts.

is_active

• Meaning: Denotes whether a script is currently active.

• Role: Technical field.

• Typical Contents: Boolean values, True or False.

• Note: Determines if the associated script should be executed.

created_by

• Meaning: Identifier of the user who created the record.

• Role: Foreign key, likely referencing a user table.

• Typical Contents: Integer value representing a user ID, such as 1.

• Note: Tracks the creator of the record for auditing purposes.

created_on

• Meaning: Timestamp of when the record was created.

• Role: Technical field.

• Typical Contents: Date and time with timezone, e.g., 2023-11-20 10:44:14.685170+00:00.

• Note: Provides a creation timestamp for record-keeping.

last_modified_on

• Meaning: Timestamp of the last modification to the record.

• Role: Technical field.

• Typical Contents: Date and time with timezone, or None if never modified.

• Note: Useful for tracking changes over time.

is_deleted

• Meaning: Indicates whether the record is marked as deleted.

• Role: Technical field.

• Typical Contents: Boolean values, True or False.

• Note: Allows soft deletion of records without physical removal from the database.

script_id

• Meaning: Identifier for the script associated with the record.

• Role: Foreign key, likely referencing a script table.

• Typical Contents: UUID that identifies the script, e.g., 4edc8cd7-e1bc-443a-9a23-dc490a09e80b.

• Note: Links the activation status to a specific script.