Генерирање на податоци

./run_synthea.bat -p 250000

Креирање на табели

Креирање на база на податоци

create database HospitalSyntheaDB
on primary
(name = 'HospitalSyntheaDB', filename = 'C:\Path\To\Data\HospitalSyntheaDB.mdf', size = 1024MB, filegrowth = 256MB)
log on
(name = 'HospitalSyntheaDB_log', filename = 'C:\Path\To\Data\HospitalSyntheaDB_log.ldf', size = 512MB, filegrowth = 128MB);
go

Patients табела

create table patients (
    id uniqueidentifier primary key,
    birthdate date not null,
    deathdate date null,
    ssn varchar(20) null,
    drivers varchar(50) null,
    passport varchar(50) null,
    prefix varchar(20) null,
    first varchar(100) not null,
    middle varchar(100) null,
    last varchar(100) not null,
    suffix varchar(20) null,
    maiden varchar(100) null,
    marital varchar(20) null,
    race varchar(50) not null,
    ethnicity varchar(50) not null,
    gender char(1) not null,
    birthplace varchar(200) null,
    address varchar(200) not null,
    city varchar(100) not null,
    state varchar(50) not null,
    county varchar(100) null,
    fips varchar(10) null,
    zip varchar(20) null,
    lat decimal(9,6) null,
    lon decimal(9,6) null,
    healthcare_expenses decimal(18,2) null,
    healthcare_coverage decimal(18,2) null,
    income decimal(18,2) null
);
go

Encounters табела

create table encounters (
    id uniqueidentifier primary key,
    start datetime2 not null,
    stop datetime2 null,
    patient uniqueidentifier not null,
    organization uniqueidentifier not null,
    provider uniqueidentifier not null,
    payer uniqueidentifier not null,
    encounterclass varchar(50) not null,
    code varchar(50) not null,
    description varchar(500) not null,
    base_encounter_cost decimal(18,2) not null,
    total_claim_cost decimal(18,2) not null,
    payer_coverage decimal(18,2) not null,
    reasoncode varchar(50) null,
    reasondescription varchar(500) null
);
go

Conditions табела

create table conditions (
    start date not null,
    stop date null,
    patient uniqueidentifier not null,
    encounter uniqueidentifier not null,
    system varchar(100) not null,
    code varchar(50) not null,
    description varchar(500) not null
);
go

Observations

create table observations (
    date datetime2 not null,
    patient uniqueidentifier not null,
    encounter uniqueidentifier null,
    category varchar(100) null,
    code varchar(50) not null,
    description varchar(500) not null,
    value varchar(max) not null,
    units varchar(50) null,
    type varchar(50) not null
);
go

Medications

create table medications (
    start datetime2 not null,
    stop datetime2 null,
    patient uniqueidentifier not null,
    payer uniqueidentifier not null,
    encounter uniqueidentifier not null,
    code varchar(50) not null,
    description varchar(500) not null,
    base_cost decimal(18,2) not null,
    payer_coverage decimal(18,2) not null,
    dispenses int not null,
    totalcost decimal(18,2) not null,
    reasoncode varchar(50) null,
    reasondescription varchar(500) null
);
go

Allergies

create table allergies (
    start date null,
    stop date null,
    patient uniqueidentifier not null,
    encounter uniqueidentifier null,
    code varchar(50) not null,
    system varchar(100) not null,
    description varchar(500) not null,
    type varchar(50) null,
    category varchar(50) null,
    reaction1 varchar(100) null,
    description1 varchar(500) null,
    severity1 varchar(50) null,
    reaction2 varchar(100) null,
    description2 varchar(500) null,
    severity2 varchar(50) null
);
go

Procedures

create table procedures (
    start datetime2 not null,
    stop datetime2 null,
    patient uniqueidentifier not null,
    encounter uniqueidentifier not null,
    system varchar(100) null,
    code varchar(50) not null,
    description varchar(500) not null,
    base_cost decimal(18,2) null,
    reasoncode varchar(50) null,
    reasondescription varchar(500) null
);
go

Immunizations

create table immunizations (
    date datetime2 not null,
    patient uniqueidentifier not null,
    encounter uniqueidentifier null,
    code varchar(50) not null,
    description varchar(500) not null,
    base_cost decimal(18,2) not null
);
go