Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| __id | int8 | 19 | √ | null |
|
|
||||||
| __cf | bool | 1 | true |
|
|
|||||||
| __start | timestamptz | 35,6 | null |
|
|
|||||||
| __source | varchar | 63 | null |
|
|
|||||||
| __origin | varchar | 63 | ''::character varying |
|
|
|||||||
| id | uuid | 2147483647 | null |
|
|
|||||||
| po_number | varchar | 8 | √ | null |
|
|
||||||
| workflow_status | varchar | 7 | √ | null |
|
|
||||||
| approval_date | timestamptz | 35,6 | √ | null |
|
|
||||||
| bill_to | uuid | 2147483647 | √ | null |
|
|
||||||
| ship_to | uuid | 2147483647 | √ | null |
|
|
||||||
| manual_po | bool | 1 | √ | null |
|
|
||||||
| order_type | varchar | 8 | √ | null |
|
|
||||||
| vendor | uuid | 2147483647 | √ | null |
|
|
||||||
| approved | bool | 1 | √ | null |
|
|
||||||
| re_encumber | bool | 1 | √ | null |
|
|
||||||
| date_ordered | timestamptz | 35,6 | √ | null |
|
|
||||||
| approved_by_id | uuid | 2147483647 | √ | null |
|
|
||||||
| template | uuid | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| purchase_order__t_pkey | Primary key | Asc | id |
| purchase_order__t___origin_idx | Performance | Asc | __origin |
| purchase_order__t___source_idx | Performance | Asc | __source |
| purchase_order__t___start_idx | Performance | Asc | __start |
| purchase_order__t_approval_date_idx | Performance | Asc | approval_date |
| purchase_order__t_approved_by_id_idx | Performance | Asc | approved_by_id |
| purchase_order__t_approved_idx | Performance | Asc | approved |
| purchase_order__t_bill_to_idx | Performance | Asc | bill_to |
| purchase_order__t_date_ordered_idx | Performance | Asc | date_ordered |
| purchase_order__t_id_idx | Performance | Asc | id |
| purchase_order__t_manual_po_idx | Performance | Asc | manual_po |
| purchase_order__t_order_type_idx | Performance | Asc | order_type |
| purchase_order__t_po_number_idx | Performance | Asc | po_number |
| purchase_order__t_re_encumber_idx | Performance | Asc | re_encumber |
| purchase_order__t_ship_to_idx | Performance | Asc | ship_to |
| purchase_order__t_template_idx | Performance | Asc | template |
| purchase_order__t_vendor_idx | Performance | Asc | vendor |
| purchase_order__t_workflow_status_idx | Performance | Asc | workflow_status |
Relationships
Close relationships within degrees of separation
