additional_contents

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idnew INT UNSIGNED 10 null

unique identifier for the additional content

category VARCHAR 20 null

category for the additional content

code VARCHAR 100 null

code to group content per lang

location VARCHAR 255 null

location of the additional content

branchcode VARCHAR 10 null
branches.branchcode additional_contents_branchcode_ibfkC

branch code users to create branch specific additional content, NULL is every branch.

title VARCHAR 250

title of the additional content

content MEDIUMTEXT 16777215 null

the body of your additional content

lang VARCHAR 50

location for the additional content(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 additional content is set to expire or no longer be visible

number INT 10 null

the order in which this additional content appears in that specific location

borrowernumber INT 10 null
borrowers.borrowernumber borrowernumber_fkN

The user who created the additional content

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc idnew
additional_contents_borrowernumber_fk Performance Asc borrowernumber
additional_contents_branchcode_ibfk Performance Asc branchcode
additional_contents_uniq Must be unique Asc/Asc/Asc/Asc category + code + branchcode + lang

Relationships