tbl_subcategorymaster

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
subcategoryid bigserial 19 √ nextval('tbl_subcategorymaster_subcategoryid_seq'::regclass)
tbl_employeestructure.subcategoryid Implied Constraint R
tbl_transferrequisitionmaster.subcategory fk_tbl_transferrequisitionmaster_subcategory R
view_employeedetail.subcategoryid Implied Constraint R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a specific item subcategory.
categoryid int8 19 null
tbl_categorymaster.categoryid Implied Constraint R

FK: public.tbl_categorymaster.id (Presumed Foreign Key)
Meaning: The parent category this subcategory belongs to.
Dependency: Creates the two-tier categorization system.
subcatname varchar 60 null

The name or description of the subcategory.
Format: Varchar/Text
Example: “Software License” (under Category “IT Expenses”) or “Fuel” (under Category “Travel”).
subcatcreatedate timestamp 29,6 √ null

Timestamp of when the subcategory record was created.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ
subcatstatus bool 1 √ true

The current status of the subcategory.
Format: Boolean or SmallInt
Logic: Typically used to mark a subcategory as Active (1) or Inactive (0).
subcatisdelete bool 1 √ false

Flag indicating if the subcategory is marked for soft deletion.
Format: Boolean (True/False)
Logic: True means the record is logically deleted but retained for history/audit.
tdscalculation int4 10 √ null

Flag or setting controlling if this subcategory is subject to TDS (Tax Deducted at Source) calculation.
Format: Boolean or SmallInt
Logic: Essential for tax and accounting purposes, especially in India or similar tax jurisdictions.
is_temporary bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_subcategorymaster_pk_tbl_subcategorymaster Primary key Asc subcategoryid

Relationships

Close relationships within degrees of separation