MOMIS: VOLKSWAGEN odli3 data source description

// Data source Description... for []
// metadata
// ----- [STENE.CAR]
interface STENE___CAR(source relational wrDb2Volks
key (NAME)) {
// ResultSet [Index Info]

attribute char NAME;
attribute long /* DECIMAL */ WHEELBASE;
attribute long /* DECIMAL */ FRONT_TRACK;
attribute long /* DECIMAL */ REAR_TRACK;
attribute long /* DECIMAL */ LENGTH;
attribute long /* DECIMAL */ WIDTH;
attribute long /* DECIMAL */ HEIGHT;
attribute long /* DECIMAL */ GROUND_CLEARANCE;
};

// ----- [STENE.DRIVE_TRAIN]
interface STENE___DRIVE_TRAIN(source relational wrDb2Volks
key (DRIVE_TRAINS,TRANS_GEAR_RATIO)) {
// ResultSet [Index Info]

attribute char DRIVE_TRAINS;
attribute char TRANS_GEAR_RATIO;
};

// ----- [STENE.ELECTRICAL_SYSTEM]
interface STENE___ELECTRICAL_SYSTEM(source relational wrDb2Volks
key (ALTERNATOR_V_A,BATTERY_V,BATTERY_A_HRS,IGNITION)) {
// ResultSet [Index Info]

attribute char ALTERNATOR_V_A;
attribute long /* INTEGER */ BATTERY_V;
attribute long /* INTEGER */ BATTERY_A_HRS;
attribute char IGNITION;
};

// ----- [STENE.ENGINE]
interface STENE___ENGINE(source relational wrDb2Volks
key (COD_E)
foreign_key(ALTERNATOR_V_A,BATTERY_V,BATTERY_A_HRS,IGNITION)
references STENE___ELECTRICAL_SYSTEM) {
// ResultSet [Index Info]

attribute char COD_E;
attribute char TYPE;
attribute long /* DECIMAL */ BORE_CM;
attribute long /* DECIMAL */ STROKE_CM;
attribute long /* INTEGER */ DISPLACEMENT_CC;
attribute char COMPRESSION_RATIO;
attribute char HORSEPOWER;
attribute char KW;
attribute char MAX_TORQUE_MKG;
attribute char MAX_TORQUE_NM;
attribute char FUEL_REQUIREMENT;
attribute char ARRANGEMENT;
attribute char CYLINDER_BLOCK;
attribute char CRANCK_SHAFT;
attribute char CYLINDER_HEAD;
attribute char VALVE_TRAIN;
attribute char COOLING_SYSTEM;
attribute char LUBRIFICATION;
attribute char FUEL_AIR_SUPPLY;
attribute char EMISSION;
attribute char ALTERNATOR_V_A;
attribute long /* INTEGER */ BATTERY_V;
attribute long /* INTEGER */ BATTERY_A_HRS;
attribute char IGNITION;
attribute char FIRE_ORDER;
attribute long /* DECIMAL */ ENGINE_OIL_L;
attribute long /* DECIMAL */ FUEL_TANK_L;
attribute long /* DECIMAL */ COOLING_SYSTEM_L;
attribute long /* DECIMAL */ WIPER_FLUID_L;
};

// ----- [STENE.FUEL_CONSUMPTION]
interface STENE___FUEL_CONSUMPTION(source relational wrDb2Volks
key (NAME,COD_E,DRIVE_TRAINS,TRANS_GEAR_RATIO)
foreign_key (NAME) references STENE___CAR
foreign_key (COD_E) references STENE___ENGINE
foreign_key (DRIVE_TRAINS,TRANS_GEAR_RATIO)
references STENE___DRIVE_TRAIN) {
// ResultSet [Index Info]

attribute char NAME;
attribute char COD_E;
attribute char DRIVE_TRAINS;
attribute char TRANS_GEAR_RATIO;
attribute long /* INTEGER */ CITY_KM_L;
attribute long /* INTEGER */ HIGHWAY_KM_L;
};

// ----- [STENE.GEAR]
interface STENE___GEAR(source relational wrDb2Volks
key (COD_E,DRIVE_TRAINS)
foreign_key(COD_E) references STENE___ENGINE
foreign_key(DRIVE_TRAINS,TRANS_GEAR_RATIO)
references STENE___DRIVE_TRAIN) {
// ResultSet [Index Info]

attribute char COD_E;
attribute char DRIVE_TRAINS;
attribute char TRANS_GEAR_RATIO;
attribute char FIRST;
attribute char SECOND;
attribute char THIRD;
attribute char FOURTH;
attribute char FIFTH;
attribute char REVERSE;
attribute char FINAL_DRIVE;
};

// ----- [STENE.MODEL]
interface STENE___MODEL(source relational wrDb2Volks
key (NAME,COD_E)
foreign_key(NAME) references STENE___CAR
foreign_key(COD_E) references STENE___ENGINE
foreign_key(STEERING) references STENE___STEERING) {
// ResultSet [Index Info]

attribute char NAME;
attribute char COD_E;
attribute char EPA_CLASS;
attribute long /* INTEGER */ PASSENGER_VOL_DM3;
attribute long /* INTEGER */ TRUNCK_VOL_DM3;
attribute long /* INTEGER */ SEATING_CAPACITY;
attribute long /* INTEGER */ VOL_FRONT_DM3;
attribute long /* INTEGER */ VOL_REAR_DM3;
attribute long /* DECIMAL */ HEAD_ROOM_FRONT_CM;
attribute long /* DECIMAL */ HEAD_ROOM_REAR_CM;
attribute long /* DECIMAL */ SHOULDER_ROOM_FRONT_CM;
attribute long /* DECIMAL */ SHOULDER_ROOM_REAR_CM;
attribute long /* DECIMAL */ LEG_ROOM_FRONT_CM;
attribute long /* DECIMAL */ LEG_ROOM_REAR_CM;
attribute char BODY_TYPE;
attribute char SUSPENSION_FRONT;
attribute char SUSPENSION_REAR;
attribute char SERVICE_BRAKE;
attribute char ANTI_LOCK_BRAK_SYS;
attribute char PARKING_BRAKE;
attribute char WHEELS;
attribute char TIRES;
attribute long /* DECIMAL */ DRAG_COEFFICIENT;
attribute char STEERING;
attribute long /* DECIMAL */ TURNS_LOCK2LOCK;
attribute long /* DECIMAL */ TURNING_CIRCLE_C2C_M;
attribute char RATIO;
attribute long /* DECIMAL */ PRICE;
};

// ----- [STENE.STEERING]
interface STENE___STEERING(source relational wrDb2Volks
key (STEERING)) {
// ResultSet [Index Info]

attribute char STEERING;
};

// ----- [STENE.WEIGHTS]
interface STENE___WEIGHTS(source relational wrDb2Volks
key (NAME,COD_E,DRIVE_TRAINS,TRANS_GEAR_RATIO)
foreign_key(CAR) references STENE___CAR
foreign_key(COD_E) references STENE___ENGINE
foreign_key(DRIVE_TRAINS,TRANS_GEAR_RATIO)
references STENE___DRIVE_TRAIN) {
// ResultSet [Index Info]

attribute char NAME;
attribute char COD_E;
attribute char DRIVE_TRAINS;
attribute char TRANS_GEAR_RATIO;
attribute long /* INTEGER */ CURB_KG;
attribute long /* INTEGER */ PAYLOAD_KG;
};

Back
The MOMIS Home Page