tbl_templatecustomfieldsoptions

7 rows


Description

Module: Task Management
Purpose: Stores option values and display labels for template custom fields (ENUM-like behavior).
Data: One row is created for each selectable option of a custom field.
Process Usage:
- Used to provide predefined selectable options for custom fields in daily tasks.
- Supports default values and stage-specific options.
Key Points:
- Each option is linked to a specific custom field.
- Tracks creation and modification metadata.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_templatecustomfieldsoptions_id_seq'::regclass)

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each custom field option record.
value varchar 200 √ null

Meaning: The internal value used for processing and storage.
Usage: Stored in database and used programmatically.
label varchar 200 √ null

Meaning: Display name of the option shown to the user in the UI.
Usage: Shown in dropdowns, radio buttons, or multi-select components.
isdefault bool 1 null

Meaning: Indicates whether this option is the default selection.
Usage: Pre-selects this option when creating tasks.
daily_task_customeid int8 19 null

Meaning: References the parent custom field this option belongs to.
Usage: Links options to their corresponding custom field for task templates.
stage varchar 100 √ null
createdby varchar 50 √ null
modifiedby varchar 50 √ null
createddate timestamp 29,6 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_templatecustomfieldsoptions_pk_tbl_templatecustomfieldsopti Primary key Asc id

Relationships

Close relationships within degrees of separation