idnew |
INT UNSIGNED |
10 |
|
√ |
null |
|
|
unique identifier for the news article |
branchcode |
VARCHAR |
10 |
√ |
|
null |
|
branches.branchcode
|
opac_news_branchcode_ibfk C
|
|
branch code users to create branch specific news, NULL is every branch. |
title |
VARCHAR |
250 |
|
|
|
|
|
title of the news article |
content |
MEDIUMTEXT |
16777215 |
|
|
null |
|
|
the body of your news article |
lang |
VARCHAR |
25 |
|
|
|
|
|
location for the article (koha is the staff client, slip is the circulation receipt and language codes are for the opac) |
timestamp |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
pulibcation date and time |
expirationdate |
DATE |
10 |
√ |
|
null |
|
|
date the article is set to expire or no longer be visible |
number |
INT |
10 |
√ |
|
null |
|
|
the order in which this article appears in that specific location |
borrowernumber |
INT |
10 |
√ |
|
null |
|
|
The user who created the news article |