Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('stock_assign_serial_id_seq'::regclass) |
|
|
|||||
| move_id | int4 | 10 | √ | null |
|
|
Move |
||||
| next_serial_count | int4 | 10 | null |
|
|
Number of SN |
|||||
| create_uid | int4 | 10 | √ | null |
|
|
Created by |
||||
| write_uid | int4 | 10 | √ | null |
|
|
Last Updated by |
||||
| next_serial_number | varchar | 2147483647 | null |
|
|
First SN |
|||||
| create_date | timestamp | 29,6 | √ | null |
|
|
Created on |
||||
| write_date | timestamp | 29,6 | √ | null |
|
|
Last Updated on |
||||
| production_id | int4 | 10 | √ | null |
|
|
Production |
||||
| serial_numbers | text | 2147483647 | √ | null |
|
|
Produced Serial Numbers |
||||
| multiple_lot_components_names | text | 2147483647 | √ | null |
|
|
Multiple Lot Components Names |
||||
| expected_qty | numeric | 0 | √ | null |
|
|
Expected Quantity |
||||
| produced_qty | numeric | 0 | √ | null |
|
|
Produced Quantity |
||||
| show_apply | bool | 1 | √ | null |
|
|
Show Apply |
||||
| show_backorders | bool | 1 | √ | null |
|
|
Show Backorders |
||||
| mark_as_done | bool | 1 | √ | null |
|
|
Valide all the productions after the split |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| stock_assign_serial_pkey | Primary key | Asc | id |
Relationships
Close relationships within degrees of separation
