field


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('seq_field_id'::regclass)
data_field.field_id data_field_field_id_fkey R
dynamic_field.field_id dynamic_field_field_id_fkey R
field.aggregate_field_id field_aggregate_field_id_fkey R
mapping.source_field_id mapping_source_field_id_fkey R
mapping.target_field_id mapping_target_field_id_fkey R
rule.field_id rule_field_id_fkey R
row_id int8 19 null
row.id field_row_id_fkey R
data_type_id int8 19 get_data_type_id('STRING'::text)
data_type.id field_data_type_id_fkey R
data_format text 2147483647 null
label text 2147483647 null
position int4 10 null
length int8 19 null
aggregate_definition_id int8 19 null
aggregate_definition.id field_aggregate_definition_id_fkey R
aggregate_row_id int8 19 null
row.id field_aggregate_row_id_fkey R
aggregate_field_id int8 19 null
field.id field_aggregate_field_id_fkey R
min_occurrence int4 10 1
max_occurrence int4 10 1
create_date timestamptz 35,6 clock_timestamp()
create_user int8 19 null
update_date timestamptz 35,6 clock_timestamp()
update_user int8 19 null

Table contained 12 rows

Indexes

Constraint Name Type Sort Column(s)
field_pkey Primary key Asc id
field_row_id_label_key Must be unique Asc/Asc row_id + label

Relationships