Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
View
pvsadmin
.
public
.
v_npat
Generated by
SchemaSpy
Implied relationships
Related columns
Constraints
Comments
Legend
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
<
n
> number of related tables
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
npatmatrix_id
int4
10
√
null
npatform_id
int4
10
√
null
npatrow_id
int4
10
√
null
npatrowshorttext
.npatrow_id
Implied Constraint
R
npatrowtype_id
int4
10
√
null
npatoptiongroup_id
int4
10
√
null
npatoptiongroup
.npatoptiongroup_id
Implied Constraint
R
path
ltree
2147483647
√
null
open
bool
1
√
null
npatrow_text
text
2147483647
√
null
nm_rank
int2
5
√
null
wordlimit
int2
5
√
null
profile
bool
1
√
null
Analyzed at Tue Jan 03 04:46 MST 2017
Close relationships: