Pages produced by a web-based metadata application,
which joins the database dictionary to
entity-level information entered by the analyst. See the author's web page
Table Details :: CLINIC
CLINIC
Description:
Details of a clinic
What defines a unique row:
The logical key is CLINIC_ID. Only one row with LASTEST_ROW_IND='Y' is expected for each logical key. The logical key and the INSERT_DATE consitute the database unique key.
Join to table S.PHYSICIAN on: CLINIC_ID = CLINIC_ID Join to table S.ADMISSION on: CLINIC_ID = CLINIC_ID Join to table S.LAB_RESULT on: CLINIC_ID = CLINIC_ID Join to table S.MEDICATION on: CLINIC_ID = CLINIC_ID Join to table S.TREATMENT on: CLINIC_ID = CLINIC_ID
Although I worked at the world's largest provider of dialysis services, this data model is my invention. It is a simplified model that serves as an example for the metadata application that I built. It does not describe the data model of the company.