app_totara_evidence_type

2 rows


Description

Evidence types

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_evidence_type_id_seq'::regclass)
app_totara_evidence_item.typeid Defined in XMLR
app_totara_evidence_type_info_field.typeid Defined in XMLR
name varchar 1024 ''::character varying
idnumber varchar 100 √ null
description text 2147483647 √ null
descriptionformat int2 5 √ 1
location int2 5 null
status int2 5 null
created_by int8 19 null
app_user.id Defined in XMLR
created_at int8 19 null
modified_by int8 19 null
app_user.id Defined in XMLR
modified_at int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_totaevidtype_id_pk Primary key Asc id
app_totaevidtype_cre2_ix Performance Asc created_by
app_totaevidtype_cre_ix Performance Asc created_at
app_totaevidtype_mod2_ix Performance Asc modified_by
app_totaevidtype_mod_ix Performance Asc modified_at

Relationships

Close relationships within degrees of separation