What Comic Book Cataloging software do you use? Do you call it a Title or a Series
Feb 042010

Database Layout

Database Add comments

F0r those of you who are interested… here is the database layout. Its kind of hard to read without the table boarders, but I couldn’t convince WordPress to let me override the style on the table. I’ll post it in separate file in another day or so.

INDB_Source (unique on name; unique on base_url)
indb_src_id int non null, PK
name text non null name of the internet database source
base_url text non null base url to used when creating absolute urls
Publisher (unique on name)
pub_id int non null, PK
parent_pub_id int populated for imprints and brands only, null for publishers
type text 1 non null record type (default of P)

P = Publisher, B = Brand, I = Imprint
name text publisher name
desc text if not a publisher a description of the brand or imprint
compay_prefix text the first 6 to 9 digits of the UPC code identifying the publisher

Pub_Reference (unique pub_id, indb_src_id)
pub_ref_id int non null, PK
pub_id int non null, FK FK to publisher table
indb_src_id int non null, FK FK to the internet database source table
ref_id int non null publisher id on the internet database web site
notes text
Series (unique on pub_id, name, start_date)
ser_id int non null, PK
pub_id int non null, FK FK to publisher table
type text 1 non null series type (default of C): C = continuing, E = ended (previous continuing), L = limited, O = one-shot
country text 2 non null 2 character ISO country code
name text non null series name
start_date date non null date series was first published
end_date date date series was last published or null (To Present) if continuing
frequency text how often a series is published (see appendix A)
issue_count int the number of issues for a limited series
continuity_info text any related information to what series continued into or from this series
item_reference text the last 3 to 6 digits of the UPC code identifying the series
Ser_Ref_Hdr (unique on ser_id, indb_src_id)
srh_id int non null, PK
ser_id int non null, FK FK to series table
indb_src_id int non null, FK FK to the internet database source table
notes text
Ser_Ref_Dtl (unique srh_id, indb_src_id, seq)
srd_id int non null, PK
srh_id int non null, FK FK to ser_ref_hdr table
seq int non null orders records sequence
indb_src_id int non null, FK FK to the internet database source table
ref_id int non null series id on the internet database web site
Issue (unique by ser_id, type, number)
iss_id int non null, PK
ser_id int non null, FK FK to series table
type text 1 non null issue type (default of R):  R = Regular, A = Annual, S = Special, H = Holiday
number text non null issue number
pub_date date non null date the issue was published
Variant (unique by var_number, printing)
var_id int non null, PK
iss_id int non null, FK FK to issue table
var_type text 1 non null variant type (default of N):  N = Standad (not a variant), A = Alternate Cover, S = Sketch, P = Printing, F = Foil…
var_number text 1 1 character string used to uniquely identify the variant within the issue number (null if not a variant)
printing int the printing of the issue (null if the issues is considered the first printing)
description text the description of the variant
Issue_Ref (unique ser_id, indb_src_id)
iss_ref_id int non null, PK
var_id int non null, FK FK to ser_ref_hdr table
indb_src_id int non null, FK FK to the internet database source table
ref_id int non null specific issue/variant id on the internet database web site
Posted by Greg at 10:44 pm

Leave a Reply

(required)

(required)