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

unique identifier assigned by Koha

branchcode VARCHAR 10

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