TABLES
17
VIEWS
0
COLUMNS
248
Constraints
35
Anomalies
20
Routines
0
Database Properties
Database Type: Snowflake - 7.44.2 (driver change version: 3.0.14)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| PATIENTS | 13 | 0 | 27 | 1504 | Table | |
| PROCEDURES | 0 | 2 | 10 | 149202 | Table | |
| CLAIMS_TRANSACTIONS | 0 | 4 | 33 | 1155144 | Table | |
| MEDICATIONS | 0 | 3 | 14 | 100804 | Table | |
| CAREPLANS | 0 | 2 | 9 | 5384 | Table | |
| ALLERGIES | 0 | 2 | 16 | 1078 | Table | |
| OBSERVATIONS | 0 | 2 | 10 | 957535 | Table | |
| PAYER_TRANSITIONS | 0 | 2 | 9 | 64922 | Table | |
| SUPPLIES | 0 | 2 | 7 | 2339 | Table | |
| IMMUNIZATIONS | 0 | 2 | 7 | 21482 | Table | |
| CLAIMS | 1 | 6 | 31 | 192200 | Table | |
| CONDITIONS | 0 | 2 | 7 | 55648 | Table | |
| PROVIDERS | 6 | 1 | 12 | 1760 | Table | |
| ORGANIZATIONS | 1 | 0 | 11 | 880 | Table | |
| DEVICES | 0 | 2 | 8 | 799 | Table | |
| ENCOUNTERS | 9 | 3 | 15 | 91396 | Table | |
| PAYERS | 5 | 0 | 22 | 10 | Table |