Data Fields Table Schema (data_fields)


Description

every field available

data_fields table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
data_content.fieldid datacont_fie2_fk R
dataid BIGINT 19 0
data.id datafiel_dat2_fk R
type VARCHAR 255
name VARCHAR 255
description LONGTEXT 2147483647 null
required BIT 0 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

Table contained -1 rows

data_fields table 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

data_fields table relationships