auction6 Database

backtags
brand
buyer
buyerapp
buyerchargesummary
buyercommission
buyerinvoice
buyerinvoicesummary
charge
charge_adjustment
charge_break
charge_code_rel
checkfactory
checkreg
codes
comm_code_rel
commission
commission_break
customer
default_loadouts
default_printers
depositreg
displays
disprows
emailaddrbook
emailhistory
history
market_report
presort
prorate
proratedata
rfid_tag
sales
seller
sellerchargesummary
sellercheckin
sellerinvoice
sellerinvoicesummary
setup
trans
trucking_record
vettickets
videotranlink
zip_code

backtags

Field	Type	Null	Key	Default	Extra
ckin_date	date	NO	PRI	0000-00-00
trans_id	int(6) unsigned	NO		0
seller_id	varchar(10)	NO
tag_num	varchar(6)	NO
old_num	varchar(6)	NO
new_num	varchar(6)	NO
type	int(2) unsigned zerofill	NO		00
color	int(2) unsigned zerofill	NO		00
flaw	int(2) unsigned zerofill	NO		00
b_tag	varchar(14)	NO
comment	varchar(19)	NO
breed	varchar(30)	YES		HO
sex	char(1)	YES		F
age	int(5)	YES		0
vaccination	varchar(20)	YES
brucellosis	varchar(10)	YES
months_preg	varchar(20)	YES
test_date	date	YES		0000-00-00
old_tag	varchar(10)	YES
id	int(11)	NO	PRI	NULL	auto_increment
deleted	tinyint(1)	YES		0
rfid	varchar(40)	YES
tbinjdate	date	YES		0000-00-00

brand

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
image_data	varchar(1024)	YES
position	varchar(10)	YES
trans_id	int(11)	YES		0
head	int(11)	YES		0
tag	varchar(10)	YES
date	date	YES		0000-00-00

buyer

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
customer_id	int(11)	YES		NULL
date	date	YES		NULL
number	varchar(64)	YES		NULL
name	varchar(255)	YES
address1	varchar(255)	YES
address2	varchar(255)	YES
city	varchar(255)	YES
state	varchar(4)	YES
zip	varchar(20)	YES
company	varchar(255)	YES
comment	varchar(255)	YES

buyerapp

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
buyerNum	varchar(30)	YES		NULL
buyerPW	varchar(30)	YES		NULL

buyerchargesummary

Field	Type	Null	Default
charge_id	int(11)	YES	NULL
description	varchar(255)	YES	NULL
total	decimal(10,2)	YES	NULL
invoice_id	int(11)	YES	NULL

buyercommission

Field	Type	Null	Default
customer_id	varchar(255)	YES	NULL
amount	decimal(10,2)	YES	NULL
mode	tinyint(4)	YES	NULL
date	date	YES	NULL
checkno	int(11)	YES	0

buyerinvoice

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
status	tinyint(4)	YES		NULL
customer_id	varchar(64)	YES		NULL
date	date	YES		0000-00-00

buyerinvoicesummary

Field	Type	Null	Key	Default
invoice_id	int(11)	NO	PRI	0
head	int(11)	YES		NULL
total_bought	decimal(10,2)	YES		NULL
customer_id	varchar(10)	YES		NULL
date	date	YES		NULL

charge

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
description	varchar(255)	YES		NULL
expression	varchar(255)	YES		NULL
charge_nosale	tinyint(4)	YES		NULL
charge_resale	tinyint(4)	YES		NULL
double_pairs	tinyint(4)	YES		NULL
customer_type	tinyint(4)	YES		NULL
needs_multiplier	tinyint(1)	YES		0
commission_charge	tinyint(1)	YES		NULL
beef_council	tinyint(1)	YES		0
scope	tinyint(4)	YES		0
break_type	tinyint(4)	YES		0

charge_adjustment

Field	Type	Null	Default
charge_id	int(11)	YES	NULL
invoice_id	int(11)	YES	NULL
multiplier	decimal(10,2)	YES	NULL
adjustment	decimal(10,2)	YES	NULL

charge_break

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
charge_id	int(11)	YES		0
amount	decimal(10,2)	YES		0.00
expression	varchar(255)	YES

charge_code_rel

Field	Type	Null	Default
sex	tinyint(4)	YES	NULL
charge_id	int(11)	YES	NULL
flaw	tinyint(4)	YES	NULL
color_group	tinyint(4)	YES	0

checkfactory

Field	Type	Null	Key	Default
invoice_id	int(11)	NO	PRI	0
mode	tinyint(4)	YES		NULL
share_charges	tinyint(1)	YES		NULL

checkreg

