Database Schema Report for FrontAccounting 2.2

Table of Contents

• Summary
• Tables
1. 0_areas
2. 0_attachments
3. 0_audit_trail
4. 0_bank_accounts
5. 0_bank_trans
6. 0_bom
7. 0_budget_trans
8. 0_chart_class
9. 0_chart_master
10. 0_chart_types
11. 0_check_account
12. 0_check_trans
13. 0_comments
14. 0_company
15. 0_credit_status
16. 0_currencies
17. 0_cust_allocations
18. 0_cust_branch
19. 0_debtor_trans
20. 0_debtor_trans_details
21. 0_debtors_master
22. 0_dimensions
23. 0_exchange_rates
24. 0_fiscal_year
25. 0_gl_trans
26. 0_grn_batch
27. 0_grn_items
28. 0_groups
29. 0_item_codes
30. 0_item_tax_type_exemptions
31. 0_item_tax_types
32. 0_item_units
33. 0_loc_stock
34. 0_locations
35. 0_movement_types
36. 0_payment_terms
37. 0_prices
38. 0_print_profiles
39. 0_printers
40. 0_purch_data
41. 0_purch_order_details
42. 0_purch_orders
43. 0_quick_entries
44. 0_quick_entry_lines
45. 0_recurrent_invoices
46. 0_refs
47. 0_sales_order_details
48. 0_sales_orders
49. 0_sales_pos
50. 0_sales_types
51. 0_salesman
52. 0_security_roles
53. 0_shippers
54. 0_sql_trail
55. 0_stock_category
56. 0_stock_master
57. 0_stock_moves
58. 0_supp_allocations
59. 0_supp_invoice_items
60. 0_supp_trans
61. 0_suppliers
62. 0_sys_types
63. 0_tag_associations
64. 0_tags
65. 0_tax_group_items
66. 0_tax_groups
67. 0_tax_types
68. 0_trans_tax_details
69. 0_useronline
70. 0_users
71. 0_voided
72. 0_wo_issue_items
73. 0_wo_issues
74. 0_wo_manufacture
75. 0_wo_requirements
76. 0_workcentres
77. 0_workorders
• Views
• Procedures
• Data Types

Property	Value
Report created	03-Nov-2009 10:48
DBMS and version	MySQL [ 5.0.51b-community-nt ]
Server	localhost via TCP/IP
Database name	unstable
User/Login	root
Driver and version	myodbc5.dll [ 05.01.0005 ]
DTM Schema Reporter version	Version 1.17.00, (C) 2003-2008 DTM soft.

Tables, 77 items

Table: '`0_areas`', 3 fields

Field Name	Type and Size	Default	Nullable	Description
area_code	integer	0	NULL
description	varchar(60)	''	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_areas`'

Primary Key Name	Field Name
P	a

Indexes for table '`0_areas`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	area_code
description	No	Yes	description

Table: '`0_attachments`', 9 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer unsigned	0	NULL
description	varchar(60)	''	NOT NULL
type_no	integer	0	NOT NULL
trans_no	integer	0	NOT NULL
unique_name	varchar(60)	''	NOT NULL
tran_date	date	'0000-00-00'	NOT NULL
filename	varchar(60)	''	NOT NULL
filesize	integer	0	NOT NULL
filetype	varchar(60)	''	NOT NULL

Primary key for table '`0_attachments`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_attachments`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
type_no	No	No	type_no, trans_no

Table: '`0_audit_trail`', 9 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
type	smallint unsigned	0	NOT NULL
trans_no	integer unsigned	0	NOT NULL
user	smallint unsigned	0	NOT NULL
stamp	timestamp		NULL
description	varchar(60)		NULL
fiscal_year	integer	0	NOT NULL
gl_date	date	'0000-00-00'	NOT NULL
gl_seq	integer unsigned		NULL

Primary key for table '`0_audit_trail`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_audit_trail`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
fiscal_year	No	No	fiscal_year, gl_seq

Table: '`0_bank_accounts`', 12 fields

Field Name	Type and Size	Default	Nullable	Description
account_code	varchar(11)	''	NOT NULL
account_type	smallint	0	NOT NULL
bank_account_name	varchar(60)	''	NOT NULL
bank_account_number	varchar(100)	''	NOT NULL
bank_name	varchar(60)	''	NOT NULL
bank_address	text		NULL
bank_curr_code	char(3)	''	NOT NULL
dflt_curr_act	tinyint	0	NOT NULL
id	smallint	0	NULL
last_reconciled_date	timestamp		NOT NULL
ending_reconcile_balance	double	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_bank_accounts`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_bank_accounts`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
bank_account_name	No	No	bank_account_name
bank_account_number	No	No	bank_account_number

Table: '`0_bank_trans`', 13 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
type	smallint		NULL
trans_no	integer		NULL
bank_act	varchar(11)		NULL
ref	varchar(40)		NULL
trans_date	date	'0000-00-00'	NOT NULL
bank_trans_type_id	integer unsigned		NULL
amount	double		NULL
dimension_id	integer	0	NOT NULL
dimension2_id	integer	0	NOT NULL
person_type_id	integer	0	NOT NULL
person_id	blob		NULL
reconciled	date		NULL

Primary key for table '`0_bank_trans`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_bank_trans`', 5 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
bank_act	No	No	bank_act, ref
type	No	No	type, trans_no

