Message-ID: <27671068.1075840465526.JavaMail.evans@thyme> Date: Tue, 23 Apr 2002 07:05:00 -0700 (PDT) From: david.miller@enron.com To: mark.fisher@enron.com Subject: Antwort: SQL Database Cc: hollis.kimbrough@enron.com, robert.grant@enron.com, jeff.marecic@enron.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bcc: hollis.kimbrough@enron.com, robert.grant@enron.com, jeff.marecic@enron.com X-From: David Miller X-To: Mark Fisher X-cc: Hollis Kimbrough, Robert Grant, Jeff Marecic, Clemens W"ste X-bcc: X-Folder: \mark fischer 7-12-02\Notes Folders\Notes inbox X-Origin: FISCHER-M X-FileName: mark fischer 7-12-02 LNotes.nsf Mark, I am certain that you have these details. Would you please forward them to Clemens and myself Thanks David ---------------------- Forwarded by David Miller/EWC/Enron on 04/23/2002 02:21 PM --------------------------- Clemens W"ste@TWTDE 04/23/2002 06:58 AM To: David Miller/EWC/Enron@ENRON cc: Hollis Kimbrough/EWC/Enron@ENRON, Robert Grant/EWC/Enron@Enron, Jeff Marecic/EWC/Enron@Enron Subject: Antwort: SQL Database Hallo David, in our actual development I suppose I need only four tables of the database: VISU_ERRDEV, VISU_STATDATA, VISU_MINANAMAIN, VISU_MINANAEXT The fields in the tables in VisuPro and in the SQL-Server are not the same. Some fields are not described. I really need an assignment from the VisuPro tables to the new tables. As example I have written some comments / questions to the following table structures. (The list is not complet, it is a subset) VISU_STATDAT: SITE_ID varchar // Source ? ID numeric // written by me, or automatically DTTM datetime PLANT_NDX numeric TIMEOFFSET numeric KW_HRS numeric // I suppose PROD field CON numeric OTT numeric SOTT numeric DTT numeric LOTT numeric WOTT numeric ESTT numeric MTT numeric RTT numeric PRODULM numeric CONULM numeric OTULM numeric SOTULM numeric DTULM numeric LOTULM numeric WOTULM numeric ESTULM numeric MTULM numeric RTULM numeric VISU_MINANAMAIN: SITE_ID varchar // Source ? ID numeric // written by me or automatically ? DTTM datetime TRBN_ROW_OTM varchar // what's this, what is to do with this field PLANT_NDX numeric KW numeric // what's this, what is to do with this field COS_PHI numeric VOLT_PHASE_A numeric VOLT_PHASE_B numeric VOLT_PHASE_C numeric CURRENT_PHASE_A numeric CURRENT_PHASE_B numeric CURRENT_PHASE_C numeric GEN_RPM numeric ROTOR_RPM numeric ACTUAL_ANGLE_BLADE_1 numeric WIND_SPEED numeric NACELLE_POSITION numeric TRAN_OIL_PRSS numeric ACTUAL_ANGLE_BLADE_2 numeric ACTUAL_ANGLE_BLADE_3 numeric SET_ANGLE_BLADE_1 numeric SET_ANGLE_COS_PH I numeric OPERATING_STATE numeric WIND_DEVIATION numeric GEN_1_TEMP numeric GEN_2_TEMP numeric BEARING_A_TEMP numeric BEARING_B_TEMP numeric TRAN_TEMP numeric AMBIENT_TEMP numeric TRAN_BEARING_A_TEMP numeric TRAN_BEARING_B_TEMP numeric TRAN_RETURN_TEMP numeric WIND_DEVIATION_ONE_SEC numeric APPARENT_KW numeric // what's this, what is to do with this field ERROR_NUMBER numeric // what's this, what is to do with this field CRE_USERID varchar // what's this, what is to do with this field CRE_DATE datetime // what's this, what is to do with this field MDFD_USERID varchar // what's this, what is to do with this field MDFD_DATE datetime // what's this, what is to do with this field DEL_FLAG varchar // what's this, what is to do with this field Best regards, Clemens W"ste ENRON Wind