Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('api_chest_id_seq'::regclass) |
|
|
|||||
| deleted | timestamptz | 35,6 | √ | null |
|
|
|||||
| code | varchar | 255 | null |
|
|
||||||
| rental | float8 | 17,17 | √ | null |
|
|
|||||
| risk | float8 | 17,17 | √ | null |
|
|
|||||
| cost_risk | float8 | 17,17 | √ | null |
|
|
|||||
| key_custody | float8 | 17,17 | √ | null |
|
|
|||||
| created_at | timestamptz | 35,6 | null |
|
|
||||||
| updated_at | timestamptz | 35,6 | null |
|
|
||||||
| service_order_id | int4 | 10 | √ | null |
|
|
|||||
| type_chest_id | int4 | 10 | √ | null |
|
|
|||||
| location_id | int4 | 10 | √ | null |
|
|
|||||
| code_lock | varchar | 255 | √ | null |
|
|
|||||
| cost_key_custody | float8 | 17,17 | √ | null |
|
|
|||||
| cost_lock | float8 | 17,17 | √ | null |
|
|
|||||
| is_included_package | bool | 1 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| api_chest_pkey | Primary key | Asc | id |
| api_chest_code_504a15e9_like | Performance | Asc | code |
| api_chest_code_key | Must be unique | Asc | code |
| api_chest_location_id_9348aee0 | Performance | Asc | location_id |
| api_chest_service_order_id_0291f7e1 | Performance | Asc | service_order_id |
| api_chest_type_chest_id_6bb3c494 | Performance | Asc | type_chest_id |