Table: '`0_bom`', 6 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
parent	char(20)	''	NOT NULL
component	char(20)	''	NOT NULL
workcentre_added	integer	0	NOT NULL
loc_code	char(5)	''	NOT NULL
quantity	double	1	NOT NULL

Primary key for table '`0_bom`'

Primary Key Name	Field Names
PRIMARY	parent, component, workcentre_added, loc_code

Indexes for table '`0_bom`', 11 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	parent
PRIMARY	No	Yes	component
PRIMARY	No	Yes	workcentre_added
PRIMARY	No	Yes	loc_code
component	No	No	component
id	No	No	id
loc_code	No	No	loc_code
parent	No	No	parent, loc_code
Parent_2	No	No	parent
workcentre_added	No	No	workcentre_added

Table: '`0_budget_trans`', 11 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
counter	integer	0	NULL
type	smallint	0	NOT NULL
type_no	bigint	1	NOT NULL
tran_date	date	'0000-00-00'	NOT NULL
account	varchar(11)	''	NOT NULL
memo_	text	''	NOT NULL
amount	double	0	NOT NULL
dimension_id	integer	0	NULL
dimension2_id	integer	0	NULL
person_type_id	integer		NULL
person_id	blob		NULL

Primary key for table '`0_budget_trans`'

Primary Key Name	Field Name
PRIMARY	counter

Indexes for table '`0_budget_trans`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	counter
Type_and_Number	No	No	type, type_no

Table: '`0_chart_class`', 4 fields

Field Name	Type and Size	Default	Nullable	Description
cid	integer	0	NOT NULL
class_name	varchar(60)	''	NOT NULL
ctype	tinyint	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_chart_class`'

Primary Key Name	Field Name
PRIMARY	cid

Indexes for table '`0_chart_class`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	cid

Table: '`0_chart_master`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
account_code	varchar(11)	''	NOT NULL
account_code2	varchar(11)	''	NULL
account_name	varchar(60)	''	NOT NULL
account_type	integer	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_chart_master`'

Primary Key Name	Field Name
PRIMARY	account_code

Indexes for table '`0_chart_master`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	account_code
account_code	No	No	account_code
account_name	No	No	account_name

Table: '`0_chart_types`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
name	varchar(60)	''	NOT NULL
class_id	tinyint	0	NOT NULL
parent	integer	-1	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_chart_types`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_chart_types`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
name	No	No	name

Table: '`0_check_account`', 3 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
account_id	integer	0	NULL
bank_ref	varchar(11)	''	NOT NULL
next_reference	varchar(100)	''	NOT NULL

Primary key for table '`0_check_account`'

Primary Key Name	Field Name
P	a

Indexes for table '`0_check_account`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	account_id
bank_ref	No	Yes	bank_ref

Table: '`0_check_trans`', 4 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
check_ref	varchar(100)	''	NOT NULL
bank_trans_id	integer	0	NOT NULL
cheque_bank_id	integer	0	NOT NULL

Primary key for table '`0_check_trans`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_check_trans`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
cheque_ref	No	Yes	check_ref, cheque_bank_id

Table: '`0_comments`', 4 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
type	integer	0	NOT NULL
id	integer	0	NOT NULL
date_	date	'0000-00-00'	NULL
memo_	text		NULL

Table: '`0_company`', 52 fields

Field Name	Type and Size	Default	Nullable	Description
coy_code	integer	1	NOT NULL
coy_name	varchar(60)	''	NOT NULL
gst_no	varchar(25)	''	NOT NULL
coy_no	varchar(25)	'0'	NOT NULL
tax_prd	integer	1	NOT NULL
tax_last	integer	1	NOT NULL
postal_address	text	''	NOT NULL
phone	varchar(30)	''	NOT NULL
fax	varchar(30)	''	NOT NULL
email	varchar(100)	''	NOT NULL
coy_logo	varchar(100)	''	NOT NULL
domicile	varchar(55)	''	NOT NULL
curr_default	char(3)	''	NOT NULL
debtors_act	varchar(11)	''	NOT NULL
pyt_discount_act	varchar(11)	''	NOT NULL
creditors_act	varchar(11)	''	NOT NULL
bank_charge_act	varchar(11)	''	NOT NULL
exchange_diff_act	varchar(11)	''	NOT NULL
profit_loss_year_act	varchar(11)	''	NOT NULL
retained_earnings_act	varchar(11)	''	NOT NULL
freight_act	varchar(11)	''	NOT NULL
default_sales_act	varchar(11)	''	NOT NULL
default_sales_discount_act	varchar(11)	''	NOT NULL
default_prompt_payment_act	varchar(11)	''	NOT NULL
default_inventory_act	varchar(11)	''	NOT NULL
default_cogs_act	varchar(11)	''	NOT NULL
default_adj_act	varchar(11)	''	NOT NULL
default_inv_sales_act	varchar(11)	''	NOT NULL
default_assembly_act	varchar(11)	''	NOT NULL
payroll_act	varchar(11)	''	NOT NULL
allow_negative_stock	tinyint	0	NOT NULL
po_over_receive	integer	10	NOT NULL
po_over_charge	integer	10	NOT NULL
default_credit_limit	integer	1000	NOT NULL
default_workorder_required	integer	20	NOT NULL
default_dim_required	integer	20	NOT NULL
past_due_days	integer	30	NOT NULL
use_dimension	tinyint	0	NULL
f_year	integer	1	NOT NULL
no_item_list	tinyint	0	NOT NULL
no_customer_list	tinyint	0	NOT NULL
no_supplier_list	tinyint	0	NOT NULL
base_sales	integer	-1	NOT NULL
foreign_codes	tinyint	0	NOT NULL
accumulate_shipping	tinyint	0	NOT NULL
legal_text	text	''	NOT NULL
default_delivery_required	smallint	1	NULL
version_id	varchar(11)	''	NOT NULL
time_zone	tinyint	0	NOT NULL
add_pct	integer	-1	NOT NULL
round_to	integer	1	NOT NULL
login_tout	smallint	600	NOT NULL

