What and why to refactor
Several tables contain a column named component, but the column definition is not consistent across the schema.
Columns representing the same business concept (component) should ideally share a common data type and sizing strategy across the database schema.
Diferent types identified:
- VARCHAR(100)
- VARCHAR(191)
- VARCHAR(255)
- VARCHAR(500)
- TEXT
Describe the solution you'd like
Review all database tables containing a component column and standardize them using a single data type.
Suggested type TEXT
Related issues
#8993
What and why to refactor
Several tables contain a column named component, but the column definition is not consistent across the schema.
Columns representing the same business concept (component) should ideally share a common data type and sizing strategy across the database schema.
Diferent types identified:
Describe the solution you'd like
Review all database tables containing a component column and standardize them using a single data type.
Suggested type
TEXTRelated issues
#8993