opac_news

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
borrowers.borrowernumber borrowernumber_fkN

The user who created the news article

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc idnew
borrowernumber_fk Performance Asc borrowernumber
opac_news_branchcode_ibfk Performance Asc branchcode

Relationships