Description des tables de la base de données TrackerDB


sommaire

general

ACTION_DESCRIPTION
ACTION_INPUT_DESCRIPTION
BROTHER_VERSION
CENTER_DESCRIPTION
DIAGNOSTIC_DESCRIPTION
HISTORY
HISTORYBIS
KNOWN_PROBLEM
OBJECT_ASSEMBLY
OBJECT_ASSEMBLY_DESCRIPTION
OBJECT_DESCRIPTION
POSITION_TBL
PROBLEM_DESCRIPTION
SENSOR_LOT
SENSOR_SAMPLING
SPECIFIC_ACTION
STATUS_TBL
TOOL_DESCRIPTION
TRANSFERS

   

ACTION_DESCRIPTION


ACTIONACTION_VERSIONOBJECTTYPEVERSIONOUTPUT_FORMATDESCRIPTIONCOMPOSITEUNITS
STMPROCESS1SEN1Test_center char(14), Duration_minutes float, Temp_start float, Humidity_start float, Temp_end float, Humidity_end float, v_diel_bd float, v_flat_band float, c_specific_diel float, r_poly_sheet float, r_metal_sheet float, r_pplus_sheet float, r_nplus_sheet float, r_poly_metal float, STMPROCESS_val VARCHAR(32)Measurement of process related data from STM0none , minutes, degree C, %, degree C, %, V, V, F/cm^2, Ohm/sq, Ohm/sq, Ohm/sq, Ohm/sq, Ohm

   

ACTION_INPUT_DESCRIPTION


ACTIONACTION_VERSIONOBJECTTYPEVERSIONINPUT_IDINPUT_DESCRIPTIONINPUT_VALUESSTATUSDESCRIPTION
TSCV1SEN9.2156start in V, stop in V, step_size in V, frequency in kHz, signal_amplitude in mV, V_depl_min in V, V_depl_max in V, C_tot _min in pF, C_tot_max in pF, delay_time in seconds0, 300, 5, 100, 100, 100, 250, 3, 7, 1validfixed at Vienna on June 7th, 2002

   

BROTHER_VERSION


VERSIONSAMPLING_VERSION
203

   

CENTER_DESCRIPTION


CENTERTYPEADDRESSPHONEFAXEMAILCONTACTDESCRIPTION
UNKNOWNHold disapeared pieces#END# to clean inventories#END#

   

DIAGNOSTIC_DESCRIPTION


CODEACTIONACTION_VERSIONOBJECTTYPEVERSIONDIAGNOSTIC
-2AOHGENERAL1AOHMechanical Failure

   

HISTORY


OBJECT_IDPOSITIONTRANSFER_IDCURRENT_ACTIONCURRENT_ACTION_VERSIONCENTERFAULTYSEQUENCEHISTORY_ID
30201010034052readyRegistration1CERNF2004-04-30 16:44:24.0337756

   

HISTORYBIS



   

KNOWN_PROBLEM


PROBLEM_IDOBJECT_ID
130216661706285

   

OBJECT_ASSEMBLY


OBJECT_IDOBJECTTYPEVERSIONCONTAINER_IDNUMBER_IN_CONTAINER
30210420383134SEN4.299

   

OBJECT_ASSEMBLY_DESCRIPTION


OBJECTTYPEVERSIONSUB_OBJECTSUB_OBJECT_TYPESUB_OBJECT_VERSIONSUB_OBJECT_NUMBERDESCRIPTION
TOBCR1.3.1.3ROD2.1.2.1.31

   

OBJECT_DESCRIPTION


OBJECTTYPEVERSIONDESCRIPTIONTYPE_DESCRIPTIONVERSION_DESCRIPTIONISACABLE
HYB4.2.1.22199hybrid with PAID_221.6Uold stuffF

   

POSITION_TBL


POSITION
done

   

PROBLEM_DESCRIPTION


PROBLEM_IDDESCRIPTION
5Possible weak glue bias

   

SENSOR_LOT


LOT_IDBATCH_ID
3302112329121

   

SENSOR_SAMPLING


SET_IDBATCH_IDQTC_DESCRIPTIONPQC_DESCRIPTIONPNIRR_DESCRIPTIONBONDING_DESCRIPTIONLTV_DESCRIPTION
VIE57302113337109

   

SPECIFIC_ACTION


NAME
Registration

   

STATUS_TBL


STATUS
notvalid

   

TOOL_DESCRIPTION


TOOLTOOL_IDCENTEROPERATION_TYPEDESCRIPTION
sensor sampling511PERUGIAsampling

   

TRANSFERS


TRANSFER_IDRECEIVERCARRIERSENDERISSUED_ATARRIVED_ATDESCRIPTION
30299991000523KARLSRUHE-IEKPCOURIERCERN2003-04-11 10:02:13.02003-04-17 11:37:52.0Shipping request no. 1242428


07/07/05 09:44:37