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