Primary key for table '`0_company`'

Primary Key Name	Field Name
PRIMARY	coy_code

Indexes for table '`0_company`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	coy_code

Table: '`0_credit_status`', 4 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
reason_description	char(100)	''	NOT NULL
dissallow_invoices	tinyint	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_credit_status`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_credit_status`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
reason_description	No	Yes	reason_description

Table: '`0_currencies`', 7 fields

Field Name	Type and Size	Default	Nullable	Description
currency	varchar(60)	''	NOT NULL
curr_abrev	char(3)	''	NOT NULL
curr_symbol	varchar(10)	''	NOT NULL
country	varchar(100)	''	NOT NULL
hundreds_name	varchar(15)	''	NOT NULL
inactive	tinyint	0	NOT NULL
auto_update	tinyint	1	NOT NULL

Primary key for table '`0_currencies`'

Primary Key Name	Field Name
PRIMARY	curr_abrev

Indexes for table '`0_currencies`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	curr_abrev

Table: '`0_cust_allocations`', 7 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
amt	double unsigned		NULL
date_alloc	date	'0000-00-00'	NOT NULL
trans_no_from	integer		NULL
trans_type_from	integer		NULL
trans_no_to	integer		NULL
trans_type_to	integer		NULL

Primary key for table '`0_cust_allocations`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_cust_allocations`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_cust_branch`', 24 fields

Field Name	Type and Size	Default	Nullable	Description
branch_code	integer	0	NULL
debtor_no	integer	0	NOT NULL
br_name	varchar(60)	''	NOT NULL
br_address	text	''	NOT NULL
area	integer		NULL
salesman	integer	0	NOT NULL
phone	varchar(30)	''	NOT NULL
phone2	varchar(30)	''	NOT NULL
fax	varchar(30)	''	NOT NULL
contact_name	varchar(60)	''	NOT NULL
email	varchar(100)	''	NOT NULL
default_location	varchar(5)	''	NOT NULL
tax_group_id	integer		NULL
sales_account	varchar(11)		NULL
sales_discount_account	varchar(11)		NULL
receivables_account	varchar(11)		NULL
payment_discount_account	varchar(11)		NULL
default_ship_via	integer	1	NOT NULL
disable_trans	tinyint	0	NOT NULL
br_post_address	text	''	NOT NULL
group_no	integer	0	NOT NULL
notes	text		NULL
inactive	tinyint	0	NOT NULL
branch_ref	varchar(30)	''	NOT NULL

Primary key for table '`0_cust_branch`'

Primary Key Name	Field Names
PRIMARY	branch_code, debtor_no

Indexes for table '`0_cust_branch`', 4 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	branch_code
PRIMARY	No	Yes	debtor_no
branch_code	No	No	branch_code
br_name	No	No	br_name

Table: '`0_debtor_trans`', 21 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
trans_no	integer unsigned	0	NOT NULL
type	smallint unsigned	0	NOT NULL
version	tinyint unsigned	0	NOT NULL
debtor_no	integer unsigned		NULL
branch_code	integer	-1	NOT NULL
tran_date	date	'0000-00-00'	NOT NULL
due_date	date	'0000-00-00'	NOT NULL
reference	varchar(60)	''	NOT NULL
tpe	integer	0	NOT NULL
order_	integer	0	NOT NULL
ov_amount	double	0	NOT NULL
ov_gst	double	0	NOT NULL
ov_freight	double	0	NOT NULL
ov_freight_tax	double	0	NOT NULL
ov_discount	double	0	NOT NULL
alloc	double	0	NOT NULL
rate	double	1	NOT NULL
ship_via	integer		NULL
trans_link	integer	0	NOT NULL
dimension_id	integer	0	NOT NULL
dimension2_id	integer	0	NOT NULL

Primary key for table '`0_debtor_trans`'

Primary Key Name	Field Names
PRIMARY	trans_no, type

Indexes for table '`0_debtor_trans`', 4 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	trans_no
PRIMARY	No	Yes	type
debtor_no	No	No	debtor_no, branch_code

Table: '`0_debtor_trans_details`', 11 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
debtor_trans_no	integer		NULL
debtor_trans_type	integer		NULL
stock_id	varchar(20)	''	NOT NULL
description	text		NULL
unit_price	double	0	NOT NULL
unit_tax	double	0	NOT NULL
quantity	double	0	NOT NULL
discount_percent	double	0	NOT NULL
standard_cost	double	0	NOT NULL
qty_done	double	0	NOT NULL

Primary key for table '`0_debtor_trans_details`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_debtor_trans_details`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_debtors_master`', 17 fields

Field Name	Type and Size	Default	Nullable	Description
debtor_no	integer	0	NULL
name	varchar(100)	''	NOT NULL
address	text		NULL
email	varchar(100)	''	NOT NULL
tax_id	varchar(55)	''	NOT NULL
curr_code	char(3)	''	NOT NULL
sales_type	integer	1	NOT NULL
dimension_id	integer	0	NOT NULL
dimension2_id	integer	0	NOT NULL
credit_status	integer	0	NOT NULL
payment_terms	integer		NULL
discount	double	0	NOT NULL
pymt_discount	double	0	NOT NULL
credit_limit	float	1000	NOT NULL
notes	text		NULL
inactive	tinyint	0	NOT NULL
debtor_ref	varchar(30)	''	NOT NULL

Primary key for table '`0_debtors_master`'

Primary Key Name	Field Name
P	d

Indexes for table '`0_debtors_master`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	debtor_no
name	No	Yes	name

Table: '`0_dimensions`', 7 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
reference	varchar(60)	''	NOT NULL
name	varchar(60)	''	NOT NULL
type_	tinyint	1	NOT NULL
closed	tinyint	0	NOT NULL
date_	date	'0000-00-00'	NOT NULL
due_date	date	'0000-00-00'	NOT NULL

Primary key for table '`0_dimensions`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_dimensions`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
reference	No	Yes	reference

Table: '`0_exchange_rates`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
curr_code	char(3)	''	NOT NULL
rate_buy	double	0	NOT NULL
rate_sell	double	0	NOT NULL
date_	date	'0000-00-00'	NOT NULL

Primary key for table '`0_exchange_rates`'

Primary Key Name	Field Name
PRIMARY	i

Indexes for table '`0_exchange_rates`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
curr_code	No	Yes	curr_code, date_

Table: '`0_fiscal_year`', 4 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
begin	date	'0000-00-00'	NULL
end	date	'0000-00-00'	NULL
closed	tinyint	0	NOT NULL

Primary key for table '`0_fiscal_year`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_fiscal_year`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_gl_trans`', 11 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
counter	integer	0	NULL
type	smallint	0	NOT NULL
type_no	bigint	1	NOT NULL
tran_date	date	'0000-00-00'	NOT NULL
account	varchar(11)	''	NOT NULL
memo_	text	''	NOT NULL
amount	double	0	NOT NULL
dimension_id	integer	0	NOT NULL
dimension2_id	integer	0	NOT NULL
person_type_id	integer		NULL
person_id	blob		NULL

Primary key for table '`0_gl_trans`'

Primary Key Name	Field Name
PRIMARY	counter

Indexes for table '`0_gl_trans`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	counter
Type_and_Number	No	No	type, type_no

Table: '`0_grn_batch`', 6 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
supplier_id	integer	0	NOT NULL
purch_order_no	integer		NULL
reference	varchar(60)	''	NOT NULL
delivery_date	date	'0000-00-00'	NOT NULL
loc_code	varchar(5)		NULL

Primary key for table '`0_grn_batch`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_grn_batch`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_grn_items`', 7 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
grn_batch_id	integer		NULL
po_detail_item	integer	0	NOT NULL
item_code	varchar(20)	''	NOT NULL
description	text		NULL
qty_recd	double	0	NOT NULL
quantity_inv	double	0	NOT NULL

Primary key for table '`0_grn_items`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_grn_items`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_groups`', 3 fields

Field Name	Type and Size	Default	Nullable	Description
id	smallint unsigned	0	NULL
description	varchar(60)	''	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_groups`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_groups`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
description	No	Yes	description

Table: '`0_item_codes`', 8 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer unsigned	0	NULL
item_code	varchar(20)	''	NOT NULL
stock_id	varchar(20)	''	NOT NULL
description	varchar(200)	''	NOT NULL
category_id	smallint unsigned	0	NOT NULL
quantity	double	1	NOT NULL
is_foreign	tinyint	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_item_codes`'

Primary Key Name	Field Name
PRIMARY	i

Indexes for table '`0_item_codes`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
stock_id	No	Yes	stock_id, item_code

Table: '`0_item_tax_type_exemptions`', 2 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
item_tax_type_id	integer	0	NOT NULL
tax_type_id	integer	0	NOT NULL

Primary key for table '`0_item_tax_type_exemptions`'

Primary Key Name	Field Names
PRIMARY	item_tax_type_id, tax_type_id

Indexes for table '`0_item_tax_type_exemptions`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	item_tax_type_id
PRIMARY	No	Yes	tax_type_id

Table: '`0_item_tax_types`', 4 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
name	varchar(60)	''	NOT NULL
exempt	tinyint	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_item_tax_types`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_item_tax_types`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
name	No	Yes	name

Table: '`0_item_units`', 4 fields

Field Name	Type and Size	Default	Nullable	Description
abbr	varchar(20)	''	NOT NULL
name	varchar(40)	''	NOT NULL
decimals	tinyint	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_item_units`'

Primary Key Name	Field Name
P	a

Indexes for table '`0_item_units`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	abbr
name	No	Yes	name

Table: '`0_loc_stock`', 3 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
loc_code	char(5)	''	NOT NULL
stock_id	char(20)	''	NOT NULL
reorder_level	bigint	0	NOT NULL

Primary key for table '`0_loc_stock`'

Primary Key Name	Field Names
PRIMARY	loc_code, stock_id

Indexes for table '`0_loc_stock`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	loc_code
PRIMARY	No	Yes	stock_id
stock_id	No	No	stock_id

Table: '`0_locations`', 9 fields

