delivery_methods


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
notifications.delivery_method_id fk_notifications_delivery_method R
name VARCHAR 50 null
description VARCHAR 255 √ null
created_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
created_by VARCHAR 100 √ null
updated_by VARCHAR 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_delivery_methods_name Performance Asc name
name Must be unique Asc name

Relationships

Close relationships within degrees of separation