Bani_Lines
The Bani_Lines table connects one Bani to many Lines.
:::note
The line_group field is slightly more complicated, as it orders collections of lines, but not the lines themselves.
:::
Columns
line_id
The 4 letter unique identifier of a Line.
| Type | Constraints |
|---|---|
| char(4) | Primary Key, Foreign Key (Lines.id) |
bani_id
The unique identifier of the Bani that contains this line.
| Type | Constraints |
|---|---|
| integer | Primary Key, Foreign Key (Banis.id) |
line_group
A partition within the Bani to group Lines. Order by this field, (and the Lines.order_id, if joining) to get the correct order of the groups (and Lines within the groups).
| Type | Constraints |
|---|---|
| integer | Primary Key |