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

Table contained 0 rows


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