Field

Spalten

• id: internal

• org_id: ID to organisation

• doc_type: DOC Type

• is_sub_doc_type_field: boolean

• profile: internal

• field_name: internal

• field_type: internal

• title: internal

• translation_key: internal

• hide_label: boolean

• input_type: internal

• input_size: internal

• icon_left: internal

• icon_right: internal

• icon_above: internal

• group_id: internal

• row_order: integer

• sort_order: integer

• fuzzy_name: internal

• fuzzy_field: internal

• fuzzy_primary_field: boolean

• label_align: internal

• calculation_formula: text

• clean_field: boolean

• alphanumeric_field: boolean

• placeholder: internal

• coordinates: internal

• normalized_coordinates: internal

• threshold: internal

• reference_point: internal

• checkbox_group: internal

• list_of_values: internal

• enforce_list_of_values: boolean

• created_by: integer

• created_on: timestamp with time zone

• last_modified_on: timestamp with time zone

• is_deleted: boolean

• costing_element: internal

• erp_field_name: internal

Analyse & Beschreibung

# Technical Documentation for `public.field` Table

## Introduction

The `public.field` table appears to be designed to manage metadata and configuration for different fields associated with documents, likely within an insurance domain. Each row in the table seems to represent a specific field configuration, including its type, label, visibility settings, and other properties that dictate how the field should be presented and processed.

## Columns

### id
- **Meaning**: Unique identifier for each field configuration.
- **Role**: Primary key.
- **Typical Contents**: A UUID string that uniquely identifies each entry in the table.

### org_id
- **Meaning**: Identifier for the organization associated with the field configuration.
- **Role**: Foreign key.
- **Typical Contents**: A UUID referencing an organization.

### doc_type
- **Meaning**: Specifies the document type that the field is associated with.
- **Role**: Possibly a foreign key or a categorical identifier.
- **Typical Contents**: A string in the format `INSURANCE_DOCUMENTS_<UUID>` indicating the document type.

### is_sub_doc_type_field
- **Meaning**: Indicates whether the field is a sub-type of the document type.
- **Role**: Technical field.
- **Typical Contents**: Boolean value (True or False).

### profile
- **Meaning**: Potentially defines the profile or scope of the field.
- **Role**: Descriptive field.
- **Typical Contents**: Often empty or a brief text description.

### field_name
- **Meaning**: The internal name of the field.
- **Role**: Descriptive field.
- **Typical Contents**: A string representing the field's name in a technical context (e.g., `Schadennummer`).

### field_type
- **Meaning**: Defines the type of data the field holds.
- **Role**: Descriptive field.
- **Typical Contents**: Descriptive strings like `STRING`, `AMOUNT`.

### title
- **Meaning**: The display title for the field.
- **Role**: Descriptive field.
- **Typical Contents**: Uppercase string used for displaying the field's label.

### translation_key
- **Meaning**: Key for translation into different languages.
- **Role**: Technical field.
- **Typical Contents**: Lowercase string representing the translation key.

### hide_label
- **Meaning**: Indicates if the field's label should be hidden in the UI.
- **Role**: Technical field.
- **Typical Contents**: Boolean value (True or False).

### input_type
- **Meaning**: Specifies the input method for the field.
- **Role**: Descriptive field.
- **Typical Contents**: Can be empty or contain strings defining the input type.

### input_size
- **Meaning**: Determines the size of the input field.
- **Role**: Descriptive field.
- **Typical Contents**: Can be empty or contain strings defining input size.

### icon_left
- **Meaning**: Icon to display on the left side of the field.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains icon identifiers.

### icon_right
- **Meaning**: Icon to display on the right side of the field.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains icon identifiers.

### icon_above
- **Meaning**: Icon to display above the field.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains icon identifiers.

### group_id
- **Meaning**: Identifier for the group of fields to which this field belongs.
- **Role**: Foreign key.
- **Typical Contents**: A UUID referencing a group of fields.

### row_order
- **Meaning**: Determines the order of the field in a list or form.
- **Role**: Technical field.
- **Typical Contents**: Integer indicating the position.

### sort_order
- **Meaning**: Specifies sorting order for the field.
- **Role**: Technical field.
- **Typical Contents**: Integer that defines sorting precedence.

### fuzzy_name
- **Meaning**: An alternate name for fuzzy matching.
- **Role**: Descriptive field.
- **Typical Contents**: Often empty or contains a string for matching purposes.

### fuzzy_field
- **Meaning**: Specifies if the field is used in fuzzy matching.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains a string.

### fuzzy_primary_field
- **Meaning**: Indicates if this is the primary field for fuzzy matching.
- **Role**: Technical field.
- **Typical Contents**: Boolean value (True or False).

### label_align
- **Meaning**: Alignment setting for the field label.
- **Role**: Descriptive field.
- **Typical Contents**: Often empty or contains alignment information (e.g., left, right, center).

### calculation_formula
- **Meaning**: Formula used for calculations involving the field.
- **Role**: Technical field.
- **Typical Contents**: Text containing a formula or calculation logic.

### clean_field
- **Meaning**: Indicates if the field should be subject to data cleaning.
- **Role**: Technical field.
- **Typical Contents**: Boolean value (True or False).

### alphanumeric_field
- **Meaning**: Specifies if the field should accept only alphanumeric characters.
- **Role**: Technical field.
- **Typical Contents**: Boolean value (True or False).

### placeholder
- **Meaning**: Placeholder text for the input field.
- **Role**: Descriptive field.
- **Typical Contents**: Often empty or contains guiding text.

### coordinates
- **Meaning**: Coordinate data associated with the field.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains coordinate information.

### normalized_coordinates
- **Meaning**: Normalized version of coordinates for consistency.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains normalized coordinate data.

### threshold
- **Meaning**: Threshold value related to field validation or processing.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains threshold values.

### reference_point
- **Meaning**: Reference point used in calculations or positioning.
- **Role**: Descriptive field.
- **Typical Contents**: Often empty or contains reference point data.

### checkbox_group
- **Meaning**: Grouping identifier for checkbox fields.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains group identifiers.

### list_of_values
- **Meaning**: Specifies a list of allowed values for the field.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains a list of values.

### enforce_list_of_values
- **Meaning**: Indicates if the list of values should be strictly enforced.
- **Role**: Technical field.
- **Typical Contents**: Boolean value (True or False).

### created_by
- **Meaning**: Identifier for the user who created the field entry.
- **Role**: Descriptive field.
- **Typical Contents**: Integer referencing a user ID.

### created_on
- **Meaning**: Timestamp of when the field was created.
- **Role**: Technical field.
- **Typical Contents**: Date and time in UTC.

### last_modified_on
- **Meaning**: Timestamp of the last modification to the field.
- **Role**: Technical field.
- **Typical Contents**: Date and time in UTC.

### is_deleted
- **Meaning**: Indicates if the field has been marked as deleted.
- **Role**: Technical field.
- **Typical Contents**: Boolean value (True or False).

### costing_element
- **Meaning**: Costing element associated with the field.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains costing element identifiers.

### erp_field_name
- **Meaning**: Name of the field as used in ERP systems.
- **Role**: Descriptive field.
- **Typical Contents**: Generally empty or contains ERP-specific field names.

This documentation provides a detailed overview of the structure and purpose of each column within the `public.field` table. It serves as a guide for developers to understand the data model and its application in the system.