erd review summary conversation points follow general status database model fix represented need incorporate common design standardize might cause fix rework referential integrity entirely enforced potential bad data develop snapshots global databases currently daily easily changed frequent need consider implementation decision direction global part commodity logic made rate information developed need integration rate server mkm preferably mkm need define mkm used whether index names obtain actual settlement prices curves well application development currently occurring single version database therefore issues could arise development team migrates standard needs happen relatively quickly specific issues gfd _ pipe _ meters _ snp probably need add fac _ type wh ite etc possible use validation kx functionality gas _ deal _ location _ dtl table refers facility number rather pipe meter facility number enronism company recognize pipe meter general try avoid using pipe _ cd key value needs updateable pipelines bought sold data facilities heavily dependent upon enron global facilities database current design functionality needs revisiting decision surrounding global made cp _ addr _ vw table references internal _ cp _ id contact _ type _ cd conjunction address _ id addresses specific internal _ cp _ id product _ cd deal _ nature _ cd contact _ type _ cd region _ cd need add deal nature product region ensure correct address usage since many companies align business along determinants addresses may vary counterparty mixture usage global counterparty areas indicate certain amount independence enron global counterparty system table capture commodity logic information counterparty phone numbers credit ratings etc would position cl become independent later date yet commodity logic functions subset enron networks gcp must make entries indicate usage customer enron networks obtain sap id support payment processing sap cl could become independent without functionality process changes put added data requirements within gcp start global moves commodity logic design needs revisited sure probably standardization dependence independence whether cl separates enron common data status included views utilized applications hope views filtered active status show going check concept mapping others codes processing supported anywhere tables perhaps handled isolated manner fix design internal release well external release critical hub concept look forward sitting meetings surrounding issues let know questions