asset.latest_inventory (view)

↑ asset schema

This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly.

Columns

Column Type Nullable Notes

Column	Type	Nullable
id	`integer`	Yes
inventory_workstation	`integer`	Yes
inventory_date	`timestamp with time zone`	Yes
copy	`bigint`	Yes

integer

Yes

inventory_workstation

integer

Yes

inventory_date

timestamp with time zone

Yes

copy

bigint

Yes

View Definition

 SELECT DISTINCT ON (copy_inventory.copy) copy_inventory.id,
    copy_inventory.inventory_workstation,
    copy_inventory.inventory_date,
    copy_inventory.copy
   FROM asset.copy_inventory
  ORDER BY copy_inventory.copy, copy_inventory.inventory_date DESC;