Field Name	Type and Size	Default	Nullable	Description
loc_code	varchar(5)	''	NOT NULL
location_name	varchar(60)	''	NOT NULL
delivery_address	text	''	NOT NULL
phone	varchar(30)	''	NOT NULL
phone2	varchar(30)	''	NOT NULL
fax	varchar(30)	''	NOT NULL
email	varchar(100)	''	NOT NULL
contact	varchar(30)	''	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_locations`'

Primary Key Name	Field Name
PRIMARY	loc_code

Indexes for table '`0_locations`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	loc_code

Table: '`0_movement_types`', 3 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
name	varchar(60)	''	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_movement_types`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_movement_types`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
name	No	Yes	name

Table: '`0_payment_terms`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
terms_indicator	integer	0	NULL
terms	char(80)	''	NOT NULL
days_before_due	smallint	0	NOT NULL
day_in_following_month	smallint	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_payment_terms`'

Primary Key Name	Field Name
P	t

Indexes for table '`0_payment_terms`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	terms_indicator
terms	No	Yes	terms

Table: '`0_prices`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
stock_id	varchar(20)	''	NOT NULL
sales_type_id	integer	0	NOT NULL
curr_abrev	char(3)	''	NOT NULL
price	double	0	NOT NULL

Primary key for table '`0_prices`'

Primary Key Name	Field Name
PRIMARY	i

Indexes for table '`0_prices`', 4 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
price	No	Yes	stock_id, sales_type_id, curr_abrev

Table: '`0_print_profiles`', 4 fields

Field Name	Type and Size	Default	Nullable	Description
id	smallint unsigned	0	NULL
profile	varchar(30)	''	NOT NULL
report	varchar(5)		NULL
printer	tinyint unsigned		NULL

Primary key for table '`0_print_profiles`'

Primary Key Name	Field Name
PRIMARY	i

Indexes for table '`0_print_profiles`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
profile	No	Yes	profile, report

Table: '`0_printers`', 7 fields

Field Name	Type and Size	Default	Nullable	Description
id	tinyint unsigned	0	NULL
name	varchar(20)	''	NOT NULL
description	varchar(60)	''	NOT NULL
queue	varchar(20)	''	NOT NULL
host	varchar(40)	''	NOT NULL
port	smallint unsigned	0	NOT NULL
timeout	tinyint unsigned	0	NOT NULL

Primary key for table '`0_printers`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_printers`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
name	No	Yes	name

Table: '`0_purch_data`', 6 fields

Field Name	Type and Size	Default	Nullable	Description
supplier_id	integer	0	NOT NULL
stock_id	char(20)	''	NOT NULL
price	double	0	NOT NULL
suppliers_uom	char(50)	''	NOT NULL
conversion_factor	double	1	NOT NULL
supplier_description	char(50)	''	NOT NULL

Primary key for table '`0_purch_data`'

Primary Key Name	Field Names
PRIMARY	supplier_id, stock_id

Indexes for table '`0_purch_data`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	supplier_id
PRIMARY	No	Yes	stock_id

Table: '`0_purch_order_details`', 11 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
po_detail_item	integer	0	NULL
order_no	integer	0	NOT NULL
item_code	varchar(20)	''	NOT NULL
description	text		NULL
delivery_date	date	'0000-00-00'	NOT NULL
qty_invoiced	double	0	NOT NULL
unit_price	double	0	NOT NULL
act_price	double	0	NOT NULL
std_cost_unit	double	0	NOT NULL
quantity_ordered	double	0	NOT NULL
quantity_received	double	0	NOT NULL

Primary key for table '`0_purch_order_details`'

Primary Key Name	Field Name
PRIMARY	po_detail_item

Indexes for table '`0_purch_order_details`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	po_detail_item

Table: '`0_purch_orders`', 8 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
order_no	integer	0	NULL
supplier_id	integer	0	NOT NULL
comments	text		NULL
ord_date	date	'0000-00-00'	NOT NULL
reference	text	''	NOT NULL
requisition_no	text		NULL
into_stock_location	varchar(5)	''	NOT NULL
delivery_address	text	''	NOT NULL

Primary key for table '`0_purch_orders`'

Primary Key Name	Field Name
PRIMARY	order_no

Indexes for table '`0_purch_orders`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	order_no

Table: '`0_quick_entries`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
id	smallint unsigned	0	NULL
type	tinyint	0	NOT NULL
description	varchar(60)	''	NOT NULL
base_amount	double	0	NOT NULL
base_desc	varchar(60)		NULL

Primary key for table '`0_quick_entries`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_quick_entries`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
description	No	No	description

Table: '`0_quick_entry_lines`', 7 fields

Field Name	Type and Size	Default	Nullable	Description
id	smallint unsigned	0	NULL
qid	smallint unsigned	0	NOT NULL
amount	double	0	NULL
action	varchar(2)	''	NOT NULL
dest_id	varchar(11)	''	NOT NULL
dimension_id	smallint unsigned		NULL
dimension2_id	smallint unsigned		NULL

Primary key for table '`0_quick_entry_lines`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_quick_entry_lines`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
qid	No	No	qid

Table: '`0_recurrent_invoices`', 10 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	smallint unsigned	0	NULL
description	varchar(60)	''	NOT NULL
order_no	integer unsigned	0	NOT NULL
debtor_no	integer unsigned		NULL
group_no	smallint unsigned		NULL
days	integer	0	NOT NULL
monthly	integer	0	NOT NULL
begin	date	'0000-00-00'	NOT NULL
end	date	'0000-00-00'	NOT NULL
last_sent	date	'0000-00-00'	NOT NULL

Primary key for table '`0_recurrent_invoices`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_recurrent_invoices`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
description	No	Yes	description

Table: '`0_refs`', 3 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NOT NULL
type	integer	0	NOT NULL
reference	varchar(100)	''	NOT NULL

Primary key for table '`0_refs`'

Primary Key Name	Field Names
PRIMARY	id, type

Indexes for table '`0_refs`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
PRIMARY	No	Yes	type

Table: '`0_sales_order_details`', 9 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
order_no	integer	0	NOT NULL
trans_type	smallint	30	NOT NULL
stk_code	varchar(20)	''	NOT NULL
description	text		NULL
qty_sent	double	0	NOT NULL
unit_price	double	0	NOT NULL
quantity	double	0	NOT NULL
discount_percent	double	0	NOT NULL

Primary key for table '`0_sales_order_details`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_sales_order_details`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_sales_orders`', 19 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
order_no	integer	0	NOT NULL
trans_type	smallint	30	NOT NULL
version	tinyint unsigned	0	NOT NULL
type	tinyint	0	NOT NULL
debtor_no	integer	0	NOT NULL
branch_code	integer	0	NOT NULL
reference	varchar(100)	''	NOT NULL
customer_ref	text	''	NOT NULL
comments	text		NULL
ord_date	date	'0000-00-00'	NOT NULL
order_type	integer	0	NOT NULL
ship_via	integer	0	NOT NULL
delivery_address	text	''	NOT NULL
contact_phone	varchar(30)		NULL
contact_email	varchar(100)		NULL
deliver_to	text	''	NOT NULL
freight_cost	double	0	NOT NULL
from_stk_loc	varchar(5)	''	NOT NULL
delivery_date	date	'0000-00-00'	NOT NULL

Primary key for table '`0_sales_orders`'

Primary Key Name	Field Names
PRIMARY	trans_type, order_no

Indexes for table '`0_sales_orders`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	trans_type
PRIMARY	No	Yes	order_no

Table: '`0_sales_pos`', 7 fields

Field Name	Type and Size	Default	Nullable	Description
id	smallint unsigned	0	NULL
pos_name	varchar(30)	''	NOT NULL
cash_sale	tinyint	0	NOT NULL
credit_sale	tinyint	0	NOT NULL
pos_location	varchar(5)	''	NOT NULL
pos_account	smallint unsigned	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_sales_pos`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_sales_pos`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
pos_name	No	Yes	pos_name

Table: '`0_sales_types`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
sales_type	char(50)	''	NOT NULL
tax_included	integer	0	NOT NULL
factor	double	1	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_sales_types`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_sales_types`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
sales_type	No	Yes	sales_type

Table: '`0_salesman`', 9 fields

Field Name	Type and Size	Default	Nullable	Description
salesman_code	integer	0	NULL
salesman_name	char(60)	''	NOT NULL
salesman_phone	char(30)	''	NOT NULL
salesman_fax	char(30)	''	NOT NULL
salesman_email	varchar(100)	''	NOT NULL
provision	double	0	NOT NULL
break_pt	double	0	NOT NULL
provision2	double	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_salesman`'

Primary Key Name	Field Name
P	s

Indexes for table '`0_salesman`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	salesman_code
salesman_name	No	Yes	salesman_name

Table: '`0_security_roles`', 6 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
role	varchar(30)	''	NOT NULL
description	varchar(50)		NULL
sections	text		NULL
areas	text		NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_security_roles`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_security_roles`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
role	No	Yes	role

Table: '`0_shippers`', 7 fields

Field Name	Type and Size	Default	Nullable	Description
shipper_id	integer	0	NULL
shipper_name	varchar(60)	''	NOT NULL
phone	varchar(30)	''	NOT NULL
phone2	varchar(30)	''	NOT NULL
contact	text	''	NOT NULL
address	text	''	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_shippers`'

Primary Key Name	Field Name
P	s

Indexes for table '`0_shippers`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	shipper_id
name	No	Yes	shipper_name

Table: '`0_sql_trail`', 4 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer unsigned	0	NULL
sql	text	''	NOT NULL
result	tinyint	0	NOT NULL
msg	varchar(255)	''	NOT NULL

Primary key for table '`0_sql_trail`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_sql_trail`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_stock_category`', 14 fields

Field Name	Type and Size	Default	Nullable	Description
category_id	integer	0	NULL
description	varchar(60)	''	NOT NULL
inactive	tinyint	0	NOT NULL
dflt_tax_type	integer	1	NOT NULL
dflt_units	varchar(20)	'each'	NOT NULL
dflt_mb_flag	char(1)	'B'	NOT NULL
dflt_sales_act	varchar(11)	''	NOT NULL
dflt_cogs_act	varchar(11)	''	NOT NULL
dflt_inventory_act	varchar(11)	''	NOT NULL
dflt_adjustment_act	varchar(11)	''	NOT NULL
dflt_assembly_act	varchar(11)	''	NOT NULL
dflt_dim1	integer		NULL
dflt_dim2	integer		NULL
dflt_no_sale	tinyint	0	NOT NULL

Primary key for table '`0_stock_category`'

Primary Key Name	Field Name
P	c

