+CREATE TABLE status (
+ trans_id int,
+ formname text,
+ printed bool default 'f',
+ emailed bool default 'f',
+ spoolfile text,
+ chart_id int
+);
+--
+CREATE TABLE department (
+ id int default nextval('id'),
+ description text,
+ role char(1) default 'P'
+);
+--
+-- department transaction table
+CREATE TABLE dpt_trans (
+ trans_id int,
+ department_id int
+);
+--
+-- business table
+CREATE TABLE business (
+ id int default nextval('id'),
+ description text,
+ discount float4
+);
+--
+-- SIC
+CREATE TABLE sic (
+ code varchar(6),
+ sictype char(1),
+ description text
+);
+--
+CREATE TABLE warehouse (
+ id int default nextval('id'),
+ description text
+);
+--
+CREATE TABLE inventory (
+ warehouse_id int,
+ parts_id int,
+ oe_id int,
+ orderitems_id int,
+ qty float4,
+ shippingdate date,
+ employee_id int
+);
+--
+CREATE TABLE yearend (
+ trans_id int,
+ transdate date
+);
+--
+CREATE TABLE partsvendor (
+ vendor_id int,
+ parts_id int,
+ partnumber text,
+ leadtime int2,
+ lastcost float,
+ curr char(3)
+);
+--
+CREATE TABLE pricegroup (
+ id int default nextval('id'),
+ pricegroup text
+);
+--
+CREATE TABLE partscustomer (
+ parts_id int,
+ customer_id int,
+ pricegroup_id int,
+ pricebreak float4,
+ sellprice float,
+ validfrom date,
+ validto date,
+ curr char(3)
+);
+--
+CREATE TABLE language (
+ code varchar(6),
+ description text
+);
+--
+CREATE TABLE audittrail (
+ trans_id int,
+ tablename text,
+ reference text,
+ formname text,
+ action text,
+ transdate timestamp default current_timestamp,
+ employee_id int
+);
+--
+CREATE TABLE translation (
+ trans_id int,
+ language_code varchar(6),
+ description text
+);
+--