Database Tables

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.
Current rows:	LATEST_ROW_IND = 'N'
Historical rows:	LATEST_ROW_IND = 'N'

Show more details

S.CLINIC in DEMODB

Column Name	Type
CLINIC_IDJoins: Join to table S.PHYSICIAN on: CLINIC_ID = CLINIC_ID Joins: Join to table S.ADMISSION on: CLINIC_ID = CLINIC_ID Joins: Join to table S.LAB_RESULT on: CLINIC_ID = CLINIC_ID Joins: Join to table S.MEDICATION on: CLINIC_ID = CLINIC_ID Joins: Join to table S.TREATMENT on: CLINIC_ID = CLINIC_ID	NUMBER(22)
CLINIC_NAME	VARCHAR2(100)
MEDICARE_NUM	VARCHAR2(50)
MEDICARE_CERTIF_DATE	DATE(7)
ESRD_NETWORK	NUMBER(22)
MEDICAID_NUM	VARCHAR2(100)
INSERT_DATE	DATE(7)
UPDATE_DATE	DATE(7)
LASTEST_ROW_IND	CHAR(1)

Show sources for CLINIC