Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('stock_quant_package_id_seq'::regclass) |
|
|
||||||||||||||||||||
| package_type_id | int4 | 10 | √ | null |
|
|
Package Type |
|||||||||||||||||||
| location_id | int4 | 10 | √ | null |
|
|
Location |
|||||||||||||||||||
| company_id | int4 | 10 | √ | null |
|
|
Company |
|||||||||||||||||||
| create_uid | int4 | 10 | √ | null |
|
|
Created by |
|||||||||||||||||||
| write_uid | int4 | 10 | √ | null |
|
|
Last Updated by |
|||||||||||||||||||
| name | varchar | 2147483647 | null |
|
|
Package Reference |
||||||||||||||||||||
| package_use | varchar | 2147483647 | null |
|
|
Package Use |
||||||||||||||||||||
| pack_date | date | 13 | √ | null |
|
|
Pack Date |
|||||||||||||||||||
| create_date | timestamp | 29,6 | √ | null |
|
|
Created on |
|||||||||||||||||||
| write_date | timestamp | 29,6 | √ | null |
|
|
Last Updated on |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| stock_quant_package_pkey | Primary key | Asc | id |
| stock_quant_package__company_id_index | Performance | Asc | company_id |
| stock_quant_package__location_id_index | Performance | Asc | location_id |
| stock_quant_package__package_type_id_index | Performance | Asc | package_type_id |

