tbl_candidate_offer_history

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_candidate_offer_history_id_seq'::regclass)
candidate_offer_id int8 19 null
tbl_candidate_offer.id fk_tbl_candidate_offer_offer_id R
history_type varchar 50 null
history_object text 2147483647 null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to this history record itself.
Stored as: UTC
Logic: As with “modifiedby”, this is rarely used and should be NULL if the log is immutable.

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_candidate_offer_history Primary key Asc id

Relationships

Close relationships within degrees of separation