tbl_assets_vendor_persons

-1 rows


Description

Module: Asset Management - Vendor Contact Person Details
Purpose: Stores the contact information for key personnel (representatives) at the asset vendors listed in tbl_assets_vendor.
Data: Captures the person’s name, designation, mobile number, email, and any specific remarks, linking them to their master vendor record.
Process Usage:
- Vendor Communication: Provides direct contact details for ordering assets, following up on warranties, or scheduling maintenance/support.
- Relationship Management: Allows the HR/Admin team to maintain an organized list of who to contact at each vendor.
Key Points:
- Detail Record: Acts as a detail table for the master tbl_assets_vendor record.
- Essential for transactional efficiency in asset procurement and support.
Business Impact: Streamlines communication and follow-up with external asset providers, supporting efficient asset lifecycle management.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific vendor contact person.
vendor_id int8 19 null

FK: public.tbl_assets_vendor.id
Meaning: The ID of the asset vendor this person is associated with.
person_name varchar 200 null

The full name of the contact person at the vendor.
person_designation varchar 100 √ null

The job title or designation of the contact person (e.g., “Sales Manager,” “Technical Support Head”).
mobile_number varchar 15 √ null

The primary mobile or phone number for the contact person.
email_address varchar 50 √ null

The primary email address for the contact person.
remarks varchar 1000 √ null

Any internal notes or remarks about this vendor contact (e.g., “Prefers email contact,” “Handles all laptop issues”).
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation