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 |