jr_key

42725 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
job_num varchar 16 null
activity.job_num fk_activity C
actual_survey.job_num fk_actual_survey C
cam_sam.job_num fk_cam_sam C
insite_health.job_num fk_insite_health C
questions_run.job_num fk_questions_run C
run.job_num fk_run C
surface_parameters.job_num fk_surface_parameters C
job.job_num fk_jr_key C
run_no int4 10 null
activity.run_no fk_activity C
actual_survey.run_no fk_actual_survey C
cam_sam.run_no fk_cam_sam C
insite_health.run_no fk_insite_health C
questions_run.run_no fk_questions_run C
run.run_no fk_run C
surface_parameters.run_no fk_surface_parameters C
rid int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_jr_key Primary key Asc/Asc job_num + run_no

Relationships

Close relationships within degrees of separation