tbl_categorymaster

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
categoryid bigserial 19 √ nextval('tbl_categorymaster_categoryid_seq'::regclass)
tbl_employeestructure.categoryid Implied Constraint R
tbl_generalpolicy.categoryid Implied Constraint R
tbl_subcategorymaster.categoryid Implied Constraint R
tbl_transferrequisitionmaster.category fk_tbl_transferrequisitionmaster_category R
view_employeedetail.categoryid Implied Constraint R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a top-level classification/category.
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R

FK: public.tbl_company.id or similar (Presumed Foreign Key)
Meaning: The company to which this category belongs.
Logic: Used for multi-tenant systems to ensure data segregation.
categoryname varchar 60 null

The name or title of the category.
Format: Varchar/Text
Example: “Travel Expenses,” “Software,” “Hardware.”
catdescription varchar 500 √ null

A brief description providing context for the category.
Format: Text
Usage: Helps users understand what items/transactions belong under this classification.
catcreatedate timestamp 29,6 √ null

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

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

Flag indicating if the category is marked for soft deletion.
Format: Boolean (True/False)
Logic: True means the record is logically deleted but retained for history/audit.

Indexes

Constraint Name Type Sort Column(s)
tbl_categorymaster_pk_tbl_categorymaster Primary key Asc categoryid

Relationships

Close relationships within degrees of separation