laundry_addons


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
laundry_order_addons.addon_id laundry_order_addons_ibfk_2 R
name VARCHAR 100 √ null
code VARCHAR 50 √ null
type enum('per_item', 'per_order', 'per_kg') 9 √ null
price DECIMAL 10,2 √ null
description TEXT 65535 √ null
is_active BIT 1 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation