tbl_timesheet_person_company_detail

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_timesheet_person_company_detail_id_seq'::regclass)
tbl_timesheet_person_contact_person_detail.timesheet_person_company_detail_id fk__tbl_times__times__05c26d41 R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single mapping record.
timesheet_company_detail_id int8 19 null
tbl_timesheet_company_detail.id fk__tbl_times__times__00fdb824 R

FK: public.tbl_timesheet_company_detail.id
Meaning: The company or client to which the daily work is related.
Dependency: Links the timesheet detail back to the client/company definition.
daily_report_id int8 19 null
tbl_dailyreport.dailyreportid fk__tbl_times__daily__01f1dc5d R

FK: public.tbl_daily_report.id or similar (Presumed Foreign Key)
Meaning: Links the company detail to the specific daily timesheet or activity record.
Logic: Used to group client-related work within a specific day’s report.
createdby varchar 50 null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who created this record, likely the employee submitting the timesheet.
createddate timestamp 29,6 √ null

Timestamp of when the company detail entry was created.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user who modified this record.
modifieddate timestamp 29,6 √ null

Timestamp of when the company detail entry was last modified.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ

Indexes

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

Relationships

Close relationships within degrees of separation