config.best_hold_order

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.best_hold_order_id_seq'::regclass)

name

text

Yes

pprox

integer

Yes

hprox

integer

Yes

owning_lib_to_home_lib_prox

integer

Yes

aprox

integer

Yes

approx

integer

Yes

priority

integer

Yes

cut

integer

Yes

depth

integer

Yes

htime

integer

Yes

rtime

integer

Yes

shtime

integer

Yes

Primary Key

(id)

Unique Constraints

  • best_hold_order_name_key: (name)

Check Constraints

  • best_hold_order_check: CHECK

Indexes

Index Method Definition

best_hold_order_pkey PK

btree

CREATE UNIQUE INDEX best_hold_order_pkey ON config.best_hold_order USING btree (id)

best_hold_order_name_key UNIQUE

btree

CREATE UNIQUE INDEX best_hold_order_name_key ON config.best_hold_order USING btree (name)