jl_metrics
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
dim_location
-1
rows
Description
Deprecated
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
dim_location_id
serial
10
√
nextval('dim_location_id'::regclass)
customer
.dim_location_id
customer_dim_location_id_fkey
R
sales
.dim_location_id
Implied Constraint
R
country
text
2147483647
null
suburb
text
2147483647
null
state
text
2147483647
null
Indexes
Constraint Name
Type
Sort
Column(s)
dim_location_pkey
Primary key
Asc
dim_location_id
Relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied