cp1

1378 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cpid int4 10 √ null
job_num varchar 16 null
job.job_num fk_cp1 C
doscompletedby text 2147483647 √ null
dosreviewedby text 2147483647 √ null
holesection text 2147483647 √ null
dosdateofverification timestamptz 32,3 √ null
1a bool 1 √ null
1b bool 1 √ null
1c bool 1 √ null
2a bool 1 √ null
2b bool 1 √ null
2c bool 1 √ null
2d bool 1 √ null
3a bool 1 √ null
3b bool 1 √ null
minimumdeliverablespresent bool 1 √ null
comments text 2147483647 √ null
jobfilelocation text 2147483647 √ null
dateofverification timestamptz 32,3 √ null
controlpointresult text 2147483647 √ null
sesignature text 2147483647 √ null
sdl_cp1 bool 1 null
jobtier int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_cp1 Primary key Asc cpid
IX_cp1_job_num Performance Asc job_num

Relationships

Close relationships within degrees of separation