30 lines
685 B
Markdown
30 lines
685 B
Markdown
# EVENTI_DET_RIS
|
|
|
|
## Struttura
|
|
|
|
| Colonna | Tipo | Nullable | Default |
|
|
|---------|------|----------|----------|
|
|
| ID_EVENTO | NUMBER | N | |
|
|
| ID_RISORSA | NUMBER | N | |
|
|
| ORE_LAV | NUMBER | Y | |
|
|
| ID | NUMBER | Y | |
|
|
| COSTO | NUMBER | Y | 0 |
|
|
| NOTE | VARCHAR2(300) | Y | |
|
|
|
|
## Primary Key
|
|
|
|
`ID_EVENTO, ID_RISORSA`
|
|
|
|
## Foreign Keys
|
|
|
|
| Constraint | Colonna | Tabella Ref | Colonna Ref |
|
|
|------------|---------|-------------|-------------|
|
|
| EVENTI_DET_PERS_IDEV_FK | ID_EVENTO | EVENTI | ID |
|
|
| EVENTI_DET_PERS_IDRIS_FK | ID_RISORSA | RISORSE | ID |
|
|
|
|
## Indici
|
|
|
|
| Nome | Unique | Colonne |
|
|
|------|--------|----------|
|
|
| EVENTI_DET_PERS_PK | UNIQUE | ID_EVENTO, ID_RISORSA |
|