Regular Asset Type Option

Table

Database	Table	Entity	On Key 5 Conversions	On Key 5 Tables	Other Entities stored in same Table
`Transaction`	`ampc.asset_type_option`	Regular Asset Type Option

Columns

Property	Db Table	Db Column	Db DataType	Nullable	Primary Key	Joins
`CreatedByUserId`	`ampc.asset_type_option`	`created_by_user_id`	bigint	False
`CreatedByUserCode`	`uam.user`	`code`	character varying(50)	False		`ampc.asset_type_option.created_by_user_id = uam.user.user_id`
`CreatedByUserFullName`	`uam.user`	`full_name`	character varying(200)	False		`ampc.asset_type_option.created_by_user_id = uam.user.user_id`
`CreatedOn`	`ampc.asset_type_option`	`created_on`	timestamp without time zone	False
`ModifiedByUserId`	`ampc.asset_type_option`	`modified_by_user_id`	bigint	False
`ModifiedByUserCode`	`uam.user`	`code`	character varying(50)	False		`ampc.asset_type_option.modified_by_user_id = uam.user.user_id`
`ModifiedByUserFullName`	`uam.user`	`full_name`	character varying(200)	False		`ampc.asset_type_option.modified_by_user_id = uam.user.user_id`
`ModifiedOn`	`ampc.asset_type_option`	`modified_on`	timestamp without time zone	False
`Version`	`ampc.asset_type_option`	`version`	integer	False
`Id`	`ampc.asset_type_option`	`asset_type_option_id`	bigint	False	True
`AssetTypeId`	`ampc.asset_type_option`	`asset_type_id`	bigint	False
`AssetTypeCode`	`ampc.asset_type`	`code`	character varying(50)	False		`ampc.asset_type_option.asset_type_id = ampc.asset_type.asset_type_id`
`AssetTypeDescription`	`ampc.asset_type`	`description`	character varying(100)	False		`ampc.asset_type_option.asset_type_id = ampc.asset_type.asset_type_id`
`OptionId`	`ampc.asset_type_option`	`option_id`	bigint	False
`OptionCode`	`ampc.option`	`code`	character varying(50)	False		`ampc.asset_type_option.option_id = ampc.option.option_id`
`OptionDescription`	`ampc.option`	`description`	character varying(100)	False		`ampc.asset_type_option.option_id = ampc.option.option_id`
`OptionDataType`	`ampc.option`	`data_type`	ampc.option_data_type	False		`ampc.asset_type_option.option_id = ampc.option.option_id`
`OptionLowerBounds`	`ampc.option`	`lower_bounds`	character varying(100)	True		`ampc.asset_type_option.option_id = ampc.option.option_id`
`OptionUpperBounds`	`ampc.option`	`upper_bounds`	character varying(100)	True		`ampc.asset_type_option.option_id = ampc.option.option_id`
`OptionAllowMultipleValues`	`ampc.option`	`allow_multiple_values`	boolean	False		`ampc.asset_type_option.option_id = ampc.option.option_id`
`OptionOptionCategoryId`	`ampc.option_category`	`option_category_id`	bigint	False	True	`ampc.asset_type_option.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_type_option.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_type_option.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_type_option.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_type_option.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_type_option.option_id = ampc.option.option_id` Then `ampc.option.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_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`

Queries

The list of example Regular Asset Type Option queries can be interpreted using the following legend:

Legend	Description
Primary Table Alias	The alias for the `ampc.asset_type_option` 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
`_ato`	False	False

SELECT
    _ato.created_by_user_id AS "CreatedByUserId",
    _ato.created_on AS "CreatedOn",
    _ato.modified_by_user_id AS "ModifiedByUserId",
    _ato.modified_on AS "ModifiedOn",
    _ato.version AS "Version",
    _ato.asset_type_option_id AS "Id",
    _ato.asset_type_id AS "AssetTypeId",
    _ato.option_id AS "OptionId"
FROM
    ampc.asset_type_option _ato

Query 2

Primary Table Alias	Include References	Include Permissions
`_ato`	True	False

SELECT
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _ato.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _ato.modified_on AS "ModifiedOn",
    _ato.version AS "Version",
    _ato.asset_type_option_id AS "Id",
    _at.asset_type_id AS "AssetTypeId",
    _at.code AS "AssetTypeCode",
    _at.description AS "AssetTypeDescription",
    _o.option_id AS "OptionId",
    _o.code AS "OptionCode",
    _o.description AS "OptionDescription",
    _o.data_type AS "OptionDataType",
    _o.lower_bounds AS "OptionLowerBounds",
    _o.upper_bounds AS "OptionUpperBounds",
    _o.allow_multiple_values AS "OptionAllowMultipleValues",
    _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"
FROM
    ampc.asset_type_option _ato
    JOIN uam.user _u ON _ato.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _ato.modified_by_user_id = _u1.user_id
    JOIN ampc.asset_type _at ON _ato.asset_type_id = _at.asset_type_id
    JOIN ampc.option _o ON _ato.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

Table of Contents

Regular Asset Type Option

Table

Columns

Enumerations

Mapping 1

Queries

Query 1

Query 2