absence

0 rows


Description

Holds all absence records

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('absence_id_seq'::regclass)

Unique ID
id_tenant int4 10 1

Reference to the tenant
created_at timestamp 29,6 now()

Timestamp of creation
updated_at timestamp 29,6 now()

Timestamp of last update
id_creator int4 10 null
user.id fk_absence_id_creator R

Reference to the creator
id_updater int4 10 null
user.id fk_absence_id_updater R

Reference to the last updater
id_user int4 10 null
user.id fk_absence_id_user R

Reference to the user this absence belongs to
id_absencetype int2 5 null
absencetype.id fk_absence_id_absencetype R

Reference to the absence type
id_approvaltype int2 5 1
approvaltype.id fk_absence_id_approvaltype R

Reference to the approval type
started_at timestamp 29,6 null

Timestamp when the absence started
stopped_at timestamp 29,6 √ null

Timestamp when the absence stopped
note_request text 2147483647 null

The note of the person who requested the absence (normally the employee like driver, assistant, etc.)
note_response text 2147483647 √ null

The note of the person who approved the absence (normally the personnel employee)

Indexes

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

Check Constraints

Constraint Name Constraint
c_absence_stopped_after_started ((started_at < stopped_at))

Relationships

Close relationships within degrees of separation