MOMIS: RENAULT data source definition

Schema E/R




Data structure

TRANDSUS
NAMETS CHAR(200) NOT NULL,
PRIMARY KEY (NAMETS)

CHANGE
CODC CHAR(5) NOT NULL,
TYPE CHAR(10) NOT NULL,
PRIMARY KEY (CODC,TYPE)

MODEL
NAME CHAR(15) NOT NULL,
NAMETSF CHAR(200) NOT NULL,
NAMETSR CHAR(200) NOT NULL,
VOLBAG_DM3 INTEGER NOT NULL,
LENGTH DECIMAL(8,4) NOT NULL,
WIDTH DECIMAL(8,4) NOT NULL,
HEIGHT DECIMAL(8,4) NOT NULL,
PRIMARY KEY (NAME),
FOREIGN KEY (NAMETSF) REFERENCES TRANDSUS(NAMETS),
FOREIGN KEY (NAMETSR) REFERENCES TRANDSUS(NAMETS)

MOTOR
COD CHAR(5) NOT NULL,
PISTON_DISPLACEMENT_CC INTEGER NOT NULL,
BORE_X_RACE_MM CHAR(10) NOT NULL,
NO_OF_CYLINDER INTEGER NOT NULL,
NO_OF_VALVES INTEGER NOT NULL,
COMPRESSION_RATIO CHAR(8) NOT NULL,
POWER_KW CHAR(15) NOT NULL,
POWER_CV CHAR(15) NOT NULL,
BRACE_NM CHAR(15) NOT NULL,
BRACE_MKG CHAR(15) NOT NULL,
TYPE_OF_INJECTION CHAR(50) NOT NULL,
FUEL CHAR(15) NOT NULL,
PRIMARY KEY (COD,TYPE_OF_INJECTION)

VERSION
COD CHAR(5) NOT NULL,
NAMEMODEL CHAR(15) NOT NULL,
TYPE_OF_INJECTION CHAR(50) NOT NULL,
NAMEVERSION CHAR(30) NOT NULL,
CODC CHAR(5) NOT NULL,
TYPECHANGE CHAR(10) NOT NULL,
NO_OF_RELATIONSHIP INTEGER NOT NULL,
VEL_I DECIMAL(8,3) NOT NULL,
VEL_II DECIMAL(8,3) NOT NULL,
VEL_III DECIMAL(8,3) NOT NULL,
VEL_IV DECIMAL(8,3),
VEL_V DECIMAL(8,3),
WHEELS CHAR(10) NOT NULL,
TIRES CHAR(10) NOT NULL,
ABILITY_TANK_L INTEGER,
AERODYNAMICS CHAR(10),
DIA_OF_TURN_SIDEWALK DECIMAL(8,2) NOT NULL,
DIA_OF_TURN_WALL DECIMAL(8,2) NOT NULL,
NO_TURN_FLYING DECIMAL(8,2),
SPEED_MAX INTEGER NOT NULL,
P_0_100_S DECIMAL(8,2) NOT NULL,
P_400M_S DECIMAL(8,2),
P_1000M_S DECIMAL(8,2),
CITY_CICLE DECIMAL(6,2) NOT NULL,
CITY_EXTRA_CICLE DECIMAL(6,2) NOT NULL,
MIXED_CICLE DECIMAL(6,2) NOT NULL,
CO2_G_KM INTEGER,
REFRAINING_CIRCUIT CHAR(3) NOT NULL,
ABS CHAR(20),
BRAKEBOOSTER CHAR(10) NOT NULL,
DIA_BRAKEBOOSTER INTEGER,
FRONT CHAR(15) NOT NULL,
REAR CHAR(15) NOT NULL,
W_EMPTY_MARCH_ORDER_KG INTEGER NOT NULL,
W_AUTHORIZED_MAX_KG INTEGER NOT NULL,
W_TRAVELLING_TOTAL_KG INTEGER NOT NULL,
W_PAYLOAD_KG INTEGER NOT NULL,
W_REFRAINED_TOWING_KG INTEGER NOT NULL,
W_NOT_REFRAINED_TOWING_KG INTEGER NOT NULL,
PRICE DECIMAL(8,2),
PRIMARY KEY (NAMEMODEL,NAMEVERSION),
FOREIGN KEY (COD,TYPE_OF_INJECTION) REFERENCES MOTOR (COD,TYPE_OF_INJECTION) ,
FOREIGN KEY (NAMEMODEL) REFERENCES MODEL (NAME) , FOREIGN KEY (CODC, TYPECHANGE)
REFERENCES CHANGE (CODC,TYPE)

Back
The MOMIS Home Page