Introduction:

The `orgstructure` table defines the hierarchical organizational units for a given client. It is closely related to the `orgstructuremaster` table, with each entry in this table representing a specific organizational entity within the master structure. The table stores details such as organization names, codes, parent-child relationships, associated branches, and ordering within the hierarchy.

Note: osname and oscode should be the same as the graph option name.

Below is the detailed structure of the table, listing each column, its data type, and its purpose.

Name	Type	Comments
id	int	Unique identifier for each organizational structure entry.
masterosid	int	Foreign key linking to `fw_orgstructuremaster`.
osname	varchar(250)	Name of the organizational structure (e.g., Cluster Midden, Cluster West).
oscode	varchar(150)	Organization code, often mirroring the `osname`.
parentosid	int	ID of the parent organizational unit (0 if it is a top-level unit).
branchid	varchar(250)	Identifies the branch this structure belongs to.
moduleids	varchar(250)	Stores module identifiers associated with the structure.
osorder	int	Defines the order of organizational units within a hierarchy.
status	int	Indicates whether the structure is active (1) or inactive (0).
createdby	int	ID of the user who created this record.
createdon	datetime	Timestamp when the record was created.
modifiedby	int	ID of the user who last modified this record.
modifiedon	datetime	Timestamp when the record was last modified.