Field	Type	Null	Key	Default	Extra
number	int(11)	NO		0
amount	decimal(10,2)	YES		NULL
status	tinyint(4)	YES		NULL
comment	varchar(255)	YES		NULL
date	date	YES		NULL
invoice_id	int(11)	YES		NULL
payee	varchar(255)	YES		NULL
id	int(11)	NO	PRI	NULL	auto_increment
type	tinyint(4)	YES		0

codes

Field	Type	Null	Default
code_type	smallint(2) unsigned zerofill	NO	00
code	smallint(2) unsigned zerofill	NO	00
pair	smallint(1)	NO	0
descrip	varchar(30)	NO
color_group	tinyint(1)	YES	4

comm_code_rel

Field	Type	Null	Default
commission_id	int(11)	YES	NULL
sex	tinyint(4)	YES	NULL
flaw	tinyint(4)	YES	NULL
color_group	tinyint(4)	YES	0

commission

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
commission_mode	tinyint(4)	YES		NULL
break_mode	tinyint(4)	YES		NULL
min	decimal(10,2)	YES		0.00
max	decimal(10,2)	YES		99999999.99
no_sale_charge	decimal(10,2)	YES		0.00
name	varchar(255)	YES

commission_break

Field	Type	Null	Key	Default	Extra
commission_id	int(11)	YES		NULL
expression	varchar(255)	YES		NULL
break_value	decimal(10,2)	YES		NULL
id	int(11)	NO	PRI	NULL	auto_increment
min	decimal(10,2)	YES		0.00
max	decimal(10,2)	YES		99999999.99

customer

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(255)	YES		NULL
address1	varchar(255)	YES		NULL
address2	varchar(255)	YES		NULL
city	varchar(255)	YES		NULL
state	char(2)	YES		NULL
zip	varchar(10)	YES		NULL
phone	varchar(30)	YES		NULL
ssn	varchar(12)	YES		NULL
credit_card	varchar(100)	YES		NULL
county	varchar(100)	YES		NULL
comment	varchar(255)	YES		NULL
mad_cow	tinyint(1)	YES		NULL
mailing_list	tinyint(1)	YES		0
beef_council	tinyint(1)	YES		0
company	varchar(255)	YES		NULL
altered	tinyint(1)	YES		1
type	tinyint(1)	YES		0
perm_number	varchar(20)	YES
docket	varchar(50)	YES
relation	int(1)	YES		0

default_loadouts

Field	Type	Null	Key	Default	Extra
station	varchar(100)	YES		NULL
printer	varchar(100)	YES		NULL

default_printers

Field	Type	Null	Key	Default	Extra
station	varchar(100)	YES		NULL
printer	varchar(100)	YES		NULL

depositreg

Field	Type	Null	Key	Default	Extra
number	int(11)	NO	PRI	NULL	auto_increment
amount	decimal(10,2)	YES		NULL
status	tinyint(4)	YES		NULL
date	date	YES		NULL
comment	varchar(255)	YES		NULL

displays

Field	Type	Null	Key	Default
num	int(1) unsigned	NO	PRI	0
type	int(1) unsigned	NO		0
name	varchar(128)	NO
port	varchar(128)	NO
rows	int(1) unsigned	NO		0
which	int(1) unsigned	NO		0
base	int(2) unsigned	NO		0

disprows

Field	Type	Null	Key
num	int(1) unsigned	NO	PRI
row	int(1) unsigned	NO	PRI
item	int(1) unsigned	NO
len	int(1) unsigned	NO
rev	int(1) unsigned	NO

emailaddrbook

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(64)	YES		NULL
email	varchar(320)	YES		NULL
nickname	varchar(30)	YES		NULL
notes	text	YES		NULL

emailhistory

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
filename	varchar(256)	YES		NULL
recipient	varchar(64)	YES		NULL
comment	varchar(80)	YES		NULL
sentdate	date	YES		0000-00-00
saledate	varchar(11)	YES		NULL

history

Field	Type	Null	Default
date	date	YES	0000-00-00
transaction_id	int(11)	YES	0
seller_number	varchar(50)	YES
seller_name	varchar(255)	YES
buyer_number	varchar(50)	YES
buyer_name	varchar(255)	YES
head	int(11)	YES	0
weight	int(11)	YES	0
description	varchar(50)	YES
price	decimal(10,2)	YES	0.00
tags	varchar(70)	YES
mode	smallint(1) unsigned	YES	0
weighmaster	varchar(25)	YES

market_report

Field	Type	Null	Key	Default	Extra
trans_id	int(11)	YES		0
date	date	YES		0000-00-00

presort

Field	Type	Null	Key	Default	Extra
presort_id	int(11)	NO	PRI	NULL	auto_increment
date	date	NO		0000-00-00
number	varchar(10)	NO
consignor	varchar(10)	NO
head	int(11)	NO		0
weight	int(11)	NO		0
tag	varchar(6)	NO
description	varchar(10)	NO

