license


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
lic_id uuid 2147483647 null
license_amendment_status.las_amendment_id license_amendment_status_las_amendment_id_fkeyR
remote_license_link.rol_remote_id remote_license_link_rol_remote_id_fkeyR
internal_contact.ic_owner_fk internal_contact_ic_owner_fk_fkeyR
license_org.sao_owner_fk license_org_sao_owner_fk_fkeyR
lic_version int8 19 √ null
lic_date_created timestamp 29,6 √ null
custom_properties_id int8 19 √ null
lic_last_updated timestamp 29,6 √ null
lic_name varchar 102 √ null
lic_type_rdv_fk varchar 32 √ null
lic_status_rdv_fk varchar 32 √ null
lic_description varchar 574 √ null
lic_end_date date 13 √ null
lic_start_date date 13 √ null
lic_end_date_semantics_fk varchar 32 √ null
class varchar 33 √ null
am_owning_license_fk varchar 36 √ null
lic_local_reference varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
license_pkey Primary key Asc lic_id
license___origin_idx Performance Asc __origin
license___source_idx Performance Asc __source
license___start_idx Performance Asc __start
license_am_owning_license_fk_idx Performance Asc am_owning_license_fk
license_class_idx Performance Asc class
license_custom_properties_id_idx Performance Asc custom_properties_id
license_lic_date_created_idx Performance Asc lic_date_created
license_lic_description_idx Performance Asc lic_description
license_lic_end_date_idx Performance Asc lic_end_date
license_lic_end_date_semantics_fk_idx Performance Asc lic_end_date_semantics_fk
license_lic_id_idx Performance Asc lic_id
license_lic_last_updated_idx Performance Asc lic_last_updated
license_lic_local_reference_idx Performance Asc lic_local_reference
license_lic_name_idx Performance Asc lic_name
license_lic_start_date_idx Performance Asc lic_start_date
license_lic_status_rdv_fk_idx Performance Asc lic_status_rdv_fk
license_lic_type_rdv_fk_idx Performance Asc lic_type_rdv_fk
license_lic_version_idx Performance Asc lic_version

Relationships

Close relationships within degrees of separation