questions_run

288859 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
job_num varchar 16 null
jr_key.job_num fk_questions_run C
run_no int4 10 0
jr_key.run_no fk_questions_run C
quest_id int4 10 √ null
Questions.Id FK_questions_run_Questions_quest_id R
answer_value text 2147483647 √ null
mergeid int4 10 √ null
jbit text 2147483647 √ null
run.jbit Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PK_questions_run Primary key Asc id
IX_questions_run_job_num_run_no Performance Asc/Asc job_num + run_no
IX_questions_run_quest_id Performance Asc quest_id

Relationships

Close relationships within degrees of separation