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_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
borrowers.borrowernumber borrowernumber_fk N

The user who created the news article

Table contained 0 rows


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