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 |
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 |