tbl_companymaster

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyid serial 10 √ nextval('tbl_companymaster_companyid_seq'::regclass)
eventmailermailconfiguration.companyid Implied Constraint R
imagegallery.cmpid fk__imagegall__cmpid__659fb672 R
systemworkflow.cmpid fk__systemwor__cmpid__5845bb54 R
tbl_aboutyourself.companyid Implied Constraint R
tbl_aboutyourselfhistory.companyid Implied Constraint R
tbl_announcement.companyid Implied Constraint R
tbl_attendanceoutstation.companyid Implied Constraint R
tbl_attendancerequest.companyid Implied Constraint R
tbl_branchmaster.companyid fk__tbl_branc__compa__5b2227ff R
tbl_categorymaster.companyid Implied Constraint R
tbl_departmentofcompany.cmpid fk__tbl_depar__cmpid__5c164c38 R
tbl_emailsmtpmaster.companyid fk__tbl_email__compa__6693daab R
tbl_employee.companyid fk_employee_sbu R
tbl_employee_previous_pf.companyid Implied Constraint R
tbl_employeebankdetailhistory.companyid Implied Constraint R
tbl_employeecontactinfohistory.companyid Implied Constraint R
tbl_employeehistory.companyid Implied Constraint R
tbl_employeenomineehistory.companyid Implied Constraint R
tbl_employeeselectedtdsslab.companyid Implied Constraint R
tbl_employeestructure.sbuid fk_employeestru_sbu R
tbl_generalpolicy.companyid Implied Constraint R
tbl_holidaybranchmaster.companyid companyid_fkhm R
tbl_holidaymaster.companyid companyid_fk R
tbl_holidaymaster.sbuid fk__tbl_holid__sbuid__62c349c7 R
tbl_hrsetupmaster.companyid Implied Constraint R
tbl_leaveapplicationheader.companyid Implied Constraint R
tbl_leavereport.companyid Implied Constraint R
tbl_moodmeterdata.companyid Implied Constraint R
tbl_paidretentiondetails.companyid Implied Constraint R
tbl_paidunpaidperformancerewards.companyid Implied Constraint R
tbl_reportfooterreference.companyid Implied Constraint R
tbl_rolemaster.companyid Implied Constraint R
tbl_rolemasterhistory.companyid Implied Constraint R
tbl_shiftmasterv1history.companyid Implied Constraint R
tbl_statemaster.companyid fk__tbl_state__compa__5939df8d R
tbl_systemworkflow.cmpid fk__tbl_syste__cmpid__5751971b R
tbl_teamtransfer.companyid fk_tbl_teamtransfer_companyid R
tbl_teamtransfermembers.companyid fk_tbl_teamtransfermembers_companyid R
tbl_ticket.companyid fk_tbl_ticket_companyid R
tbl_ticketcategory.companyid fk_tbl_ticketcategory_companyid R
tbl_tickethistory.companyid fk_tbl_tickethistory_companyid R
tbl_ticketstatus.companyid fk_tbl_ticketstatus_companyid R
tbl_todaysthought.companyid Implied Constraint R
tbl_transferrequisitionmaster.companyid fk_tbl_transferrequisitionmaster_companyid R
tbl_transferrequisitionmaster.sbuid fk_tbl_transferrequisitionmaster_sbuid R
tbl_userlogin.companyid Implied Constraint R
tbl_userlogin_bkp2023121.companyid Implied Constraint R
tds_declarationcategorymaster.companyid Implied Constraint R
view_employeedetail.companyid Implied Constraint R
companyname varchar 200 null
companyshortname varchar 30 √ null
companyaddress varchar 300 √ null
companycity varchar 40 √ null
companystate varchar 40 √ null
companycountry varchar 40 √ null
companyphone varchar 15 √ null
companyphone1 varchar 15 √ null
comapnymobile varchar 15 √ null
companyfax varchar 15 √ null
companyemail varchar 500 √ null
companyurl varchar 100 √ null
companytype varchar 60 √ null
companyregistrationno varchar 30 √ null
companyregistrationdate timestamp 29,6 √ null
companybankname varchar 60 √ null
companybankbranchno varchar 30 √ null
companybankaddress varchar 200 √ null
companybankaccno varchar 20 √ null
companypanno varchar 15 √ null
companypfno varchar 100 √ null
companyesino varchar 100 √ null
companyvatregistrationno varchar 25 √ null
companytanno varchar 20 √ null
companygratuitypno varchar 100 √ null
companygratuityredate timestamp 29,6 √ null
varchar 2147483647 √ null
companycreatedate timestamp 29,6 √ null
companystatus bool 1 √ true
cisdelete bool 1 √ false
companypin varchar 10 √ null
com1 varchar 2147483647 √ null
com2 varchar 2147483647 √ null
com3 timestamp 29,6 √ null
com4 numeric 0 √ null
com5 numeric 0 √ null
iscmpentitysbu int2 5 √ null
paretid int4 10 √ null
firstname varchar 200 √ null
lastname varchar 200 √ null
email varchar 200 √ null
phone varchar 20 √ null
mobile varchar 15 √ null
staffemailid varchar 100 √ null
issalaryprocessed bool 1 false
companywisepayslip bool 1 true
shouldhrreceiveticketmail bool 1 √ true
salaryslippostupdatesonhremail bool 1 √ true
salaryslipformat varchar 50 '''SalarySlipFormat7'''::character varying
shouldhrreceiveshiftnotassignedmail bool 1 true
companypayrollstartdate timestamp 29,6 √ null
publishform16forcurrentfinancialyear bool 1 true
createddate timestamp 29,6 √ null
createdby varchar 500 √ null
modifiedby varchar 500 √ null
modifieddate timestamp 29,6 √ null
countryid int8 19 √ null
stateid int8 19 √ null
tbl_statemaster.stateid Implied Constraint R
cityid int8 19 √ null
pfid int8 19 √ null
esicid int8 19 √ null
gratuityid int8 19 √ null
bankifscno varchar 30 √ null
facebooklink varchar 200 √ null
linkedinlink varchar 200 √ null
instagramlink varchar 200 √ null
twitterlink varchar 200 √ null
youtubelink varchar 200 √ null
head_of_sbu varchar 100 √ null
sbu_report_to varchar 100 √ null
is_employee_id_by_sbu bool 1 √ null
is_salaryslip_rotated bool 1 √ null
companyphotos text 2147483647 √ null

File path or URL to a general company photo (e.g., office building).
Format: TEXT
Example: “/uploads/images/office_building.jpg”

Indexes

Constraint Name Type Sort Column(s)
tbl_companymaster_pk_tbl_companymaster Primary key Asc companyid

Relationships

Close relationships within degrees of separation