Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('config.best_hold_order_id_seq'::regclass) |
|
|
||
| name | text | 2147483647 | √ | null |
|
|
||
| pprox | int4 | 10 | √ | null |
|
|
||
| hprox | int4 | 10 | √ | null |
|
|
||
| owning_lib_to_home_lib_prox | int4 | 10 | √ | null |
|
|
||
| aprox | int4 | 10 | √ | null |
|
|
||
| approx | int4 | 10 | √ | null |
|
|
||
| priority | int4 | 10 | √ | null |
|
|
||
| cut | int4 | 10 | √ | null |
|
|
||
| depth | int4 | 10 | √ | null |
|
|
||
| htime | int4 | 10 | √ | null |
|
|
||
| rtime | int4 | 10 | √ | null |
|
|
||
| shtime | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| best_hold_order_pkey | Primary key | Asc | id |
| best_hold_order_name_key | Must be unique | Asc | name |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| best_hold_order_check | (((pprox IS NOT NULL) OR (hprox IS NOT NULL) OR (owning_lib_to_home_lib_prox IS NOT NULL) OR (aprox IS NOT NULL) OR (priority IS NOT NULL) OR (cut IS NOT NULL) OR (depth IS NOT NULL) OR (htime IS NOT NULL) OR (rtime IS NOT NULL))) |
Relationships
Close relationships within degrees of separation