Indexes for table '`0_stock_category`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	category_id
description	No	Yes	description

Table: '`0_stock_master`', 21 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
stock_id	varchar(20)	''	NOT NULL
category_id	integer	0	NOT NULL
tax_type_id	integer	0	NOT NULL
description	varchar(200)	''	NOT NULL
long_description	text	''	NOT NULL
units	varchar(20)	'each'	NOT NULL
mb_flag	char(1)	'B'	NOT NULL
sales_account	varchar(11)	''	NOT NULL
cogs_account	varchar(11)	''	NOT NULL
inventory_account	varchar(11)	''	NOT NULL
adjustment_account	varchar(11)	''	NOT NULL
assembly_account	varchar(11)	''	NOT NULL
dimension_id	integer		NULL
dimension2_id	integer		NULL
actual_cost	double	0	NOT NULL
last_cost	double	0	NOT NULL
material_cost	double	0	NOT NULL
labour_cost	double	0	NOT NULL
overhead_cost	double	0	NOT NULL
inactive	tinyint	0	NOT NULL
no_sale	tinyint	0	NOT NULL

Primary key for table '`0_stock_master`'

Primary Key Name	Field Name
PRIMARY	stock_id

Indexes for table '`0_stock_master`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	stock_id

Table: '`0_stock_moves`', 13 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
trans_id	integer	0	NULL
trans_no	integer	0	NOT NULL
stock_id	char(20)	''	NOT NULL
type	smallint	0	NOT NULL
loc_code	char(5)	''	NOT NULL
tran_date	date	'0000-00-00'	NOT NULL
person_id	integer		NULL
price	double	0	NOT NULL
reference	char(40)	''	NOT NULL
qty	double	1	NOT NULL
discount_percent	double	0	NOT NULL
standard_cost	double	0	NOT NULL
visible	tinyint	1	NOT NULL

Primary key for table '`0_stock_moves`'

Primary Key Name	Field Name
PRIMARY	trans_id

Indexes for table '`0_stock_moves`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	trans_id
type	No	No	type, trans_no

Table: '`0_supp_allocations`', 7 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
amt	double unsigned		NULL
date_alloc	date	'0000-00-00'	NOT NULL
trans_no_from	integer		NULL
trans_type_from	integer		NULL
trans_no_to	integer		NULL
trans_type_to	integer		NULL

Primary key for table '`0_supp_allocations`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_supp_allocations`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_supp_invoice_items`', 12 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
supp_trans_no	integer		NULL
supp_trans_type	integer		NULL
gl_code	varchar(11)	'0'	NOT NULL
grn_item_id	integer		NULL
po_detail_item_id	integer		NULL
stock_id	varchar(20)	''	NOT NULL
description	text		NULL
quantity	double	0	NOT NULL
unit_price	double	0	NOT NULL
unit_tax	double	0	NOT NULL
memo_	text		NULL

Primary key for table '`0_supp_invoice_items`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_supp_invoice_items`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_supp_trans`', 12 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
trans_no	integer unsigned	0	NOT NULL
type	smallint unsigned	0	NOT NULL
supplier_id	integer unsigned		NULL
reference	text	''	NOT NULL
supp_reference	varchar(60)	''	NOT NULL
tran_date	date	'0000-00-00'	NOT NULL
due_date	date	'0000-00-00'	NOT NULL
ov_amount	double	0	NOT NULL
ov_discount	double	0	NOT NULL
ov_gst	double	0	NOT NULL
rate	double	1	NOT NULL
alloc	double	0	NOT NULL

Primary key for table '`0_supp_trans`'

Primary Key Name	Field Names
PRIMARY	trans_no, type

Indexes for table '`0_supp_trans`', 6 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	trans_no
PRIMARY	No	Yes	type
supplier_id	No	No	supplier_id
SupplierID_2	No	No	supplier_id, supp_reference
type	No	No	type

Table: '`0_suppliers`', 25 fields

Field Name	Type and Size	Default	Nullable	Description
supplier_id	integer	0	NULL
supp_name	varchar(60)	''	NOT NULL
address	text	''	NOT NULL
supp_address	text	''	NOT NULL
phone	varchar(30)	''	NOT NULL
phone2	varchar(30)	''	NOT NULL
fax	varchar(30)	''	NOT NULL
gst_no	varchar(25)	''	NOT NULL
contact	varchar(60)	''	NOT NULL
supp_account_no	varchar(40)	''	NOT NULL
email	varchar(100)	''	NOT NULL
website	varchar(100)	''	NOT NULL
bank_account	varchar(60)	''	NOT NULL
curr_code	char(3)		NULL
payment_terms	integer		NULL
dimension_id	integer	0	NULL
dimension2_id	integer	0	NULL
tax_group_id	integer		NULL
credit_limit	double	0	NOT NULL
purchase_account	varchar(11)		NULL
payable_account	varchar(11)		NULL
payment_discount_account	varchar(11)		NULL
notes	text	''	NOT NULL
inactive	tinyint	0	NOT NULL
supp_ref	varchar(30)	''	NOT NULL

Primary key for table '`0_suppliers`'

Primary Key Name	Field Name
PRIMARY	supplier_id

Indexes for table '`0_suppliers`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	supplier_id

Table: '`0_sys_types`', 3 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
type_id	smallint	0	NOT NULL
type_no	integer	1	NOT NULL
next_reference	varchar(100)	''	NOT NULL

