Data Fields table / data_fields - Moodle LMS 3.9 Database schema / Zoola Analytics

data_fields table columns

Related columns Constraint Comments

Search:

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

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

Showing 1 to 16 of 16 entries

Table contained -1 rows

data_fields table indexes

Search:

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

Showing 1 to 3 of 3 entries

data_fields table relationships

Close relationships within degrees of separation

One
Two degrees

Data Fields Table Schema (data_fields)

Description

data_fields table columns

data_fields table indexes

data_fields table relationships

Close relationships within degrees of separation