Database Schema Report for FrontAccounting 2.3

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_comments
12. 0_credit_status
13. 0_crm_categories
14. 0_crm_contacts
15. 0_crm_persons
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_prefs
63. 0_sys_types
64. 0_tag_associations
65. 0_tags
66. 0_tax_group_items
67. 0_tax_groups
68. 0_tax_types
69. 0_trans_tax_details
70. 0_useronline
71. 0_users
72. 0_voided
73. 0_wo_issue_items
74. 0_wo_issues
75. 0_wo_manufacture
76. 0_wo_requirements
77. 0_workcentres
78. 0_workorders
• Views
• Procedures
• Data Types

Summary

Property	Value
Report created	21-Sep-2010 09:54
DBMS and version	MySQL [ 5.0.51b-community-nt ]
Server	localhost via TCP/IP
Database name	account24
User/Login	root
Driver and version	myodbc5.dll [ 05.01.0006 ]
DTM Schema Reporter	Version 1.20.00, (C) 2003-2009 DTM soft.

Tables, 79 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: 8192 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		NOT 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`', 6 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
Seq	No	No	fiscal_year, gl_date, gl_seq
Type_and_Number	No	No	type, trans_no

Table: '`0_bank_accounts`', 12 fields

Field Name	Type and Size	Default	Nullable	Description
account_code	varchar(15)	''	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	tinytext
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`', 4 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
account_code	No	No	account_code

Table: '`0_bank_trans`', 12 fields, InnoDB free: 8192 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
type	smallint		NULL
trans_no	integer		NULL
bank_act	varchar(15)	''	NOT NULL
ref	varchar(40)		NULL
trans_date	date	'0000-00-00'	NOT 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`', 9 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
bank_act	No	No	bank_act, ref
type	No	No	type, trans_no
bank_act_2	No	No	bank_act, reconciled
bank_act_3	No	No	bank_act, trans_date

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`', 10 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

Table: '`0_budget_trans`', 11 fields, InnoDB free: 8192 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(15)	''	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`', 7 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	counter
Type_and_Number	No	No	type, type_no
Account	No	No	account, tran_date, dimension_id, dimension2_id

Table: '`0_chart_class`', 4 fields

Field Name	Type and Size	Default	Nullable	Description
cid	varchar(3)	''	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(15)	''	NOT NULL
account_code2	varchar(15)	''	NOT NULL
account_name	varchar(60)	''	NOT NULL
account_type	varchar(10)	'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`', 4 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	account_code
account_name	No	No	account_name
accounts_by_type	No	No	account_type, account_code

Table: '`0_chart_types`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
id	varchar(10)	''	NOT NULL
name	varchar(60)	''	NOT NULL
class_id	varchar(3)	''	NOT NULL
parent	varchar(10)	'-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`', 3 items

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

Table: '`0_comments`', 4 fields, InnoDB free: 8192 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

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

Index Name	Clustered	Unique	Fields
type_and_id	No	No	type, id

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_crm_categories`', 7 fields, InnoDB free: 8192 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL	pure technical key
type	varchar(20)	''	NOT NULL	contact type e.g. customer
action	varchar(20)	''	NOT NULL	detailed usage e.g. department
name	varchar(30)	''	NOT NULL	for category selector
description	tinytext	''	NOT NULL	usage description
system	tinyint(1)	0	NOT NULL	nonzero for core system usage
inactive	tinyint	0	NOT NULL

Primary key for table '`0_crm_categories`'

Primary Key Name	Field Name
P	i

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

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

Table: '`0_crm_contacts`', 5 fields, InnoDB free: 8192 kB

NULL

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
person_id	integer	0	NOT NULL	foreign key to crm_contacts
type	varchar(20)	''	NOT NULL	foreign key to crm_categories
action	varchar(20)	''	NOT NULL	foreign key to crm_categories
entity_id	varchar(11)	''		entity id in related class table

Primary key for table '`0_crm_contacts`'

Primary Key Name	Field Name
PRIMARY	id

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

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

Table: '`0_crm_persons`', 12 fields, InnoDB free: 8192 kB

Field Name	Type and Size	Default	Nullable	Description
id	integer	0	NULL
ref	varchar(30)	''	NOT NULL
name	varchar(60)	''	NOT NULL
name2	varchar(60)		NULL
address	text
phone	varchar(30)	NULL
phone2	varchar(30)		NULL
fax	varchar(30)		NULL
email	varchar(100)		NULL
lang	char(5)		NULL
notes	text	''	NOT NULL
inactive	tinyint	''	NOT NULL

Primary key for table '`0_crm_persons`'

Primary Key Name	Field Name
PRIMARY	id

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

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

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
auto_update	tinyint	1	NOT NULL
inactive	tinyint	0	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: 8192 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`', 5 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
From	No	No	trans_type_from
From	No	No	trans_no_from
To	No	No	trans_type_to

Table: '`0_cust_branch`', 20 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
branch_ref	varchar(30)	''	NOT NULL
br_address	text	''	NOT NULL
area	integer		NULL
salesman	integer	0	NOT NULL
contact_name	varchar(60)	''	NOT NULL
default_location	varchar(5)	''	NOT NULL
tax_group_id	integer		NULL
sales_account	varchar(15)	''	NOT NULL
sales_discount_account	varchar(15)	''	NOT NULL
receivables_account	varchar(15)	''	NOT NULL
payment_discount_account	varchar(15)	''	NOT 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	''	NOT NULL
inactive	tinyint	0	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`', 5 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	branch_code
PRIMARY	No	Yes	debtor_no
branch_code	No	No	branch_code
branch_ref	No	No	branch_ref
group_no	No	No	group_no

Table: '`0_debtor_trans`', 21 fields, InnoDB free: 8192 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
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
dimension_id	integer	0	NOT NULL
dimension2_id	integer	0	NOT NULL
payment_terms	integer		NULL

Primary key for table '`0_debtor_trans`'

Primary Key Name	Field Names
PRIMARY	type, trans_no

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

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

Table: '`0_debtor_trans_details`', 12 fields, InnoDB free: 8192 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
src_id	integer		NOT NULL

Primary key for table '`0_debtor_trans_details`'

Primary Key Name	Field Name
PRIMARY	id

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

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
Transaction	No	No	debtor_trans_type
Transaction	No	No	debtor_trans_no
src_id	No	No	src_id

Table: '`0_debtors_master`', 16 fields

Field Name	Type and Size	Default	Nullable	Description
debtor_no	integer	0	NULL
name	varchar(100)	''	NOT NULL
debtor_ref	varchar(30)	''	NOT NULL
address	text		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	''	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_debtors_master`'

Primary Key Name	Field Name
P	d

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

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

Table: '`0_dimensions`', 7 fields, InnoDB free: 8192 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`', 5 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
reference	No	Yes	reference
date_	No	No	date_
due_date	No	No	due_date
type_	No	No	type_

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: 8192 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
P	i

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

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
begin	No	Yes	begin
end	No	Yes	end

Table: '`0_gl_trans`', 11 fields, InnoDB free: 8192 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(15)	''	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`', 8 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	counter
Type_and_Number	No	No	type, type_no
dimension_id	No	No	dimension_id
dimension2_id	No	No	dimension2_id
tran_date	No	No	tran_date
account_and_tran_date	No	No	account, tran_date

Table: '`0_grn_batch`', 6 fields, InnoDB free: 8192 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`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
delivery_date	No	No	delivery_date
purch_order_no	No	No	purch_order_no

Table: '`0_grn_items`', 7 fields, InnoDB free: 8192 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`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
grn_batch_id	No	No	grn_batch_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
is_foreign	tinyint	0	NOT NULL

Primary key for table '`0_item_codes`'

Primary Key Name	Field Name
PRIMARY	i

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

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

Table: '`0_item_tax_type_exemptions`', 2 fields, InnoDB free: 8192 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: 8192 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, units of measure

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: 8192 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: 8192 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`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	po_detail_item
order	No	No	order_no
order	No	No	po_detail_item

Table: '`0_purch_orders`', 10 fields, InnoDB free: 8192 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
total	double	0	NOT NULL
tax_included	tinyint	0	NOT NULL

Primary key for table '`0_purch_orders`'

Primary Key Name	Field Name
PRIMARY	order_no

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

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

Table: '`0_quick_entries`', 6 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
bal_type	tinyint	0	NOT 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: 8192 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: 8192 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`', 4 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
PRIMARY	No	Yes	type
Type_and_Reference	No	No	type, reference

Table: '`0_sales_order_details`', 9 fields, InnoDB free: 8192 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`', 3 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
sorder	No	No	trans_type, order_no

Table: '`0_sales_orders`', 21 fields, InnoDB free: 8192 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
payment_terms	integer		NULL
total	double	0	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
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(15)	''	NOT NULL
dflt_cogs_act	varchar(15)	''	NOT NULL
dflt_inventory_act	varchar(15)	''	NOT NULL
dflt_adjustment_act	varchar(15)	''	NOT NULL
dflt_assembly_act	varchar(15)	''	NOT NULL
dflt_dim1	integer		NULL
dflt_dim2	integer		NULL
inactive	tinyint	0	NOT 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`', 22 fields, InnoDB free: 8192 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(15)	''	NOT NULL
cogs_account	varchar(15)	''	NOT NULL
inventory_account	varchar(15)	''	NOT NULL
adjustment_account	varchar(15)	''	NOT NULL
assembly_account	varchar(15)	''	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
editable	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: 8192 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`', 6 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	trans_id
type	No	No	type, trans_no
Move	No	No	stock_id, loc_code, tran_date

Table: '`0_supp_allocations`', 7 fields, InnoDB free: 8192 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`', 5 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
From	No	No	trans_type_from
From	No	No	trans_no_from
To	No	No	trans_type_to

Table: '`0_supp_invoice_items`', 12 fields, InnoDB free: 8192 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(15)	''	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`', 4 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
Transaction	No	No	supp_trans_type
Transaction	No	No	supp_trans_no
Transaction	No	No	stock_id

Table: '`0_supp_trans`', 13 fields, InnoDB free: 8192 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
tax_included	tinyint	0	NOT NULL

Primary key for table '`0_supp_trans`'

Primary Key Name	Field Names
PRIMARY	type, trans_no

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

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

Table: '`0_suppliers`', 22 fields

Field Name	Type and Size	Default	Nullable	Description
supplier_id	integer	0	NULL
supp_name	varchar(60)	''	NOT NULL
supp_ref	varchar(30)	''	NOT NULL
address	text	''	NOT NULL
supp_address	text	''	NOT NULL
gst_no	varchar(25)	''	NOT NULL
contact	varchar(60)	''	NOT NULL
supp_account_no	varchar(40)	''	NOT NULL
website	varchar(100)	''	NOT NULL
bank_account	varchar(60)	''	NOT NULL
curr_code	char(3)		NULL
payment_terms	integer		NULL
tax_included	tinyint	0	NOT 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(15)		NULL
payable_account	varchar(15)	''	NOT NULL
payment_discount_account	varchar(15)		NULL
notes	text	''	NOT NULL
inactive	tinyint	0	NOT NULL

Primary key for table '`0_suppliers`'

Primary Key Name	Field Name
PRIMARY	supplier_id

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

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

Table: '`0_sys_prefs`', 5 fields

Field Name	Type and Size	Default	Nullable	Description
name	varchar(35)	''	NOT NULL
category	varchar(30)		NULL
type	varchar(20)	''	NOT NULL
length	smallint		NULL
value	text

Primary key for table '`0_sys_prefs`'

Primary Key Name	Field Name
PRIMARY	name

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

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

Table: '`0_sys_types`', 3 fields, InnoDB free: 8192 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`', 2 fields

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

Primary key for table '`0_tag_associations`'

Primary Key Name	Field Names
PRIMARY	record_id, tag_id

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

Index Name	Clustered	Unique	Fields
record_id	No	Yes	record_id, tag_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: 8192 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: 8192 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: 8192 kB

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

Primary key for table '`0_tax_types`'

Primary Key Name	Field Name
PRIMARY	id

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

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id

Table: '`0_trans_tax_details`', 11 fields, InnoDB free: 8192 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`', 4 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	id
Type_and_Number	No	No	trans_type, trans_no
tran_date	No	No	tran_date

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`', 3 items

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

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: 8192 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: 8192 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: 8192 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`', 2 items

Index Name	Clustered	Unique	Fields
PRIMARY	No	Yes	issue_no
workorder_id	No	No	workorder_id

Table: '`0_wo_manufacture`', 5 fields, InnoDB free: 8192 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