fixture_types


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
fixture_template_types.type_id FK55C1C56A375E5FC R
project_fixtures.type_id FKA2AA99F0375E5FC R
site_fixtures.type_id FK143DD982375E5FC R
version BIGINT 19 null
code VARCHAR 10 null
description VARCHAR 100 null
dimensions VARCHAR 100 null
lead_time VARCHAR 100 null
notes LONGTEXT 2147483647 √ null
part_number VARCHAR 100 null
vendor LONGTEXT 2147483647 √ null
category_id BIGINT 19 √ null
fixture_type_categories.id FK39A64AC3124156D6 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
code Must be unique Asc code
FK39A64AC3124156D6 Performance Asc category_id

Relationships

Close relationships within degrees of separation