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