Column | Type | Null | Default | Comments |
---|---|---|---|---|
Id_voiture (Primary) | int(11) | No | ||
Id_saison (Primary) | int(11) | No | ||
Id_rallye (Primary) | int(11) | No | ||
Id_pilote (Primary) | int(11) | No | ||
Nbr_point | int(11) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id_saison | 0 | A | No | |
Id_voiture | 0 | A | No | |||||
Id_rallye | 0 | A | No | |||||
Id_pilote | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Id_ecurie (Primary) | int(11) | No | ||
Nom_ecurie | varchar(30) | No | ||
Nb_titre | int(11) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id_ecurie | 4 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Id_pilote (Primary) | int(11) | No | ||
Nom_pilote | varchar(30) | No | ||
Prenom_pilote | varchar(30) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id_pilote | 30 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Id_rallye (Primary) | int(11) | No | ||
Nom_rallye | varchar(30) | No | ||
Lieu_rallye | varchar(30) | No | ||
Type_piste | varchar(30) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id_rallye | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Id_speciale (Primary) | int(11) | No | ||
Id_saison (Primary) | int(11) | No | ||
Id_pilote (Primary) | int(11) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id_speciale | 0 | A | No | |
Id_saison | 0 | A | No | |||||
Id_pilote | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Id_speciale (Primary) | int(11) | No | ||
Date_speciale | date | No | ||
Heure_debut | time | No | ||
Heure_fin | time | No | ||
Lieu_speciale | varchar(30) | No | ||
distance_speciale | int(11) | Yes | NULL | |
Id_rallye | int(11) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id_speciale | 0 | A | No | |
Id_rallye | BTREE | No | No | Id_rallye | 0 | A | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Id_voiture (Primary) | int(11) | No | ||
Modele_voiture | varchar(30) | No | ||
Id_ecurie | int(11) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id_voiture | 0 | A | No | |
Id_ecurie | BTREE | No | No | Id_ecurie | 0 | A | Yes |