SQL Statements

Refer to these tables and columns when creating SQL statements:

Table name

Columns in table

auth

auth#

tag

auth_control

auth#

create_date

create_time

create_user

change_date

change_time

change_user

status

status_change_date

status_change_time

status_change_user

staff_only_author

staff_only_subject

staff_only_series

bib

bib#

tag

bib_control

bib#

create_date

create_time

create_user

change_date

change_time

change_user

status

status_change_date

status_change_time

status_change_user

staff_only

item

bib#

location

collection

call

itype

item_status

source

price

creation_date

last_update_date

last_status_update_date

 


© 1998-2017 Sirsi Corporation