1 2 3 4 5 6 7 8 9 10 11 12
|
CREATE TABLE ScenarioDescription (
idScenarioDescription INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
Scenario_idScenario INTEGER UNSIGNED NOT NULL,
AP_horizontal_location ENUM('face to the window','not face to the window') NULL,
AP_vertical_location ENUM('top floor','middle floor','ground floor') NULL,
user_horizontal_location ENUM('sidewalk','not in the sidewalk') NULL,
user_vertical_location ENUM('1 floor above and below','2 floors above and below') NULL,
building_location ENUM('face in the street','not face in the street') NULL,
PRIMARY KEY(idScenarioDescription, Scenario_idScenario),
INDEX ScenarioDescription_FKIndex1(Scenario_idScenario)
); |
Partager