mapping


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('seq_mapping_id'::regclass)
mapping_function.mapping_id mapping_function_mapping_id_fkey R
map_id int8 19 null
map.id mapping_map_id_fkey R
source_row_id int8 19 null
row.id mapping_source_row_id_fkey R
source_field_id int8 19 null
field.id mapping_source_field_id_fkey R
target_row_id int8 19 null
row.id mapping_target_row_id_fkey R
target_field_id int8 19 null
field.id mapping_target_field_id_fkey R
mapping_order int4 10 null
create_date timestamptz 35,6 clock_timestamp()
create_user int8 19 null
user_profile.id mapping_create_user_fkey R
update_date timestamptz 35,6 clock_timestamp()
update_user int8 19 null
user_profile.id mapping_update_user_fkey R

Table contained 23 rows

Indexes

Constraint Name Type Sort Column(s)
mapping_pkey Primary key Asc id
mapping_map_id_mapping_order_key Must be unique Asc/Asc map_id + mapping_order
mapping_map_id_source_field_id_target_field_id_key Must be unique Asc/Asc/Asc map_id + source_field_id + target_field_id

Relationships