app_totara_evidence_type_info_field

10 rows


Description

Evidence fields

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_evidence_type_info_field_id_seq'::regclass)
app_totara_evidence_type_info_data.fieldid Defined in XMLR
typeid int8 19 √ null
app_totara_evidence_type.id Defined in XMLR
fullname varchar 1333 √ null
shortname varchar 1333 √ null
datatype varchar 255 √ null
description text 2147483647 √ null
sortorder int8 19 null
hidden int2 5 null
locked int2 5 null
required int2 5 null
forceunique int2 5 null
defaultdata text 2147483647 √ null
param1 text 2147483647 √ null
param2 text 2147483647 √ null
param3 text 2147483647 √ null
param4 text 2147483647 √ null
param5 text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
app_totaevidtypeinfofiel_id_pk Primary key Asc id
app_totaevidtypeinfofiel_da_ix Performance Asc datatype
app_totaevidtypeinfofiel_ty_ix Performance Asc typeid

Relationships

Close relationships within degrees of separation