tbl_timesheet_contact_person_detail

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_timesheet_contact_person_detail_id_seq'::regclass)
tbl_timesheet_person_contact_person_detail.timesheet_contact_person_detail_id fk__tbl_times__times__04ce4908 R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single contact person record.
contact_person_name varchar 80 √ null

The full name of the contact person at the company/client.
contact_person_email varchar 50 √ null

The primary email address for the contact person.
Format: Varchar(255)
Logic: Used for timesheet approval notifications and general communication.
contact_person_mobile varchar 20 √ null

The mobile or phone number for the contact person.
Format: Varchar/Numeric
Logic: Used for urgent communication.
timesheet_company_detail_id int8 19 null
tbl_timesheet_company_detail.id fk__tbl_times__times__7e214b79 R

FK: public.tbl_timesheet_company_detail.id
Meaning: Links the contact person to the main company or client record.
Dependency: Defines which company this person represents.

Indexes

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

Relationships

Close relationships within degrees of separation