acq.li_state_label (view)

↑ acq 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	Notes
id	`text`	Yes
label	`text`	Yes

text

Yes

label

text

Yes

View Definition

 SELECT t.id,
    t.label
   FROM ( VALUES ('new'::text,oils_i18n_gettext('new'::text, 'New'::text, 'jubstlbl'::text, 'label'::text)), ('selector-ready'::text,oils_i18n_gettext('selector-ready'::text, 'Selector-Ready'::text, 'jubstlbl'::text, 'label'::text)), ('order-ready'::text,oils_i18n_gettext('order-ready'::text, 'Order-Ready'::text, 'jubstlbl'::text, 'label'::text)), ('approved'::text,oils_i18n_gettext('approved'::text, 'Approved'::text, 'jubstlbl'::text, 'label'::text)), ('pending-order'::text,oils_i18n_gettext('pending-order'::text, 'Pending-Order'::text, 'jubstlbl'::text, 'label'::text)), ('on-order'::text,oils_i18n_gettext('on-order'::text, 'On-Order'::text, 'jubstlbl'::text, 'label'::text)), ('received'::text,oils_i18n_gettext('received'::text, 'Received'::text, 'jubstlbl'::text, 'label'::text)), ('cancelled'::text,oils_i18n_gettext('cancelled'::text, 'Cancelled'::text, 'jubstlbl'::text, 'label'::text))) t(id, label);