| 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 |
