Table Data dictionary report - system_sequence_numbers

Generated: 2018-10-18 8:09:01 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public

Notes:

Table to control all of the next sequence numbers i.e. trans_no, order_no, invoice_no etc.

Columns

Name	Data type	Not Null?	Primary key?	Comment
key	character varying(128)	Yes	Yes	Key for sequence number to contol on this record
next_id	bigint	No	No	Next sequence number to use
initials	character varying(3)	No	No	User intitals that last caused sequence number to increment
date	timestamp without time zone	No	No	UTS date and time that sequence number was last incremented
time	bigint	No	No	Not used

Name	Type	Definition	Comment
bve_sequence_pkey	Primary key	(key)