repeatable_holidays

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

unique identifier assigned by Koha

branchcode VARCHAR 10 null
branches.branchcode repeatable_holidays_ibfk_1 C

foreign key from the branches table, defines which branch this closing is for

weekday SMALLINT 5 null

day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on

day SMALLINT 5 null

day of the month this closing is on

month SMALLINT 5 null

month this closing is in

title VARCHAR 50

title of this closing

description MEDIUMTEXT 16777215 null

description for this closing

Indexes

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

Relationships