m_external_asset_owner

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_external_asset_owner_journal_entry_mapping.owner_id FK_ext_asset_owner_je_mapping_owner_id R
m_external_asset_owner_transfer.owner_id FK_external_asset_owner_transfer_owner_id R
m_external_asset_owner_transfer.previous_owner_id FK_external_asset_owner_transfer_previous_owner R
m_journal_entry_aggregation_summary.external_owner_id fk_gl_journal_entry_aggregation_summary_on_external_owner_id R

Internal ID
external_id varchar 100 null

External id of asset owner
created_by int8 19 √ null
m_appuser.id FK_external_asset_owner_created_by R
created_on_utc timestamptz 35,6 √ null
last_modified_by int8 19 √ null
m_appuser.id FK_external_asset_owner_modified_by R
last_modified_on_utc timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
m_external_asset_owner_pkey Primary key Asc id
UQ_external_asset_owner_external_id Must be unique Asc external_id

Relationships

Close relationships within degrees of separation