Regular Asset Option Value
Table
Columns
| Property |
Db Table |
Db Column |
Db DataType |
Nullable |
Primary Key |
Joins |
Id |
ampc.asset_option_value |
asset_option_value_id |
bigint |
False |
True |
|
IsCustom |
ampc.asset_option_value |
is_custom |
boolean |
False |
|
|
OptionId |
ampc.asset_option_value |
option_id |
bigint |
False |
|
|
OptionAllowMultipleValues |
ampc.option |
allow_multiple_values |
boolean |
False |
|
ampc.asset_option_value.option_id = ampc.option.option_id |
OptionCode |
ampc.option |
code |
character varying(50) |
False |
|
ampc.asset_option_value.option_id = ampc.option.option_id |
OptionDataType |
ampc.option |
data_type |
ampc.option_data_type |
False |
|
ampc.asset_option_value.option_id = ampc.option.option_id |
OptionDescription |
ampc.option |
description |
character varying(100) |
False |
|
ampc.asset_option_value.option_id = ampc.option.option_id |
OptionLowerBounds |
ampc.option |
lower_bounds |
character varying(100) |
True |
|
ampc.asset_option_value.option_id = ampc.option.option_id |
OptionUpperBounds |
ampc.option |
upper_bounds |
character varying(100) |
True |
|
ampc.asset_option_value.option_id = ampc.option.option_id |
OptionOptionCategoryId |
ampc.option_category |
option_category_id |
bigint |
False |
True |
ampc.asset_option_value.option_id = ampc.option.option_id Then
ampc.option.option_category_id = ampc.option_category.option_category_id |
OptionOptionCategoryCode |
ampc.option_category |
code |
character varying(50) |
False |
|
ampc.asset_option_value.option_id = ampc.option.option_id Then
ampc.option.option_category_id = ampc.option_category.option_category_id |
OptionOptionCategoryDescription |
ampc.option_category |
description |
character varying(100) |
False |
|
ampc.asset_option_value.option_id = ampc.option.option_id Then
ampc.option.option_category_id = ampc.option_category.option_category_id |
OptionUnitOfMeasurementId |
gen.unit_of_measurement |
unit_of_measurement_id |
bigint |
False |
True |
ampc.asset_option_value.option_id = ampc.option.option_id Then
ampc.option.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
OptionUnitOfMeasurementCode |
gen.unit_of_measurement |
code |
character varying(50) |
False |
|
ampc.asset_option_value.option_id = ampc.option.option_id Then
ampc.option.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
OptionUnitOfMeasurementDescription |
gen.unit_of_measurement |
description |
character varying(100) |
False |
|
ampc.asset_option_value.option_id = ampc.option.option_id Then
ampc.option.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
RegularAssetTypeOptionId |
ampc.asset_option_value |
asset_type_option_id |
bigint |
True |
|
|
RegularAssetTypeOptionOptionId |
ampc.option |
option_id |
bigint |
False |
True |
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id |
RegularAssetTypeOptionOptionCode |
ampc.option |
code |
character varying(50) |
False |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id |
RegularAssetTypeOptionOptionDescription |
ampc.option |
description |
character varying(100) |
False |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id |
RegularAssetTypeOptionOptionAllowMultipleValues |
ampc.option |
allow_multiple_values |
boolean |
False |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id |
RegularAssetTypeOptionOptionLowerBounds |
ampc.option |
lower_bounds |
character varying(100) |
True |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id |
RegularAssetTypeOptionOptionDataType |
ampc.option |
data_type |
ampc.option_data_type |
False |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id |
RegularAssetTypeOptionOptionUpperBounds |
ampc.option |
upper_bounds |
character varying(100) |
True |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id |
RegularAssetTypeOptionOptionOptionCategoryId |
ampc.option_category |
option_category_id |
bigint |
False |
True |
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id Then
ampc.option.option_category_id = ampc.option_category.option_category_id |
RegularAssetTypeOptionOptionOptionCategoryCode |
ampc.option_category |
code |
character varying(50) |
False |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id Then
ampc.option.option_category_id = ampc.option_category.option_category_id |
RegularAssetTypeOptionOptionOptionCategoryDescription |
ampc.option_category |
description |
character varying(100) |
False |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id Then
ampc.option.option_category_id = ampc.option_category.option_category_id |
RegularAssetTypeOptionOptionUnitOfMeasurementId |
gen.unit_of_measurement |
unit_of_measurement_id |
bigint |
False |
True |
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id Then
ampc.option.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
RegularAssetTypeOptionOptionUnitOfMeasurementCode |
gen.unit_of_measurement |
code |
character varying(50) |
False |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id Then
ampc.option.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
RegularAssetTypeOptionOptionUnitOfMeasurementDescription |
gen.unit_of_measurement |
description |
character varying(100) |
False |
|
ampc.asset_option_value.asset_type_option_id = ampc.asset_type_option.asset_type_option_id Then
ampc.asset_type_option.option_id = ampc.option.option_id Then
ampc.option.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
SequenceNumber |
ampc.asset_option_value |
sequence_number |
integer |
True |
|
|
IsActive |
ampc.asset_option_value |
is_active |
boolean |
False |
|
|
CreatedByUserId |
ampc.asset_option_value |
created_by_user_id |
bigint |
False |
|
|
CreatedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
ampc.asset_option_value.created_by_user_id = uam.user.user_id |
CreatedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
ampc.asset_option_value.created_by_user_id = uam.user.user_id |
CreatedOn |
ampc.asset_option_value |
created_on |
timestamp without time zone |
False |
|
|
ModifiedByUserId |
ampc.asset_option_value |
modified_by_user_id |
bigint |
False |
|
|
ModifiedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
ampc.asset_option_value.modified_by_user_id = uam.user.user_id |
ModifiedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
ampc.asset_option_value.modified_by_user_id = uam.user.user_id |
ModifiedOn |
ampc.asset_option_value |
modified_on |
timestamp without time zone |
False |
|
|
Version |
ampc.asset_option_value |
version |
integer |
False |
|
|
PermissionTreeId |
ampc.asset_option_value |
permission_tree_id |
bigint |
False |
|
|
PermissionTreeCode |
uam.permission_tree |
code |
text |
False |
|
ampc.asset_option_value.permission_tree_id = uam.permission_tree.permission_tree_id |
PermissionTreeDescription |
uam.permission_tree |
description |
text |
True |
|
ampc.asset_option_value.permission_tree_id = uam.permission_tree.permission_tree_id |
Notes |
ampc.asset_option_value |
notes |
text |
True |
|
|
OptionValue |
ampc.asset_option_value |
option_value |
character varying(100) |
False |
|
|
RegularAssetId |
ampc.asset_option_value |
asset_id |
bigint |
False |
|
|
RegularAssetCode |
ampc.asset |
code |
character varying(50) |
False |
|
ampc.asset_option_value.asset_id = ampc.asset.asset_id |
RegularAssetDescription |
ampc.asset |
description |
character varying(100) |
False |
|
ampc.asset_option_value.asset_id = ampc.asset.asset_id |
Enumerations
Mapping 1
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| OptionDataType |
OptionDataType |
data_type |
ampc.option_data_type |
String
Integer
Float
DateTime
Boolean
|
Mapping 2
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| RegularAssetTypeOptionOptionDataType |
OptionDataType |
data_type |
ampc.option_data_type |
String
Integer
Float
DateTime
Boolean
|
Queries
The list of example Regular Asset Option Value queries can be interpreted using the following legend:
| Legend |
Description |
| Primary Table Alias |
The alias for the ampc.asset_option_value table in the query |
| Include References |
Include (true) or exclude (false) all lookup table joins in the query |
| Include Permissions |
Include (true) or exclude (false) the permission table join in the query to enforce or skip row-level security based on the permissions for the user |
Query 1
| Primary Table Alias |
Include References |
Include Permissions |
_aov |
False |
False |
SELECT
_aov.asset_option_value_id AS "Id",
_aov.is_custom AS "IsCustom",
_aov.option_id AS "OptionId",
_aov.asset_type_option_id AS "RegularAssetTypeOptionId",
_aov.sequence_number AS "SequenceNumber",
_aov.is_active AS "IsActive",
_aov.created_by_user_id AS "CreatedByUserId",
_aov.created_on AS "CreatedOn",
_aov.modified_by_user_id AS "ModifiedByUserId",
_aov.modified_on AS "ModifiedOn",
_aov.version AS "Version",
_aov.permission_tree_id AS "PermissionTreeId",
_aov.notes AS "Notes",
_aov.option_value AS "OptionValue",
_aov.asset_id AS "RegularAssetId"
FROM
ampc.asset_option_value _aov
Query 2
| Primary Table Alias |
Include References |
Include Permissions |
_aov |
True |
False |
SELECT
_aov.asset_option_value_id AS "Id",
_aov.is_custom AS "IsCustom",
_o.option_id AS "OptionId",
_o.allow_multiple_values AS "OptionAllowMultipleValues",
_o.code AS "OptionCode",
_o.data_type AS "OptionDataType",
_o.description AS "OptionDescription",
_o.lower_bounds AS "OptionLowerBounds",
_o.upper_bounds AS "OptionUpperBounds",
_o.option_category_id AS "OptionOptionCategory",
_oc.option_category_id AS "OptionOptionCategoryId",
_oc.code AS "OptionOptionCategoryCode",
_oc.description AS "OptionOptionCategoryDescription",
_o.unit_of_measurement_id AS "OptionUnitOfMeasurement",
_uom.unit_of_measurement_id AS "OptionUnitOfMeasurementId",
_uom.code AS "OptionUnitOfMeasurementCode",
_uom.description AS "OptionUnitOfMeasurementDescription",
_ato.asset_type_option_id AS "RegularAssetTypeOptionId",
_ato.option_id AS "RegularAssetTypeOptionOption",
_o1.option_id AS "RegularAssetTypeOptionOptionId",
_o1.code AS "RegularAssetTypeOptionOptionCode",
_o1.description AS "RegularAssetTypeOptionOptionDescription",
_o1.allow_multiple_values AS "RegularAssetTypeOptionOptionAllowMultipleValues",
_o1.lower_bounds AS "RegularAssetTypeOptionOptionLowerBounds",
_o1.data_type AS "RegularAssetTypeOptionOptionDataType",
_o1.upper_bounds AS "RegularAssetTypeOptionOptionUpperBounds",
_o1.option_category_id AS "RegularAssetTypeOptionOptionOptionCategory",
_oc1.option_category_id AS "RegularAssetTypeOptionOptionOptionCategoryId",
_oc1.code AS "RegularAssetTypeOptionOptionOptionCategoryCode",
_oc1.description AS "RegularAssetTypeOptionOptionOptionCategoryDescription",
_o1.unit_of_measurement_id AS "RegularAssetTypeOptionOptionUnitOfMeasurement",
_uom1.unit_of_measurement_id AS "RegularAssetTypeOptionOptionUnitOfMeasurementId",
_uom1.code AS "RegularAssetTypeOptionOptionUnitOfMeasurementCode",
_uom1.description AS "RegularAssetTypeOptionOptionUnitOfMeasurementDescription",
_aov.sequence_number AS "SequenceNumber",
_aov.is_active AS "IsActive",
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_aov.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_aov.modified_on AS "ModifiedOn",
_aov.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_aov.notes AS "Notes",
_aov.option_value AS "OptionValue",
_a.asset_id AS "RegularAssetId",
_a.code AS "RegularAssetCode",
_a.description AS "RegularAssetDescription"
FROM
ampc.asset_option_value _aov
JOIN ampc.option _o ON _aov.option_id = _o.option_id
JOIN ampc.option_category _oc ON _o.option_category_id = _oc.option_category_id
LEFT JOIN gen.unit_of_measurement _uom ON _o.unit_of_measurement_id = _uom.unit_of_measurement_id
LEFT JOIN ampc.asset_type_option _ato ON _aov.asset_type_option_id = _ato.asset_type_option_id
LEFT JOIN ampc.option _o1 ON _ato.option_id = _o1.option_id
LEFT JOIN ampc.option_category _oc1 ON _o1.option_category_id = _oc1.option_category_id
LEFT JOIN gen.unit_of_measurement _uom1 ON _o1.unit_of_measurement_id = _uom1.unit_of_measurement_id
JOIN uam.user _u ON _aov.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _aov.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _aov.permission_tree_id = _pt.permission_tree_id
JOIN ampc.asset _a ON _aov.asset_id = _a.asset_id
Query 3
| Primary Table Alias |
Include References |
Include Permissions |
_aov |
False |
True |
| Parameter Name |
Data Type |
Value |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
45900 |
WITH permission_tree_ids AS
(
SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
_aov.asset_option_value_id AS "Id",
_aov.is_custom AS "IsCustom",
_aov.option_id AS "OptionId",
_aov.asset_type_option_id AS "RegularAssetTypeOptionId",
_aov.sequence_number AS "SequenceNumber",
_aov.is_active AS "IsActive",
_aov.created_by_user_id AS "CreatedByUserId",
_aov.created_on AS "CreatedOn",
_aov.modified_by_user_id AS "ModifiedByUserId",
_aov.modified_on AS "ModifiedOn",
_aov.version AS "Version",
_aov.permission_tree_id AS "PermissionTreeId",
_aov.notes AS "Notes",
_aov.option_value AS "OptionValue",
_aov.asset_id AS "RegularAssetId",
_aov.permission_tree_id AS "_aov_permission_tree_id"
FROM
ampc.asset_option_value _aov
JOIN permission_tree_ids permission_join ON _aov.permission_tree_id = permission_join.permission_tree_id
Query 4
| Primary Table Alias |
Include References |
Include Permissions |
_aov |
True |
True |
| Parameter Name |
Data Type |
Value |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
45900 |
WITH permission_tree_ids AS
(
SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
_aov.asset_option_value_id AS "Id",
_aov.is_custom AS "IsCustom",
_o.option_id AS "OptionId",
_o.allow_multiple_values AS "OptionAllowMultipleValues",
_o.code AS "OptionCode",
_o.data_type AS "OptionDataType",
_o.description AS "OptionDescription",
_o.lower_bounds AS "OptionLowerBounds",
_o.upper_bounds AS "OptionUpperBounds",
_o.option_category_id AS "OptionOptionCategory",
_oc.option_category_id AS "OptionOptionCategoryId",
_oc.code AS "OptionOptionCategoryCode",
_oc.description AS "OptionOptionCategoryDescription",
_o.unit_of_measurement_id AS "OptionUnitOfMeasurement",
_uom.unit_of_measurement_id AS "OptionUnitOfMeasurementId",
_uom.code AS "OptionUnitOfMeasurementCode",
_uom.description AS "OptionUnitOfMeasurementDescription",
_ato.asset_type_option_id AS "RegularAssetTypeOptionId",
_ato.option_id AS "RegularAssetTypeOptionOption",
_o1.option_id AS "RegularAssetTypeOptionOptionId",
_o1.code AS "RegularAssetTypeOptionOptionCode",
_o1.description AS "RegularAssetTypeOptionOptionDescription",
_o1.allow_multiple_values AS "RegularAssetTypeOptionOptionAllowMultipleValues",
_o1.lower_bounds AS "RegularAssetTypeOptionOptionLowerBounds",
_o1.data_type AS "RegularAssetTypeOptionOptionDataType",
_o1.upper_bounds AS "RegularAssetTypeOptionOptionUpperBounds",
_o1.option_category_id AS "RegularAssetTypeOptionOptionOptionCategory",
_oc1.option_category_id AS "RegularAssetTypeOptionOptionOptionCategoryId",
_oc1.code AS "RegularAssetTypeOptionOptionOptionCategoryCode",
_oc1.description AS "RegularAssetTypeOptionOptionOptionCategoryDescription",
_o1.unit_of_measurement_id AS "RegularAssetTypeOptionOptionUnitOfMeasurement",
_uom1.unit_of_measurement_id AS "RegularAssetTypeOptionOptionUnitOfMeasurementId",
_uom1.code AS "RegularAssetTypeOptionOptionUnitOfMeasurementCode",
_uom1.description AS "RegularAssetTypeOptionOptionUnitOfMeasurementDescription",
_aov.sequence_number AS "SequenceNumber",
_aov.is_active AS "IsActive",
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_aov.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_aov.modified_on AS "ModifiedOn",
_aov.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_aov.notes AS "Notes",
_aov.option_value AS "OptionValue",
_a.asset_id AS "RegularAssetId",
_a.code AS "RegularAssetCode",
_a.description AS "RegularAssetDescription",
_aov.permission_tree_id AS "_aov_permission_tree_id",
_o.permission_tree_id AS "_o_permission_tree_id",
_oc.permission_tree_id AS "_oc_permission_tree_id",
_uom.permission_tree_id AS "_uom_permission_tree_id",
_o1.permission_tree_id AS "_o1_permission_tree_id",
_oc1.permission_tree_id AS "_oc1_permission_tree_id",
_uom1.permission_tree_id AS "_uom1_permission_tree_id",
_u.permission_tree_id AS "_u_permission_tree_id",
_u1.permission_tree_id AS "_u1_permission_tree_id",
_a.permission_tree_id AS "_a_permission_tree_id"
FROM
ampc.asset_option_value _aov
JOIN permission_tree_ids permission_join ON _aov.permission_tree_id = permission_join.permission_tree_id
JOIN ampc.option _o ON _aov.option_id = _o.option_id
JOIN ampc.option_category _oc ON _o.option_category_id = _oc.option_category_id
LEFT JOIN gen.unit_of_measurement _uom ON _o.unit_of_measurement_id = _uom.unit_of_measurement_id
LEFT JOIN ampc.asset_type_option _ato ON _aov.asset_type_option_id = _ato.asset_type_option_id
LEFT JOIN ampc.option _o1 ON _ato.option_id = _o1.option_id
LEFT JOIN ampc.option_category _oc1 ON _o1.option_category_id = _oc1.option_category_id
LEFT JOIN gen.unit_of_measurement _uom1 ON _o1.unit_of_measurement_id = _uom1.unit_of_measurement_id
JOIN uam.user _u ON _aov.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _aov.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _aov.permission_tree_id = _pt.permission_tree_id
JOIN ampc.asset _a ON _aov.asset_id = _a.asset_id