Primary key for table '`0_sys_types`'

Primary Key Name	Field Name
PRIMARY	type_id

Indexes for table '`0_sys_types`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	type_id

Table: '`0_tag_associations`', 3 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
record_id	varchar(11)	''	NOT NULL
tag_id	integer	0	NOT NULL

Primary key for table '`0_tag_associations`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_tag_associations`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_tags`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
type	smallint	0	NOT NULL
name	varchar(30)	''	NOT NULL
description	varchar(60)		NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_tags`'

Primary Key Name	Field Name
PRIMARY	i

Indexes for table '`0_tags`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
type	No	Yes	type, name

Table: '`0_tax_group_items`', 3 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
tax_group_id	integer	0	NOT NULL
tax_type_id	integer	0	NOT NULL
rate	double	0	NOT NULL

Primary key for table '`0_tax_group_items`'

Primary Key Name	Field Names
PRIMARY	tax_group_id, tax_type_id

Indexes for table '`0_tax_group_items`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	tax_group_id
PRIMARY	No	Yes	tax_type_id

Table: '`0_tax_groups`', 4 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
name	varchar(60)	''	NOT NULL
tax_shipping	tinyint	0	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_tax_groups`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_tax_groups`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
name	No	Yes	name

Table: '`0_tax_types`', 6 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
rate	double	0	NOT NULL
sales_gl_code	varchar(11)	''	NOT NULL
purchasing_gl_code	varchar(11)	''	NOT NULL
name	varchar(60)	''	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_tax_types`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_tax_types`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
name	No	Yes	name, rate

Table: '`0_trans_tax_details`', 11 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
trans_type	smallint		NULL
trans_no	integer		NULL
tran_date	date	'0000-00-00'	NOT NULL
tax_type_id	integer	0	NOT NULL
rate	double	0	NOT NULL
ex_rate	double	1	NOT NULL
included_in_price	tinyint	0	NOT NULL
net_amount	double	0	NOT NULL
amount	double	0	NOT NULL
memo	text		NULL

Primary key for table '`0_trans_tax_details`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_trans_tax_details`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_useronline`', 4 fields

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
timestamp	integer	0	NOT NULL
ip	varchar(40)	''	NOT NULL
file	varchar(100)	''	NOT NULL

Primary key for table '`0_useronline`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_useronline`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
timestamp	No	No	timestamp

Table: '`0_users`', 30 fields

Field Name	Type and Size	Default	Nullable	Description
id	smallint	0	NULL
user_id	varchar(60)	''	NOT NULL
password	varchar(100)	''	NOT NULL
real_name	varchar(100)	''	NOT NULL
role_id	integer	1	NOT NULL
phone	varchar(30)	''	NOT NULL
email	varchar(100)		NULL
language	varchar(20)		NULL
date_format	tinyint	0	NOT NULL
date_sep	tinyint	0	NOT NULL
tho_sep	tinyint	0	NOT NULL
dec_sep	tinyint	0	NOT NULL
theme	varchar(20)	'default'	NOT NULL
page_size	varchar(20)	'A4'	NOT NULL
prices_dec	smallint	2	NOT NULL
qty_dec	smallint	2	NOT NULL
rates_dec	smallint	4	NOT NULL
percent_dec	smallint	1	NOT NULL
show_gl	tinyint	1	NOT NULL
show_codes	tinyint	0	NOT NULL
show_hints	tinyint	0	NOT NULL
last_visit_date	datetime		NULL
query_size	tinyint	10	NULL
graphic_links	tinyint	1	NULL
pos	smallint	1	NULL
print_profile	varchar(30)	'1'	NOT NULL
rep_popup	tinyint	1	NULL
sticky_doc_date	tinyint	0	NULL
startup_tab	varchar(20)	'orders'	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_users`'

Primary Key Name	Field Name
P	i

Indexes for table '`0_users`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
user_id	No	Yes	user_id

Table: '`0_voided`', 4 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
type	integer	0	NOT NULL
id	integer	0	NOT NULL
date_	date	'0000-00-00'	NOT NULL
memo_	text	''	NOT NULL

Primary key for table '`0_voided`'

Primary Key Name	Field Names
PRIMARY	type, id

Indexes for table '`0_voided`', 2 items

Index Name	Clustered	Unique	Fields
id	No	Yes	type, id

Table: '`0_wo_issue_items`', 4 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
stock_id	varchar(40)		NULL
issue_id	integer		NULL
qty_issued	double		NULL

Primary key for table '`0_wo_issue_items`'

Primary Key Name	Field Name
PRIMARY	id

Indexes for table '`0_wo_issue_items`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_wo_issues`', 6 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
issue_no	integer	0	NULL
workorder_id	integer	0	NOT NULL
reference	varchar(100)		NULL
issue_date	date		NULL
loc_code	varchar(5)		NULL
workcentre_id	integer		NULL

Primary key for table '`0_wo_issues`'

Primary Key Name	Field Name
PRIMARY	issue_no

Indexes for table '`0_wo_issues`', 1 item

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	issue_no

Table: '`0_wo_manufacture`', 5 fields, InnoDB free: 7168 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
reference	varchar(100)		NULL
workorder_id	integer	0	NOT NULL
quantity	double	0	NOT NULL
date_	date	'0000-00-00'	NOT NULL

Primary key for table '`0_wo_manufacture`'

Primary Key Name	Field Name
PRIMARY	id