cp4

979 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cpid int4 10 √ null
job_num varchar 16 √ null
job.job_num fk_cp4 C
coordinator text 2147483647 √ null
holesection text 2147483647 √ null
1a bool 1 √ null
1b bool 1 √ null
1c bool 1 √ null
1d bool 1 √ null
1e bool 1 √ null
servicecoordinator text 2147483647 √ null
dateofverification timestamptz 32,3 √ null
controlpointresult text 2147483647 √ null
comments text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_cp4 Primary key Asc cpid
IX_cp4_job_num Performance Asc job_num

Relationships

Close relationships within degrees of separation