Table testsql_comments.opac_news
data from the news tool

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
idnew int unsigned 10  √  unique identifier for the news article
branchcode varchar 10  √  null
branches
branch code users to create branch specific news, NULL is every branch.
title varchar 250 title of the news article
content text 65535 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
The user who created the news article

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

Indexes:
Column(s) Type Sort
idnew Primary key Asc
borrowernumber Performance Asc
branchcode Performance Asc

Close relationships  within of separation: