| id |
integer |
Yes |
Yes |
nextval('equipment_id_seq'::regclass) |
Unique identifier |
| equipment_no |
character varying(10) |
No |
No |
|
Unique identifier in string format |
| cust_no |
character varying(20) |
No |
No |
|
Customer code for this record - links to customers.cust_no |
| unit_no |
character varying(80) |
No |
No |
|
Unit number |
| year |
character varying(4) |
No |
No |
|
Year |
| make |
character varying(20) |
No |
No |
|
Make |
| model |
character varying(20) |
No |
No |
|
Model |
| territory |
character varying(10) |
No |
No |
|
Territory - usually province or state |
| license_no |
character varying(80) |
No |
No |
|
Licence plate number |
| serial_no |
character varying(80) |
No |
No |
|
Serial number |
| extra01 |
character varying(80) |
No |
No |
|
Additional identifier 1 |
| extra02 |
character varying(80) |
No |
No |
|
Additional identifier 2 |
| engine |
character varying(20) |
No |
No |
|
Not used |
| irp_no |
character varying(15) |
No |
No |
|
Not used |
| odometer |
integer |
No |
No |
|
Odometer |
| followup_date |
date |
No |
No |
|
Followup date |
| odometer_type |
character varying(1) |
No |
No |
|
Odometer unit selected ; Blank = Not used K = First unit M = Second unit |
| notes |
text |
No |
No |
|
Equipment notes |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| udf_data |
hstore |
No |
No |
''::hstore |
User Defined Fields data |
| extra03 |
character varying(80) |
No |
No |
|
Additional identifier 3 |
| extra04 |
character varying(80) |
No |
No |
|
Additional identifier 4 |
| extra05 |
character varying(80) |
No |
No |
|
Additional identifier 5 |