Table Data dictionary report - inventory_upc_codes

Generated: 2018-10-18 7:21:26 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Universal Product Codes link to Inventory items

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('inventory_upc_codes_id_seq'::regclass) Unique identifier
whse character varying(6) Yes No Warehouse for this record - links to inventory.whse
part_no character varying(34) Yes No Part number for this record - links to inventory-part_no
upc_code character varying(40) Yes No Universal Product Code for this record
_dbversion integer No No Program version 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
_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
uom character varying(10) No No Unit of Measure for this record

Constraints

Name Type Definition Comment
bve_upc_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL