Table testsql_comments.serial
issues related to subscriptions

Generated by
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
serialid int 10  √ 
serialitems.serialid serialitems_sfk_1 C
unique key for the issue
biblionumber varchar 100 foreign key for the biblio.biblionumber that this issue is attached to
subscriptionid varchar 100 foreign key to the subscription.subscriptionid that this issue is part of
serialseq varchar 100 issue information (volume, number, etc)
status tinyint 3 0 status code for this issue (see manual for full descriptions)
planneddate date 10  √  null date expected
notes text 65535  √  null notes
publisheddate date 10  √  null date published
claimdate date 10  √  null date claimed
claims_count int 10  √  0 number of claims made related to this issue
routingnotes text 65535  √  null notes from the routing list

Table contained 0 rows at Tue Dec 27 17:46 NZDT 2016

Column(s) Type Sort Constraint Name
serialid Primary key Asc PRIMARY

Close relationships  within of separation: