Index of database - obib

biblio
biblio_copy
biblio_copy_fields
biblio_copy_fields_dm
biblio_field
biblio_hold
biblio_status_dm
biblio_status_hist
biblio_stock
biblio_subfield
booking
booking_member
calendar
calendar_dm
cart
collection_circ
collection_dist
collection_dm
cutter
images
lookup_hosts
lookup_settings
material_fields
material_type_dm
mbr_classify_dm
member
member_account
member_fields
member_fields_dm
php_sess
report_displays
session
settings
site
staff
state_dm
theme
transaction_type_dm
transentries
transkeys
translinksectionlocale
translocales
transsections
usmarc_block_dm
usmarc_indicator_dm
usmarc_subfield_dm
usmarc_tag_dm
validation_dm
view_fields

Table : biblio

Structure of biblio
Name	Type	Description
bibid	int(11)	PRIMARY KEY
create_dt	datetime	NOT NULL DEFAULT '0000-00-00 00:00:00'
last_change_dt	datetime	NOT NULL DEFAULT '0000-00-00 00:00:00'
last_change_userid	int(11)	NOT NULL DEFAULT '0'
material_cd	smallint(6)	NOT NULL DEFAULT '0'
collection_cd	smallint(6)	NOT NULL DEFAULT '0'
opac_flg	char(1)	NOT NULL

Indexes of biblio
Name	Column	Description
PRIMARY	bibid	BTREE

Index

Table : biblio_copy

Structure of biblio_copy
Name	Type	Description
bibid	int(11)	NOT NULL DEFAULT '0'
copyid	int(11)	PRIMARY KEY
create_dt	datetime	NOT NULL DEFAULT '0000-00-00 00:00:00'
last_change_dt	datetime	NOT NULL DEFAULT '0000-00-00 00:00:00'
last_change_userid	int(11)	NOT NULL DEFAULT '0'
barcode_nmbr	varchar(20)	NOT NULL
copy_desc	varchar(160)
vendor	varchar(100)
fund	varchar(100)
price	varchar(10)
expiration	varchar(100)
histid	int(11)	UNIQUE
siteid	tinyint(3)	NOT NULL DEFAULT '1'

Indexes of biblio_copy
Name	Column	Description
PRIMARY	copyid	BTREE
histid_idx	histid	BTREE
bibid_idx	bibid	BTREE
barcode_index	barcode_nmbr	BTREE

Index

Table : biblio_copy_fields

Structure of biblio_copy_fields
Name	Type	Description
copyid	int(11)	PRIMARY KEY
bibid	int(11)	PRIMARY KEY
code	varchar(16)	PRIMARY KEY
data	text	NOT NULL

Indexes of biblio_copy_fields
Name	Column	Description
PRIMARY	copyid	BTREE
	bibid	BTREE
	code	BTREE
code_index	code	BTREE

Index

Table : biblio_copy_fields_dm

Structure of biblio_copy_fields_dm
Name	Type	Description
code	varchar(16)	PRIMARY KEY
description	varchar(32)	NOT NULL
default_flg	char(1)	NOT NULL

Indexes of biblio_copy_fields_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : biblio_field

Structure of biblio_field
Name	Type	Description
bibid	int(11)	NOT NULL
fieldid	int(11)	PRIMARY KEY
seq	int(11)	NOT NULL
tag	char(3)	NOT NULL
ind1_cd	char(1)
ind2_cd	char(1)
field_data	text
display	text

Indexes of biblio_field
Name	Column	Description
PRIMARY	fieldid	BTREE
bibid_idx	bibid	BTREE
tag_idx	tag	BTREE

Index

Table : biblio_hold

Structure of biblio_hold
Name	Type	Description
bibid	int(11)	NOT NULL
copyid	int(11)	NOT NULL
holdid	int(11)	PRIMARY KEY
hold_begin_dt	datetime	NOT NULL
mbrid	int(11)	NOT NULL

Indexes of biblio_hold
Name	Column	Description
PRIMARY	holdid	BTREE
mbr_index	mbrid	BTREE
bibid_index	bibid	BTREE
copyid_index	copyid	BTREE

Index

Table : biblio_status_dm

Structure of biblio_status_dm
Name	Type	Description
code	char(3)	PRIMARY KEY
description	varchar(40)	NOT NULL
default_flg	char(1)	NOT NULL

Indexes of biblio_status_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : biblio_status_hist

Structure of biblio_status_hist
Name	Type	Description
histid	bigint(20)	PRIMARY KEY
bibid	int(11)	NOT NULL
copyid	int(11)	NOT NULL
status_cd	char(3)	NOT NULL
status_begin_dt	datetime	NOT NULL

Indexes of biblio_status_hist
Name	Column	Description
PRIMARY	histid	BTREE
copy_index	bibid	BTREE
	copyid	BTREE

Index

Table : biblio_stock

Structure of biblio_stock
Name	Type	Description
bibid	int(11)	PRIMARY KEY
count	int(11)	NOT NULL
vendor	varchar(100)
fund	varchar(100)
price	varchar(10)

Indexes of biblio_stock
Name	Column	Description
PRIMARY	bibid	BTREE

Index

Table : biblio_subfield

Structure of biblio_subfield
Name	Type	Description
bibid	int(11)	NOT NULL
fieldid	int(11)	NOT NULL
subfieldid	int(11)	PRIMARY KEY
seq	int(11)	NOT NULL
subfield_cd	char(1)	NOT NULL
subfield_data	text	NOT NULL

Indexes of biblio_subfield
Name	Column	Description
PRIMARY	subfieldid	BTREE
bibid_idx	bibid	BTREE
fieldid_idx	fieldid	BTREE
subfield_cd_idx	subfield_cd	BTREE

Index

Table : booking

Structure of booking
Name	Type	Description
bookingid	bigint(20)	PRIMARY KEY
bibid	int(11)	NOT NULL
book_dt	date	NOT NULL
due_dt	date	NOT NULL
out_histid	bigint(20)
out_dt	datetime
ret_histid	bigint(20)
ret_dt	datetime
create_dt	datetime	NOT NULL
last_change_dt	datetime	NOT NULL
last_change_userid	int(11)	NOT NULL

Indexes of booking
Name	Column	Description
PRIMARY	bookingid	BTREE
bibid_idx	bibid	BTREE
due_dt_idx	due_dt	BTREE
book_dt_idx	book_dt	BTREE
out_histid_idx	out_histid	BTREE
out_dt_idx	out_dt	BTREE
ret_histid_idx	ret_histid	BTREE
ret_dt_idx	ret_dt	BTREE

Index

Table : booking_member

Structure of booking_member
F-Key	Name	Type	Description
	bookingid	bigint(20)	PRIMARY KEY
	mbrid	int(11)	PRIMARY KEY

Indexes of booking_member
Name	Column	Description
PRIMARY	bookingid	BTREE
	mbrid	BTREE
mbrid_idx	mbrid	BTREE

Index

Table : calendar

Structure of calendar
Name	Type	Description
calendar	int(11)	PRIMARY KEY
date	date	PRIMARY KEY
open	enum('Yes','No','Unset')	NOT NULL

Indexes of calendar
Name	Column	Description
PRIMARY	calendar	BTREE
	date	BTREE

Index

Table : calendar_dm

Structure of calendar_dm
Name	Type	Description
code	int(11)	PRIMARY KEY
description	char(32)	NOT NULL
default_flg	char(1)	NOT NULL

Indexes of calendar_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : cart

Structure of cart
Name	Type	Description
sess_id	text	PRIMARY KEY
name	char(16)	PRIMARY KEY
id	int(11)	PRIMARY KEY

Indexes of cart
Name	Column	Description
PRIMARY	sess_id	BTREE
	name	BTREE
	id	BTREE

Index

Table : collection_circ

Structure of collection_circ
Name	Type	Description
code	smallint(6)	PRIMARY KEY
days_due_back	tinyint(3) unsigned	NOT NULL
daily_late_fee	decimal(4,2)	NOT NULL

Indexes of collection_circ
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : collection_dist

Structure of collection_dist
F-Key	Name	Type	Description
	code	smallint(6)	PRIMARY KEY
	restock_threshold	int(10) unsigned	NOT NULL

Indexes of collection_dist
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : collection_dm

Structure of collection_dm
Name	Type	Description
code	smallint(6)	PRIMARY KEY
description	varchar(40)	NOT NULL
default_flg	char(1)	NOT NULL
type	enum('Circulated','Distributed')	NOT NULL DEFAULT 'Circulated'

Indexes of collection_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : cutter

Structure of cutter
F-Key	Name	Type	Description
	theName	varchar(32)	PRIMARY KEY
	theNmbr	mediumint(9)	NOT NULL DEFAULT '0'

Indexes of cutter
Name	Column	Description
PRIMARY	theName	BTREE

Index

Table : images

Structure of images
Name	Type	Description
bibid	int(11)	PRIMARY KEY
imgurl	text	PRIMARY KEY
url	text	NOT NULL
position	int(11)	NOT NULL DEFAULT '0'
caption	text	NOT NULL
type	enum('Thumb','Link')	NOT NULL

Indexes of images
Name	Column	Description
PRIMARY	bibid	BTREE
	imgurl	BTREE

Index

Table : lookup_hosts

Structure of lookup_hosts
Name	Type	Description
id	int(10) unsigned	PRIMARY KEY
seq	tinyint(4)	NOT NULL
active	enum('y','n')	NOT NULL DEFAULT 'n'
host	varchar(50)	NOT NULL
port	int(11) unsigned	NOT NULL DEFAULT '210'
name	varchar(50)	NOT NULL
db	varchar(20)	NOT NULL
service	enum('Z3950','SRU','SRW')	NOT NULL DEFAULT 'Z3950'
syntax	varchar(20)	NOT NULL
user	varchar(20)
pw	varchar(20)

Indexes of lookup_hosts
Name	Column	Description
PRIMARY	id	BTREE

Index

Table : lookup_settings

Structure of lookup_settings
Name	Type	Description
id	int(10) unsigned	PRIMARY KEY
protocol	enum('YAZ','SRU')	NOT NULL DEFAULT 'YAZ'
maxHits	tinyint(4)	NOT NULL DEFAULT '25'
timeout	int(10) unsigned	NOT NULL DEFAULT '20'
keepDashes	enum('y','n')	NOT NULL DEFAULT 'n'
callNmbrType	enum('LoC','Dew','UDC','local')	NOT NULL DEFAULT 'Dew'
autoDewey	enum('y','n')	NOT NULL DEFAULT 'y'
defaultDewey	varchar(10)	NOT NULL DEFAULT '813.52'
autoCutter	enum('y','n')	NOT NULL DEFAULT 'y'
cutterType	enum('LoC','CS3')	NOT NULL DEFAULT 'CS3'
cutterWord	tinyint(4)	NOT NULL DEFAULT '1'
noiseWords	varchar(255)	NOT NULL DEFAULT 'a an and for of the this those'
autoCollect	enum('y','n')	NOT NULL DEFAULT 'y'
fictionName	varchar(10)	NOT NULL DEFAULT 'Fiction'
fictionCode	tinyint(4)	NOT NULL DEFAULT '1'
fictionLoc	varchar(255)	NOT NULL DEFAULT 'PQ PR PS PT PU PV PW PX PY PZ'
fictionDew	varchar(255)	NOT NULL DEFAULT '813 823'

Indexes of lookup_settings
Name	Column	Description
PRIMARY	id	BTREE

Index

Table : material_fields

Structure of material_fields
Name	Type	Description
material_field_id	int(4)	PRIMARY KEY
material_cd	int(11)
tag	char(3)	NOT NULL
subfield_cd	varchar(10)
position	tinyint(4)	NOT NULL
label	varchar(128)
form_type	enum('text','textarea','date','datetime','month','number','url','tel','email','search','color','password','range')	NOT NULL DEFAULT 'text'
validation_cd	varchar(10)
required	tinyint(1)	NOT NULL
repeatable	tinyint(1)
search_results	varchar(255)

Indexes of material_fields
Name	Column	Description
PRIMARY	material_field_id	BTREE

Index

Table : material_type_dm

Structure of material_type_dm
Name	Type	Description
code	smallint(6)	PRIMARY KEY
description	varchar(40)	NOT NULL
default_flg	char(1)	NOT NULL
adult_checkout_limit	tinyint(3) unsigned	NOT NULL
juvenile_checkout_limit	tinyint(3) unsigned	NOT NULL
image_file	varchar(128)
srch_disp_lines	tinyint(3) unsigned	NOT NULL DEFAULT '4'

Indexes of material_type_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : mbr_classify_dm

Structure of mbr_classify_dm
Name	Type	Description
code	smallint(6)	PRIMARY KEY
description	varchar(40)	NOT NULL
default_flg	char(1)	NOT NULL
max_fines	decimal(4,2)	NOT NULL

Indexes of mbr_classify_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : member

Structure of member
Name	Type	Description
mbrid	int(11)	PRIMARY KEY
barcode_nmbr	varchar(20)	NOT NULL
create_dt	datetime	NOT NULL
last_change_dt	timestamp	NOT NULL DEFAULT '0000-00-00 00:00:00'
last_change_userid	int(11)	NOT NULL DEFAULT '0'
last_name	varchar(50)	NOT NULL
first_name	varchar(50)	NOT NULL
address1	varchar(32)
address2	varchar(32)
city	varchar(32)
state	varchar(32)
zip	varchar(10)
zip_ext	varchar(10)
home_phone	varchar(15)
work_phone	varchar(15)
email	varchar(128)
classification	smallint(6)	NOT NULL
siteid	tinyint(3) unsigned	NOT NULL
school_grade	tinyint(3) unsigned	NOT NULL
school_teacher	varchar(32)	NOT NULL

Indexes of member
Name	Column	Description
PRIMARY	mbrid	BTREE

Index

Table : member_account

Structure of member_account
Name	Type	Description
mbrid	int(11)	PRIMARY KEY
transid	int(11)	PRIMARY KEY
create_dt	datetime	NOT NULL DEFAULT '0000-00-00 00:00:00'
create_userid	int(11)	NOT NULL DEFAULT '0'
transaction_type_cd	char(2)	NOT NULL
amount	decimal(8,2)	NOT NULL DEFAULT '0.00'
description	varchar(128)

Indexes of member_account
Name	Column	Description
PRIMARY	mbrid	BTREE
	transid	BTREE

Index

Table : member_fields

Structure of member_fields
Name	Type	Description
mbrid	int(11)	PRIMARY KEY
code	varchar(16)	PRIMARY KEY
data	text	NOT NULL

Indexes of member_fields
Name	Column	Description
PRIMARY	mbrid	BTREE
	code	BTREE
code_index	code	BTREE

Index

Table : member_fields_dm

Structure of member_fields_dm
Name	Type	Description
code	varchar(16)	PRIMARY KEY
description	char(32)	NOT NULL
default_flg	char(1)	NOT NULL

Indexes of member_fields_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : php_sess

Structure of php_sess
Name	Type	Description
id	varchar(128)	PRIMARY KEY
last_access_dt	datetime
data	mediumtext

Indexes of php_sess
Name	Column	Description
PRIMARY	id	BTREE

Index

Table : report_displays

Structure of report_displays
Name	Type	Description
page	varchar(32)	PRIMARY KEY
position	int(11)	PRIMARY KEY
report	text	NOT NULL
title	text	NOT NULL
max_rows	int(11)	NOT NULL
params	text	NOT NULL

Indexes of report_displays
Name	Column	Description
PRIMARY	page	BTREE
	position	BTREE

Index

Table : session

Structure of session
Name	Type	Description
userid	int(5)	NOT NULL
last_updated_dt	datetime	NOT NULL
token	int(5)	NOT NULL

Indexes of session
Name	Column	Description

Index

Table : settings

Structure of settings
Name	Type	Description
name	varchar(64)	PRIMARY KEY
position	int(11)
title	text
type	enum('text','int','bool','select')	NOT NULL DEFAULT 'text'
width	int(11)
type_data	text
validator	text
value	text
menu	enum('admin','tools','none')	NOT NULL DEFAULT 'admin'

Indexes of settings
Name	Column	Description
PRIMARY	name	BTREE

Index

Table : site

Structure of site
Name	Type	Description
siteid	int(11)	PRIMARY KEY
calendar	int(11)	NOT NULL
name	text	NOT NULL
code	varchar(10)
address1	varchar(128)
address2	varchar(128)
city	varchar(50)
state	char(2)
zip	varchar(15)
phone	varchar(15)
fax	varchar(15)
email	varchar(128)
delivery_note	text	NOT NULL

Indexes of site
Name	Column	Description
PRIMARY	siteid	BTREE

Index

Table : staff

Structure of staff
Name	Type	Description
userid	int(11)	PRIMARY KEY
create_dt	datetime	NOT NULL
last_change_dt	datetime	NOT NULL
last_change_userid	int(11)	NOT NULL
username	varchar(20)	NOT NULL
pwd	char(32)	NOT NULL
last_name	varchar(30)	NOT NULL
first_name	varchar(30)
suspended_flg	char(1)	NOT NULL
admin_flg	char(1)	NOT NULL
circ_flg	char(1)	NOT NULL
circ_mbr_flg	char(1)	NOT NULL
catalog_flg	char(1)	NOT NULL
reports_flg	char(1)	NOT NULL
tools_flg	char(1)	NOT NULL

Indexes of staff
Name	Column	Description
PRIMARY	userid	BTREE

Index

Table : state_dm

Structure of state_dm
Name	Type	Description
code	varchar(20)	PRIMARY KEY
description	varchar(32)	NOT NULL
default_flg	char(1)	NOT NULL

Indexes of state_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : theme

Structure of theme
Name	Type	Description
themeid	smallint(6)	PRIMARY KEY
theme_name	varchar(40)	NOT NULL
title_bg	varchar(20)	NOT NULL
title_font_face	varchar(128)	NOT NULL
title_font_size	tinyint(4)	NOT NULL
title_font_bold	char(1)	NOT NULL
title_font_color	varchar(20)	NOT NULL
title_align	varchar(30)	NOT NULL
primary_bg	varchar(20)	NOT NULL
primary_font_face	varchar(128)	NOT NULL
primary_font_size	tinyint(4)	NOT NULL
primary_font_color	varchar(20)	NOT NULL
primary_link_color	varchar(20)	NOT NULL
primary_error_color	varchar(20)	NOT NULL
alt1_bg	varchar(20)	NOT NULL
alt1_font_face	varchar(128)	NOT NULL
alt1_font_size	tinyint(4)	NOT NULL
alt1_font_color	varchar(20)	NOT NULL
alt1_link_color	varchar(20)	NOT NULL
alt2_bg	varchar(20)	NOT NULL
alt2_font_face	varchar(128)	NOT NULL
alt2_font_size	tinyint(4)	NOT NULL
alt2_font_color	varchar(20)	NOT NULL
alt2_link_color	varchar(20)	NOT NULL
alt2_font_bold	char(1)	NOT NULL
border_color	varchar(20)	NOT NULL
border_width	tinyint(4)	NOT NULL
table_padding	tinyint(4)	NOT NULL

Indexes of theme
Name	Column	Description
PRIMARY	themeid	BTREE

Index

Table : transaction_type_dm

Structure of transaction_type_dm
Name	Type	Description
code	char(2)	PRIMARY KEY
description	varchar(40)	NOT NULL
default_flg	char(1)	NOT NULL

Indexes of transaction_type_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : transentries

Structure of transentries
Name	Type	Description
transEntryID	int(11)	PRIMARY KEY
transLocaleCode	varchar(10)	NOT NULL
transKeyText	varchar(100)	NOT NULL
transEntryText	varchar(255)	NOT NULL
transSectionName	varchar(50)	NOT NULL

Indexes of transentries
Name	Column	Description
PRIMARY	transEntryID	BTREE
transLocaleCode	transLocaleCode	BTREE
	transKeyText	BTREE
	transSectionName	BTREE

Index

Table : transkeys

Structure of transkeys
Name	Type	Description
transKeyID	int(11)	PRIMARY KEY
transKeySectionName	varchar(50)	NOT NULL
transKeyText	varchar(100)	NOT NULL

Indexes of transkeys
Name	Column	Description
PRIMARY	transKeyID	BTREE

Index

Table : translinksectionlocale

Structure of translinksectionlocale
Name	Type	Description
transLinkID	int(11)	PRIMARY KEY
transSectionName	varchar(50)
transLocaleCode	varchar(10)

Indexes of translinksectionlocale
Name	Column	Description
PRIMARY	transLinkID	BTREE
transSectionName	transSectionName	BTREE
	transLocaleCode	BTREE

Index

Table : translocales

Structure of translocales
Name	Type	Description
transLocaleID	int(11)	PRIMARY KEY
transLocaleCode	varchar(10)	NOT NULL
transLocaleText	varchar(50)	NOT NULL
transLocaleEnglishText	varchar(50)	NOT NULL

Indexes of translocales
Name	Column	Description
PRIMARY	transLocaleID	BTREE

Index

Table : transsections

Structure of transsections
Name	Type	Description
transSectionID	int(11)	PRIMARY KEY
transSectionProjID	int(11)	NOT NULL DEFAULT '1'
transSectionName	varchar(50)	NOT NULL
transSectionIsProtected	tinyint(1)	NOT NULL DEFAULT '0'

Indexes of transsections
Name	Column	Description
PRIMARY	transSectionID	BTREE

Index

Table : usmarc_block_dm

Structure of usmarc_block_dm
F-Key	Name	Type	Description
	block_nmbr	tinyint(4)	PRIMARY KEY
	description	varchar(80)	NOT NULL

Indexes of usmarc_block_dm
Name	Column	Description
PRIMARY	block_nmbr	BTREE

Index

Table : usmarc_indicator_dm

Structure of usmarc_indicator_dm
Name	Type	Description
tag	smallint(6)	PRIMARY KEY
indicator_nmbr	tinyint(4)	PRIMARY KEY
indicator_cd	char(1)	PRIMARY KEY
description	varchar(80)	NOT NULL

Indexes of usmarc_indicator_dm
Name	Column	Description
PRIMARY	tag	BTREE
	indicator_nmbr	BTREE
	indicator_cd	BTREE

Index

Table : usmarc_subfield_dm

Structure of usmarc_subfield_dm
Name	Type	Description
tag	smallint(6)	PRIMARY KEY
subfield_cd	char(1)	PRIMARY KEY
description	varchar(80)	NOT NULL
repeatable_flg	char(1)	NOT NULL

Indexes of usmarc_subfield_dm
Name	Column	Description
PRIMARY	tag	BTREE
	subfield_cd	BTREE

Index

Table : usmarc_tag_dm

Structure of usmarc_tag_dm
Name	Type	Description
block_nmbr	tinyint(4)	PRIMARY KEY
tag	smallint(6)	PRIMARY KEY
description	varchar(80)	NOT NULL
ind1_description	varchar(80)	NOT NULL
ind2_description	varchar(80)	NOT NULL
repeatable_flg	char(1)	NOT NULL

Indexes of usmarc_tag_dm
Name	Column	Description
PRIMARY	block_nmbr	BTREE
	tag	BTREE

Index

Table : validation_dm

for HTML5 input field validations

Structure of validation_dm
Name	Type	Description
code	char(8)	PRIMARY KEY
description	varchar(32)	NOT NULL
pattern	varchar(1024)	NOT NULL

Indexes of validation_dm
Name	Column	Description
PRIMARY	code	BTREE

Index

Table : view_fields

Structure of view_fields
Name	Type	Description
vfid	int(11)	PRIMARY KEY
page	varchar(32)	NOT NULL
position	tinyint(4)	NOT NULL
tag	char(3)	NOT NULL
tag_id	tinyint(4)
subfield	char(1)
subfield_id	tinyint(4)
required	char(1)	NOT NULL DEFAULT 'N'
auto_repeat	enum('No','Tag','Subfield')	NOT NULL DEFAULT 'No'
label	varchar(128)
form_type	enum('text','textarea')	NOT NULL DEFAULT 'text'

Indexes of view_fields
Name	Column	Description
PRIMARY	vfid	BTREE

Index

Generated by mysql-autodoc

W3C HTML 4.01 Strict