m_holiday

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_holiday_office.holiday_id m_holiday_id_ibfk_1R
name VARCHAR 100 null
from_date DATETIME 19 null
to_date DATETIME 19 null
repayments_rescheduled_to DATETIME 19 √ NULL
status_enum INT 10 100
processed BIT 1 b'0'
description VARCHAR 100 √ NULL
rescheduling_type INT 10 2

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
holiday_name Must be unique Asc/Asc name + from_date

Relationships

Close relationships within degrees of separation