line_ent_link
- Last UpdatedNov 20, 2024
- 3 minute read
The line_ent_link table defines entities that are members of a line or the entities that are the parents of a line.
Note: This table could also define entity classes that are members of a line class, but this capability is not currently used. The line class behavior is: If line_class is true for the line record identified by line_id, then ent_class must be true for the ent record identified by ent_id, and vice versa; and if line_class is false for the line record identified by line_id, then ent_class must be false for the ent record identified by ent_id, and vice versa.
A line consists of 0 or more entities (however, to be an actual line, it should have at least 2). It may also have 1 entity as its parent entity.
An entity may belong to 0 or more lines. An entity may only be placed in a given line once, not at multiple positions. An entity may be the parent of multiple lines. The same entity cannot be both a member of a line as well as a parent of a line.
There should be no assumption that the child_order values for a particular line_id are contiguous or start at a given number. If line_class and line_is_child are both false, the entity identified by ent_id must be one where can_run_jobs is true.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
line_id |
int32 |
Y |
N |
Identifies the line. Note: This field could also identify a line class, but that capability is currently not used. |
|
ent_id |
int32 |
Y |
N |
Identifies the entity. Note: This field could also identify an entity class, but that capability is currently not used. |
|
child_order |
int32 |
N |
Y |
Specifies the relative order of entities in a line. For lines, child entities that are in parallel will have the same child_order value. Will be null if line_is_child is true. Note: This field could also identify the relative order of entity classes in a line class, but that capability is currently not used. |
|
input_pct |
tfloat |
N |
Y |
For parallel entities in a line, specifies how much of the outflow from the set of child entities with the same parent and a child_order that is the next lower value to this one goes to the child entity. Will be null if line_is_child is true. |
|
line_is_child |
logical |
N |
N |
If false (default), this record is used to specify an entity that belongs to the line. If true, this record is used to specify an entity that is the parent of the line, so that the line can be shown under this entity in an entity tree. In the latter case the entity would be a higher level entity such as a building or site. Note: This field could also specify entity classes that belong to a line class, but that capability is currently not used. |
|
segment_no |
int32 |
N |
Y |
Null (default) if the entity is not part of a line segment; otherwise, the number of the line segment to which the entity belongs, starting at 1. Always null if line_is_child is true. Note: This field could also apply to line classes, but that capability is currently not used. The line class capability is: For line classes, a value of 1 means that when multiple entities identified from this entity class for lines instantiated from this line class should by default be placed in separate segments. It should not be possible to save a line or a line class where this is not null for at least two adjacent child_order values (i.e., no segments that are only one position long). |
|
can_be_bottleneck |
logical |
N |
N |
True (default) if the entity is to be considered when calculating the line's bottleneck. Will be false unless the entity can run jobs. Not meaningful if line_is_child is true. Note: This field could also apply to entity classes, but that capability is currently not used. The entity class capability is: For entity classes, this serves as a default setting for entities selected from that class. |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail. |
FK from line_id to line. (Cascade delete)
FK from ent_id to ent. (Cascade delete)