1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
-- *** PARAMETRES *** --
create table param(
idParam SERIAL PRIMARY KEY,
lib VARCHAR(45) NOT NULL,
mat CAT NOT NULL,
typeContenaire TYP NOT NULL,
val INT);
-- *** PARAMETRES D'ALGORITHME *** --
CREATE TABLE paramAlgo (
nb_burst_court INT NOT NULL,
nb_burst_moy INT NOT NULL,
nb_burst_long INT NOT NULL,
analyse_start_court INT NOT NULL,
analyse_start_moy INT NOT NULL,
analyse_start_long INT NOT NULL,
analyse_stop_court INT NOT NULL,
analyse_stop_moy INT NOT NULL,
analyse_stop_long INT NOT NULL,
largeur_mini_court INT NOT NULL,
largeur_mini_moy INT NOT NULL,
largeur_mini_long INT NOT NULL,
surface_mini_court INT NOT NULL,
surface_mini_moy INT NOT NULL,
surface_mini_long INT NOT NULL
)INHERITS (param); |
Partager