PROVIDERS

1760 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID VARCHAR 255
CLAIMS.PROVIDER SYS_CONSTRAINT_4597a0cb-8d64-4f2a-bff1-df1105eabf9aR
CLAIMS.REFERRINGPROVIDERID SYS_CONSTRAINT_1b514eef-6d51-4e59-8004-7778a946dbaaR
CLAIMS.SUPERVISINGPROVIDERID SYS_CONSTRAINT_06aef3a8-f461-4b77-b8f7-6564a2521e22R
CLAIMS_TRANSACTIONS.PROVIDER_ID SYS_CONSTRAINT_b579a988-667d-404c-9aa6-f9f9efc91bbcR
CLAIMS_TRANSACTIONS.SUPERVISING_PROVIDER_ID SYS_CONSTRAINT_9b50a613-0087-48a5-a774-1a2914ffc590R
ENCOUNTERS.PROVIDER SYS_CONSTRAINT_571a191b-05f1-487f-8066-08c10ca615aeR
ORGANIZATION VARCHAR 255
ORGANIZATIONS.ID SYS_CONSTRAINT_8008afdf-0655-40c2-a4d2-c6ddb23848a3R
NAME VARCHAR 255 √
GENDER VARCHAR 255 √
SPECIALITY VARCHAR 255 √
ADDRESS VARCHAR 255 √
CITY VARCHAR 255 √
STATE VARCHAR 255 √
ZIP VARCHAR 255 √
LAT DOUBLE 0 √
LON DOUBLE 0 √
UTILIZATION NUMBER 38 √

Relationships

Close relationships within degrees of separation