Table testsql_comments.opac_news Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
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.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 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 at Mon Jul 16 08:37 NZST 2018

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

Close relationships  within of separation: