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.

TypeConstraints
char(4)Primary Key,
Foreign Key (Lines.id)

bani_id#

The unique identifier of the Bani that contains this line.

TypeConstraints
integerPrimary 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).

TypeConstraints
integerPrimary Key
Last updated on by Bhajneet S.K