prorate

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
payee	varchar(255)	YES		NULL
invoice_id	int(11)	YES		NULL

proratedata

Field	Type	Null	Default
prorate_id	int(11)	YES	NULL
number	int(11)	YES	NULL
amount	decimal(10,2)	YES	NULL

rfid_tag

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
tag_number	varchar(255)	YES		NULL
seller_number	varchar(10)	YES		NULL
buyer_number	varchar(10)	YES		NULL
date	date	YES		NULL
sale_time	timestamp	NO		current_timestamp()	on update current_timestamp()

sales

Field	Type	Null	Key	Default
start	date	NO	PRI	0000-00-00
date	date	YES		0000-00-00
end	date	YES		0000-00-00
open	tinyint(1)	YES		1
sel	tinyint(1)	YES		0

seller

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
head	int(11)	YES		NULL
customer_id	int(11)	YES		NULL
date	date	YES		NULL
number	varchar(64)	YES		NULL
name	varchar(255)	YES
address1	varchar(255)	YES
address2	varchar(255)	YES
city	varchar(255)	YES
state	varchar(4)	YES
zip	varchar(20)	YES
mortgage	varchar(255)	YES
comment	varchar(255)	YES
beef_council	tinyint(1)	YES		0
mad_cow	tinyint(1)	YES		1

sellerchargesummary

Field	Type	Null	Default
charge_id	int(11)	YES	NULL
description	varchar(255)	YES	NULL
total	decimal(10,2)	YES	NULL
invoice_id	int(11)	YES	NULL

sellercheckin

Field	Type	Null	Key	Default	Extra
id	bigint(20)	NO	PRI	NULL	auto_increment
date	date	NO	MUL	0000-00-00
sellerID	varchar(10)	NO		0000000000
descrip	varchar(127)	YES		NULL
color	int(2) unsigned zerofill	NO		00
sex	int(2) unsigned zerofill	NO		00
flaw	int(2) unsigned zerofill	NO		00
head	int(11)	NO		0
missing	tinyint(1)	YES		0

sellerinvoice

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
status	tinyint(4)	YES		NULL
customer_id	varchar(64)	YES		NULL
date	date	YES		0000-00-00

sellerinvoicesummary

Field	Type	Null	Key	Default
invoice_id	int(11)	NO	PRI	0
head	int(11)	YES		NULL
total_sale	decimal(10,2)	YES		NULL
customer_id	varchar(10)	YES		NULL
date	date	YES		NULL

setup

Field	Type	Null	Key	Default	Extra
key_id	bigint(20)	NO	PRI	NULL	auto_increment
skey	varchar(127)	NO	MUL
svalue	varchar(255)	YES		NULL

trans

Field	Type	Null	Key	Default	Extra
trans_id	bigint(20)	NO	PRI	NULL	auto_increment
sellerID	varchar(10)	NO	MUL	0000000000
buyerID	varchar(10)	NO	MUL	0000000000
head	int(11)	NO		0
weight	int(11)	NO		0
descrip	varchar(127)	YES		NULL
type	int(2) unsigned zerofill	NO		00
color	int(2) unsigned zerofill	NO		00
flaw	int(2) unsigned zerofill	NO		00
price	decimal(10,2)	NO		0.00
mode	smallint(1) unsigned	NO		0
sellerpen	varchar(6)	NO		''
buyerpen	varchar(10)	YES		NULL
created	timestamp	NO		0000-00-00 00:00:00
updated	timestamp	NO		current_timestamp()	on update current_timestamp()
weighmaster	varchar(20)	NO		''
active	enum('f','t')	NO		t
presortnumber	varchar(10)	NO		''
comment	varchar(40)	NO		''
amount	decimal(10,2)	NO		0.00
sinv_id	bigint(20)	NO		0
binv_id	bigint(20)	NO		0
manual	varchar(255)	YES		NULL
date	date	NO	PRI	0000-00-00
videostart	timestamp	NO		0000-00-00 00:00:00

trucking_record

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
customer_id	varchar(20)	YES		NULL
trucker_name	varchar(255)	YES		NULL
price	decimal(10,2)	YES		NULL
quantity	int(11)	YES		NULL
mode	tinyint(4)	YES		NULL
date	date	YES		NULL
customer_type	tinyint(1)	YES		0
checkno	int(11)	YES		0
truckerID	int(11)	NO		0

vettickets

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
trans_id	int(20)	YES		0
ticket_type	varchar(80)	YES		NULL
date	date	NO	PRI	0000-00-00

videotranlink

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
videonum	int(10)	YES		0
trans_id	int(20)	YES		0
seconds	int(10)	YES		0
date	date	NO	PRI	0000-00-00

zip_code

Field	Type	Null	Default
zip	varchar(11)	YES	NULL
state	char(2)	YES	NULL
city	varchar(255)	YES	NULL