Table Data dictionary report - inventory_comments

Generated: 2018-10-18 6:18:16 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Comments to be used on Sales Orders in the place of Inventory

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('inventory_comments_id_seq'::regclass) Unique identifier
code character varying(20) No No Code for the comment
description character varying(60) No No Brief description for the comment
comments text No No The extended comment which can be a paragraph or more
_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

Constraints

Name Type Definition Comment
inventory_comments_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL