Changes between Initial Version and Version 1 of About

Timestamp:

12/27/25 09:50:47 (31 hours ago)

Author:

185022

Comment:

--

About

@@ +1 @@
+= Генерирање на податоци
+
+{{{#!cmd
+./run_synthea.bat -p 250000
+}}}
+
+= Креирање на табели
+
+=== Креирање на база на податоци
+
+{{{#!sql
+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 табела
+
+{{{#!sql
+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 табела
+
+{{{#!sql
+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 табела
+
+{{{#!sql
+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
+
+{{{#!sql
+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
+
+{{{#!sql
+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
+
+{{{#!sql
+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
+
+{{{#!sql
+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
+
+{{{#!sql
+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
+}}}