Table Data dictionary report - system_record_locks

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

Table to control lock records being edited by a user

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('system_record_locks_id_seq'::regclass) Unique identifier
file_id bigint No No Internal file identifier
file_key character varying(127) No No Identifier for locked record, Sales Order number, Customer code, etc
user_id integer No No Identifier from system_users_base.id related to this record

Constraints

Name Type Definition Comment
bvlock_pkey Primary key (id)
system_record_locks_user_id_fkey Foreign key (user_id) REFERENCES public.system_users_base (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE

Report generated by pgAdmin3 LTS by BigSQL