6 CREATE TABLE makemodel (
12 id int DEFAULT nextval ( 'id' ),
15 transdate date DEFAULT current_date,
21 id int DEFAULT nextval ( 'id' ),
24 charttype char(1) DEFAULT 'A',
35 CREATE TABLE defaults (
36 inventory_accno_id int,
44 weightunit varchar(5),
49 revtrans bool DEFAULT 'f',
52 INSERT INTO defaults (version) VALUES ('2.0.8');
54 CREATE TABLE acc_trans (
58 transdate date DEFAULT current_date,
60 cleared bool DEFAULT 'f',
61 fx_transaction bool DEFAULT 'f',
65 CREATE TABLE invoice (
66 id int DEFAULT nextval ( 'id' ),
75 assemblyitem bool DEFAULT 'f',
82 id int DEFAULT nextval ( 'id' ),
100 CREATE TABLE customer (
101 id int DEFAULT nextval ( 'id' ),
114 creditlimit float DEFAULT 0,
115 terms int2 DEFAULT 0,
122 id int DEFAULT nextval ( 'id' ),
129 priceupdate date DEFAULT current_date,
131 onhand float4 DEFAULT 0,
133 makemodel bool DEFAULT 'f',
134 assembly bool DEFAULT 'f',
135 alternate bool DEFAULT 'f',
137 inventory_accno_id int,
139 expense_accno_id int,
141 obsolete bool DEFAULT 'f',
142 bom bool DEFAULT 'f',
149 CREATE TABLE assembly (
157 id int DEFAULT nextval ( 'id' ),
159 transdate date DEFAULT current_date,
167 invoice bool DEFAULT 'f',
169 terms int2 DEFAULT 0,
177 id int DEFAULT nextval ( 'id' ),
179 transdate date DEFAULT current_date,
181 taxincluded bool DEFAULT 'f',
187 invoice bool DEFAULT 'f',
194 CREATE TABLE partstax (
205 CREATE TABLE customertax (
210 CREATE TABLE vendortax (
216 id int default nextval('id'),
218 transdate date default current_date,
229 closed bool default 'f'
232 CREATE TABLE orderitems (
244 CREATE TABLE exchangerate (
251 CREATE TABLE employee (
252 id int DEFAULT nextval ('id'),
259 workphone varchar(20),
260 homephone varchar(20),
261 startdate date default current_date,
266 create table shipto (
268 shiptoname varchar(35),
269 shiptoaddr1 varchar(35),
270 shiptoaddr2 varchar(35),
271 shiptoaddr3 varchar(35),
272 shiptoaddr4 varchar(35),
273 shiptocontact varchar(35),
274 shiptophone varchar(20),
275 shiptofax varchar(20),
279 create table project (
280 id int default nextval('id'),
285 create table partsgroup (
286 id int default nextval('id'),