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