|
SH |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
| Column | Datatype | Nullable | Default value | Comment |
| PROD_ID | NUMBER(6,0) | N | ||
| TIME_ID | DATE | N | ||
| UNIT_COST | NUMBER(10,2) | N | ||
| UNIT_PRICE | NUMBER(10,2) | N |
| Check constraint | Check condition |
| COSTS_PRODUCT_NN | "PROD_ID" IS NOT NULL |
| COSTS_TIME_NN | "TIME_ID" IS NOT NULL |
| COSTS_UNIT_COST_NN | "UNIT_COST" IS NOT NULL |
| COSTS_UNIT_PRICE_NN | "UNIT_PRICE" IS NOT NULL |
| Foreign key | Referenced table | Referenced constraint | Delete rule | Columns |
| COSTS_PRODUCT_FK | PRODUCTS | PRODUCTS_PK | NO ACTION | PROD_ID |
| COSTS_TIME_FK | TIMES | TIME_PK | NO ACTION | TIME_ID |
| Index | Type | Uniqueness | Columns |
| COSTS_PROD_BIX | BITMAP | NONUNIQUE | PROD_ID |
| COSTS_TIME_BIX | BITMAP | NONUNIQUE | TIME_ID |
| Option | Setting |
| Clustered | N |
| Generated by Oracle | N |
| Index Organized | N |
| Logging | |
| Partitioned | Y |
| Temporary | N |
| Nested | N |