additional_field_values

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

primary key identifier

field_id INT 10 null
additional_fields.id afv_fk C

foreign key references additional_fields(id)

record_table VARCHAR 255 ''

tablename of the related record

record_id VARCHAR 80 ''

record_id

value VARCHAR 255 ''

value for this field

Indexes

Constraint Name Type Sort Column(s)
additional_field_values_s_pk Primary key Asc id
afv_fk Performance Asc field_id
PRIMARY Must be unique Asc id
record_table Performance Asc record_table

Relationships