tbl_holidaybranchmaster

-1 rows


Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for this specific holiday-branch-level allocation.
holidayid int4 10 null
tbl_holidaymaster.holidayid fk__tbl_holid__holid__64ab9239 R

FK: public.tbl_holiday.id (Presumed Foreign Key)
Meaning: Links the allocation rule to the main holiday definition.
Dependency: Allows for querying of which holidays are applied at the branch level.
stateid int8 19 null
tbl_statemaster.stateid Implied Constraint R

FK: public.tbl_state.id (Presumed Foreign Key)
Meaning: The state to which this holiday allocation rule applies.
Logic: Used for regional holiday compliance and application.
branchid int8 19 null
tbl_branchmaster.branchid Implied Constraint R

FK: public.tbl_branch.id (Presumed Foreign Key)
Meaning: The branch or location to which this holiday allocation rule applies.
Logic: Used to target holiday rules to specific physical locations.
companyid int4 10 √ null
tbl_companymaster.companyid companyid_fkhm R

FK: public.tbl_company.id (Presumed Foreign Key)
Meaning: The company or legal entity to which this holiday allocation rule applies.
Logic: Ensures the holiday is only applied within the correct organizational scope.
deptid int4 10 √ null

FK: public.tbl_department.id (Presumed Foreign Key)
Meaning: The department to which this holiday allocation rule applies (if applicable).
Logic: Allows for departmental exceptions or specific holiday allocations.
sbuid int4 10 √ null

FK: public.tbl_sbu.id (Presumed Foreign Key)
Meaning: The Strategic Business Unit (SBU) to which this holiday allocation rule applies (if applicable).
Logic: Allows for holiday allocations to be targeted at the SBU level.

Indexes

Constraint Name Type Sort Column(s)
tbl_holidaybranchmaster_pk_tb_holidaybranchmaster Primary key Asc hbranchid

Relationships

Close relationships within degrees of separation