|
DMONIX |
|
Table ORDERS |
| Info |
| Tablespace | DMDATA |
| Logging | YES |
| Temporary | N |
| Organization | HEAP |
| Comments |
| Columns |
| Name | Type | Nullable | Default | Comments |
| CUSTOMER_ID | NUMBER | N | ||
| PRODUCT_ID | NUMBER | N | ||
| DELIVERY_DATE | DATE | Y |
| Constraints |
| Name | Type | Column(s) | Referenced Constraint Name [Owner.Table.Constraint] |
| ORDERS_CUSTID_FK | FOREIGN KEY | CUSTOMER_ID | DMONIX.CUSTOMER.CUSTOMER_PK |
| ORDERS_PROD_FK | FOREIGN KEY | PRODUCT_ID | DMONIX.PRODUCTS.PRODUCTS_PK |
| oracle_internal_name | CHECK | CUSTOMER_ID | |
| oracle_internal_name | CHECK | PRODUCT_ID |
| Indexes |
| Name | Column(s) | Uniqueness | Tablespace |