Record locks

record_locks

• Schema: public
• PK: none (enforced via unique indexes)
• TTL: 1 minute (row_expiration_time defaults to now() + 1 min)
• Notes: Global record-level locks to prevent concurrent writes.

Columns

Column	Type	Nullable	Default	Notes
base_id	uuid	YES
internal_rec_id	uuid	NO		Unique index
created_time	timestamp	YES	now()
row_expiration_time	timestamptz	YES	now() + interval '1 min'	TTL column
table_and_external_rec_id	varchar	NO		Unique index
record_match_key	varchar	YES

Key indexes

• Unique index on internal_rec_id
• Unique index on table_and_external_rec_id

---