Column | Type | Null | Default | Comments |
---|---|---|---|---|
codiceAttore (Primary) | int(11) | No | ||
nome | char(15) | No | ||
cognome | char(15) | No | ||
sesso | char(1) | No | ||
dataN | date | No | ||
nazionalita | char(25) | No | ||
campoFilmRealizzati | int(11) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | codiceAttore | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
codCinema (Primary) | int(11) | No | ||
nome | char(80) | No | ||
posti | int(11) | No | ||
citta | char(15) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | codCinema | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
codFilm (Primary) | int(11) | No | ||
titolo | char(80) | No | ||
annoProd | int(11) | No | ||
luogoProd | char(15) | No | ||
cognomeReg | char(15) | No | ||
genere | char(25) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | codFilm | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
codAttore (Primary) | int(11) | No | ||
codFilm (Primary) | int(11) | No | ||
personaggio | char(50) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | codAttore | 0 | A | No | |
codFilm | 0 | A | No | |||||
codFilm | BTREE | No | No | codFilm | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
codCinema (Primary) | int(11) | No | ||
codFilm (Primary) | int(11) | No | ||
incasso | float | No | ||
dataProiezione | date | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | codCinema | 0 | A | No | |
codFilm | 0 | A | No | |||||
codFilm | BTREE | No | No | codFilm | 0 | A | No |