customer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('seq_customer_id'::regclass)
dictionary.customer_id dictionary_customer_id_fkey R
map.customer_id map_customer_id_fkey R
user_profile.customer_id user_profile_customer_id_fkey R
identifier text 2147483647 null
company_name text 2147483647 null
create_date timestamptz 35,6 clock_timestamp()
create_user int8 19 null
user_profile.id customer_create_user_fkey R
update_date timestamp 29,6 clock_timestamp()
update_user int8 19 null
user_profile.id customer_update_user_fkey R

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
customer_pkey Primary key Asc id
customer_identifier_key Must be unique Asc identifier

Relationships