| id |
bigserial |
19 |
|
√ |
nextval('tbl_timesheet_person_contact_person_detail_id_seq'::regclass) |
|
|
Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single mapping record between an employee’s work detail and a specific contact person. |
| timesheet_contact_person_detail_id |
int8 |
19 |
|
|
null |
|
|
FK: public.tbl_timesheet_contact_person_detail.id
Meaning: The contact person who is responsible for or receives this timesheet detail.
Logic: Links the submitted work to the client/company contact for approval or information. |
| timesheet_person_company_detail_id |
int8 |
19 |
|
|
null |
|
|
FK: public.tbl_timesheet_person_company_detail.id
Meaning: The parent timesheet entry which links to the daily work and the client/company.
Dependency: This table acts as a join between the employee’s recorded work and the required contact person. |
