line_to_sign

1730550 rows


Description

Linking of abstract signs to a line.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
line_to_sign_id INT UNSIGNED 10 null
line_to_sign_owner.line_to_sign_id fk_line_to_sign_owner_to_line_to_signC
sign_id INT UNSIGNED 10 null
sign.sign_id fk_line_to_sign_to_signC
line_id INT UNSIGNED 10 null
line.line_id fk_line_to_sign_to_lineR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc line_to_sign_id
fk_line_to_sign_to_line_idx Performance Asc line_id
line_sign_idx Must be unique Asc/Asc sign_id + line_id

Relationships