map


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('seq_map_id'::regclass)
conversion.map_id conversion_map_id_fkey R
conversion_map_chain.map_id conversion_map_chain_map_id_fkey R
mapping.map_id mapping_map_id_fkey R
label text 2147483647 null
customer_id int8 19 null
customer.id map_customer_id_fkey R
source_dictionary_id int8 19 null
dictionary.id map_source_dictionary_id_fkey R
target_dictionary_id int8 19 null
dictionary.id map_target_dictionary_id_fkey R
script_mime_type text 2147483647 'text/javascript'::text
script text 2147483647 null
create_date timestamptz 35,6 clock_timestamp()
create_user int8 19 null
user_profile.id map_create_user_fkey R
update_date timestamptz 35,6 clock_timestamp()
update_user int8 19 null
user_profile.id map_update_user_fkey R

Table contained 6 rows

Indexes

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

Relationships