| idnew |
INT UNSIGNED |
10 |
|
√ |
null |
|
|
unique identifier for the news article |
| branchcode |
VARCHAR |
10 |
√ |
|
null |
|
| branches.branchcode |
opac_news_branchcode_ibfkC |
|
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 |
50 |
|
|
|
|
|
location for the article (koha is the staff interface, slip is the circulation receipt and language codes are for the opac) |
| published_on |
DATE |
10 |
√ |
|
null |
|
|
publication date |
| updated_on |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
last modification |
| 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 |
