dictionary


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('seq_dictionary_id'::regclass)
conversion.source_dictionary_id conversion_source_dictionary_id_fkey R
conversion.target_dictionary_id conversion_target_dictionary_id_fkey R
data.dictionary_id data_dictionary_id_fkey R
data_field.dictionary_id data_field_dictionary_id_fkey R
data_row.dictionary_id data_row_dictionary_id_fkey R
map.source_dictionary_id map_source_dictionary_id_fkey R
map.target_dictionary_id map_target_dictionary_id_fkey R
row.dictionary_id row_dictionary_id_fkey R
customer_id int8 19 null
customer.id dictionary_customer_id_fkey R
label text 2147483647 null
data_path text 2147483647 null
header_line_number int8 19 null
skip_lines int8 19 0
create_header bool 1 false
dynamic bool 1 false
xml bool 1 false
row_length int8 19 null
column_delimiter text 2147483647 null
field_delimiter text 2147483647 null
create_date timestamptz 35,6 clock_timestamp()
create_user int8 19 null
user_profile.id dictionary_create_user_fkey R
update_date timestamptz 35,6 clock_timestamp()
update_user int8 19 null
user_profile.id dictionary_update_user_fkey R

Table contained 11 rows

Indexes

Constraint Name Type Sort Column(s)
dictionary_pkey Primary key Asc id
dictionary_customer_id_label_key Must be unique Asc/Asc customer_id + label

Relationships