data_fields

0 rows


Description

every field available

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
data_content.fieldid datacont_fie2_fkR
dataid BIGINT 19 0
data.id datafiel_dat2_fkR
type VARCHAR 255
name VARCHAR 255
description LONGTEXT 2147483647 null
required BIT 1 0

Required fields must have a value when inserted by a user

param1 LONGTEXT 2147483647 null
param2 LONGTEXT 2147483647 null
param3 LONGTEXT 2147483647 null
param4 LONGTEXT 2147483647 null
param5 LONGTEXT 2147483647 null
param6 LONGTEXT 2147483647 null
param7 LONGTEXT 2147483647 null
param8 LONGTEXT 2147483647 null
param9 LONGTEXT 2147483647 null
param10 LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
datafiel_dat_ix Performance Asc dataid
datafiel_typdat_ix Performance Asc/Asc type + dataid

Relationships