tbl_assessment_attempt

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
attempt_id bigserial 19 √ nextval('tbl_assessment_attempt_attempt_id_seq'::regclass)
tbl_answer.attempt_id tbl_answer_attempt_id_fkey C
assessment_id int8 19 null
tbl_assessment.assessment_id tbl_assessment_attempt_assessment_id_fkey C
employee_id varchar 100 null
attempt_date timestamp 29,6 √ null
total_score int4 10 √ null
status varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_assessment_attempt_pkey Primary key Asc attempt_id

Check Constraints

Constraint Name Constraint
tbl_assessment_attempt_status_check (((status)::text = ANY (ARRAY[('PASSED'::character varying)::text, ('FAILED'::character varying)::text])))

Relationships

Close relationships within degrees of separation