Table Data dictionary report - sales_order_equipment

Generated: 2018-10-18 8:03:29 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for equipment attached to open Sales Orders

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('sales_order_equipment_id_seq'::regclass) Unique identifier
order_no character varying(10) No No Sales order number for this record - links to sales_orders.order_no
equipment_no character varying(10) No No Equipment number - links to equipment.equipment_no
unit_no character varying(80) No No Unit number from equipment.unit_no
odometer integer No No Current reading
estimate numeric(15,2) No No Repair estimate
order_type character varying(1) No No 'R'::character varying Not used
reference_no character varying(20) No No Reference number
_dbversion integer No No Program version that last modified this record
_modified timestamp without time zone No No UTC Date and time this record was last modified
_modified_by character varying(3) No No User initials that last 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

Constraints

Name Type Definition Comment
bve_order_vehicle_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL