text:
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `AndreProsedyrerVar`;
CREATE TABLE `AndreProsedyrerVar` (
  `ForlopsID` int(9) NOT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `Regtype` varchar(8) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreDato` date DEFAULT NULL,
  `ProsedyreTid` time DEFAULT NULL,
  `ProsedyreTidUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenProsType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AndreProsOperatorer` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `Komplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LettAllergi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ModeratAllergi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Arytmi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HemodynKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NeuroKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `VaskulKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Perforasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Tamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AkuttACB` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenAlvorligKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Dod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsRelatertDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SkjemaStatus` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`),
  KEY `idx_AndreProsedyrerVar` (`AvdRESH`,`ProsedyreDato`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `AngioPCI`;
CREATE TABLE `AngioPCI` (
  `LabNummer` tinyint(3) DEFAULT NULL,
  `ForlopsID` bigint(19) NOT NULL DEFAULT '0',
  `PasientID` bigint(19) NOT NULL DEFAULT '0',
  `PrimaerForlopsID` bigint(19) DEFAULT NULL,
  `ProsedyreDato` date DEFAULT NULL,
  `ProsedyreType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HendelsesType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kjonn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FodselsDato` date DEFAULT NULL,
  `Avdod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdodDato` date DEFAULT NULL,
  `PasientRegDato` date DEFAULT NULL,
  `SymptomDato` date DEFAULT NULL,
  `SymptomTidspunkt` time DEFAULT NULL,
  `BesUtlEKGDato` date DEFAULT NULL,
  `BesUtlEKGTid` time DEFAULT NULL,
  `Vakttid` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hoyde` smallint(5) DEFAULT NULL,
  `Vekt` smallint(5) DEFAULT NULL,
  `SKreatinin` smallint(5) DEFAULT NULL,
  `TidlPCI` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlABC` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `RoykeStatus` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BehHypertoni` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LipidSenkende` bit(1) DEFAULT NULL,
  `TidlInfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KjentNedsattVenstVentr` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Diabetes` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Insulin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PeriferKarsykdom` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Indikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StegvisProsedyre` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CanadianClass` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NYHA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KardiogentSjokk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KillipKlasse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Funn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnkomstPCIDato` date DEFAULT NULL,
  `AnkomstPCITid` time DEFAULT NULL,
  `Stikksted` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StenoseTidlBehSegment` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StenoseACBGraft` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Stresskardiomyopati` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PrimarBeslutning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BareDiag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FFR` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Doppler` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenDiag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `IVUS` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OCT` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AdjuvantTerapi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aortaballongpumpe` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Pacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `MekKompr` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenAdj` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenVenstreKammerAssist` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DatoForApningKar` date DEFAULT NULL,
  `TidsPunktForApningKar` time DEFAULT NULL,
  `UkjentTidsPunktForApningKar` tinyint(3) DEFAULT NULL,
  `KarAapentVedAngio` tinyint(3) DEFAULT NULL,
  `KarIkkeAapnet` tinyint(3) DEFAULT NULL,
  `Straledose` bigint(19) DEFAULT NULL,
  `GjenLysTidSek` int(10) DEFAULT NULL,
  `Kontrastmiddel` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KontrastMengdeMl` smallint(5) DEFAULT NULL,
  `AnnKonMidUndersokelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ArteriellLukning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabAllergiskLettModerat` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabAllergiskAlvorlig` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BehandlingskrevendeArytmi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HemodynamiskKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabNeurologiskKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `VaskulaerIkkeKoronar` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `MistetStent` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `VedvarendeSidegrensokklusjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Perforasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabTamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AkuttACBOperasjonFraLab` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LAbAnnenAlvorligKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabProsedyrerelatertDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AngioOperatorer` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `InnleggelsesdatoDetteSykehus` bit(1) DEFAULT NULL,
  `OverflyttetFra` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OverflyttetFraSykehus` varchar(75) COLLATE utf8_danish_ci DEFAULT NULL,
  `DatoInnleggelseIHenvisendeSykehus` date DEFAULT NULL,
  `EKGRytme` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EKGQRS` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `VenstreGrenblokk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EKGSTT` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BeslutningsutlosendeEKG` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hjertefrekvens` smallint(5) DEFAULT NULL,
  `SystoliskBlodtrykk` smallint(5) DEFAULT NULL,
  `DiastoliskBlodtrykk` smallint(5) DEFAULT NULL,
  `KardiogentSjokkVedAnkomst` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Innkomstarsak` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HLRForSykehus` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `GittTrombolyse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TrombolyseMedikament` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TrombolyseTidspunkt` date DEFAULT NULL,
  `AngiTidpunktDaTrombolysebehandlingenBlePabegynt` time DEFAULT NULL,
  `TidligereHjerteinfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidligerePCI` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidligereACBOperasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenTidligereHjertekirurgiIkkePacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hypertoni` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidligereHjerneslagIkkeTIA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SGlukose` decimal(4,2) DEFAULT NULL,
  `Infarktmarkoer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InfarktMarkoerMax` decimal(8,3) DEFAULT NULL,
  `Kolesterol` decimal(4,2) DEFAULT NULL,
  `CRP` decimal(5,1) DEFAULT NULL,
  `HbA1c` decimal(4,1) DEFAULT NULL,
  `HDL` decimal(3,2) DEFAULT NULL,
  `Hemoglobin` decimal(3,1) DEFAULT NULL,
  `MaaltLDL` decimal(4,2) DEFAULT NULL,
  `Kreatinin` int(10) DEFAULT NULL,
  `Triglycerider` decimal(4,2) DEFAULT NULL,
  `SEGMENT1` tinyint(3) DEFAULT NULL,
  `SEGMENT2` tinyint(3) DEFAULT NULL,
  `SEGMENT3` tinyint(3) DEFAULT NULL,
  `SEGMENT4` tinyint(3) DEFAULT NULL,
  `SEGMENT5` tinyint(3) DEFAULT NULL,
  `SEGMENT6` tinyint(3) DEFAULT NULL,
  `SEGMENT7` tinyint(3) DEFAULT NULL,
  `SEGMENT8` tinyint(3) DEFAULT NULL,
  `SEGMENT9` tinyint(3) DEFAULT NULL,
  `SEGMENT10` tinyint(3) DEFAULT NULL,
  `SEGMENT11` tinyint(3) DEFAULT NULL,
  `SEGMENT12` tinyint(3) DEFAULT NULL,
  `SEGMENT13` tinyint(3) DEFAULT NULL,
  `SEGMENT14` tinyint(3) DEFAULT NULL,
  `SEGMENT15` tinyint(3) DEFAULT NULL,
  `SEGMENT16` tinyint(3) DEFAULT NULL,
  `SEGMENT17` tinyint(3) DEFAULT NULL,
  `SEGMENT18` tinyint(3) DEFAULT NULL,
  `SEGMENT19` tinyint(3) DEFAULT NULL,
  `SEGMENT20` tinyint(3) DEFAULT NULL,
  `Myokardskademarkor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `STSegmentSenkning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SekundaerBeslutning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DistalProtectionDevice` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Trombectomy` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `GenereltSuksess` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KomplettRevaskularisering` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PCIOperatorer` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `Komplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AllergiskSenkomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NoenFormForBlodning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BlodningMajor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BlodningMinor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BehandlingskrevendePseudoaneurysme` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HematomFemCmDiam` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HbFall` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ForlengetKompresjonstid` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ForlengetOpphold` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UltralydsundersokelseCT` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Blodtransfusjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KirurgiskBehandling` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenBehandlingUtoverKompresjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidUtsettAvAntitrombotiskBeh` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdVaskulaerIkkeKoronar` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdNeurologiskKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NytilkommetNyreinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdTamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KomplikasjonRePCI` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ACBOperasjonKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hjerteinfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdAnnenAlvorligKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdelingsDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdelingsProsedyrerelatertDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ACEHemmere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `A2Blokkerre` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Antikoagulantia` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ASA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AndrePlatehemmere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Betablokkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CaBlokkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DiabetesBehandlingInsulin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DiabetesBehandlingPerOral` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Digitalis` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Diuretika` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aldosteronantagonister` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Statiner` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OvrigeLipidsenkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NitroglycerinLangtidsvirkende` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtskrevetDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtskrevetDodsdato` date DEFAULT NULL,
  `AnnenAlvorligSykdom` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Infarkttype` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SubklassifiseringAvHjerteinfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Utskrivningsdato` date DEFAULT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci NOT NULL,
  `Sykehusnavn` varchar(100) COLLATE utf8_danish_ci NOT NULL,
  PRIMARY KEY (`ForlopsID`,`AvdRESH`),
  KEY `ForlopsID` (`ForlopsID`,`AvdRESH`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `AngioPCIVar`;
CREATE TABLE `AngioPCIVar` (
  `ForlopsID` int(9) NOT NULL,
  `PrimaerForlopsID` int(10) unsigned DEFAULT NULL,
  `PasientID` int(10) unsigned DEFAULT NULL,
  `Regtype` varchar(8) COLLATE utf8_danish_ci DEFAULT NULL,
  `Lokalsykehus` varchar(75) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreDato` date DEFAULT NULL,
  `ProsedyreTid` time DEFAULT NULL,
  `ProsedyreTidUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hastegrad` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kjonn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FodselsDato` date DEFAULT NULL,
  `Avdod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdodDato` date DEFAULT NULL,
  `PasientRegDato` date DEFAULT NULL,
  `Studie` varchar(75) COLLATE utf8_danish_ci DEFAULT NULL,
  `SymptomDato` date DEFAULT NULL,
  `SymptomTid` time DEFAULT NULL,
  `BesUtlEKGDato` date DEFAULT NULL,
  `BesUtlEKGTid` time DEFAULT NULL,
  `BesUtlEKGTidUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Vakttid` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hoyde` smallint(6) DEFAULT NULL,
  `Vekt` smallint(6) DEFAULT NULL,
  `SKreatinin` smallint(6) DEFAULT NULL,
  `TidlPCI` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlABC` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `RoykeStatus` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BehHypertoni` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Statiner` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlInfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KjentNedsattVenstVentr` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Diabetes` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Insulin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidligereSlag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PeriferKarsykdom` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Indikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Myokardskademarkor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `STSegmentSenkning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StegvisProsedyre` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CanadianClass` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NYHA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KardiogentSjokk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KillipKlasse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Funn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnkomstPCIDato` date DEFAULT NULL,
  `AnkomstPCITid` time DEFAULT NULL,
  `AnkomstPCITidUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Stikksted` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StenoseTidlBehSegment` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StenoseACBGraft` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Stresskardiomyopati` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PrimarBeslutning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BareDiag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FFR` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Doppler` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `IVUS` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OCT` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `IFR` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NIRS` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenDiag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Tilleggsprosedyrer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HoyreHjerteKat` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Ventilfilming` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Perikardiocentese` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AdjuvantTerapi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aortaballongpumpe` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Impella` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ECMO` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenVenstreKammerAssist` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `MekKompr` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DistalProtectionDevice` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Pacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Trombectomy` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PTAHalskar` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PTSMA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenAdj` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ApningKarDato` date DEFAULT NULL,
  `ApningKarTid` time DEFAULT NULL,
  `ApningKarTidUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `KarAapentVedAngio` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `KarIkkeAapnet` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `GenereltSuksess` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabNummer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Straledose` bigint(20) DEFAULT NULL,
  `GjenLysTidSek` int(11) DEFAULT NULL,
  `Kontrastmiddel` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KontrastMengdeMl` smallint(6) DEFAULT NULL,
  `AnnKonMidUndersokelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ArteriellLukning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAllergiskLettModerat` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAllergiskAlvorlig` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompBehkrevendeArytmi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompHemodynamisk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompNeurologisk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompVaskulaerIkkeKoronar` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompMistetStent` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompVedvarSidegrensokkl` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompPerforasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompTamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAkuttACBOperasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAnnenAlv` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompProsedyrerelatertDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OverflyttetFra` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OverflyttetFraSykehus` varchar(75) COLLATE utf8_danish_ci DEFAULT NULL,
  `InnleggelseHenvisendeSykehusDato` date DEFAULT NULL,
  `InnleggelseHenvisendeSykehusDatoUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `InnleggelseHenvisendeSykehusTid` time DEFAULT NULL,
  `InnleggelseHenvisendeSykehusTidUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Innkomstarsak` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SymptomdebutDato` date DEFAULT NULL,
  `SymptomdebutTid` time DEFAULT NULL,
  `HLRForSykehus` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EKGRytme` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EKGQRS` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EKGSTT` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `VenstreGrenblokk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BeslutningsutlosendeEKG` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BeslEKGDato` date DEFAULT NULL,
  `BeslEKGTid` time DEFAULT NULL,
  `BeslEKGUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hjertefrekvens` smallint(6) DEFAULT NULL,
  `SystoliskBlodtrykk` smallint(6) DEFAULT NULL,
  `DiastoliskBlodtrykk` smallint(6) DEFAULT NULL,
  `KillipKlasseAnkomst` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KardiogentSjokkAnkomst` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `GittTrombolyse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TrombolyseMedikament` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TrombolyseDato` date DEFAULT NULL,
  `TrombolyseTid` time DEFAULT NULL,
  `TrombolyseUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidligereACBOp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenTidlKirurgi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hypertoni` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitASA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitAntikoagulantia` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitAndrePlatehemmere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitStatiner` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitNSAID` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitACEHemmere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitA2Blokkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitBetaBlokkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitCaHemmere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitDiabetesPrOral` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitDigitalis` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitDiuretika` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitAldosteronantagonist` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitOvrigLipid` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InitNitroglycerin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Infarktmarkoer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InfarktMarkoerMax` decimal(8,3) DEFAULT NULL,
  `Kolesterol` decimal(4,2) DEFAULT NULL,
  `Triglycerider` decimal(4,2) DEFAULT NULL,
  `HDL` decimal(3,2) DEFAULT NULL,
  `MaaltLDL` decimal(4,2) DEFAULT NULL,
  `SGlukose` decimal(4,2) DEFAULT NULL,
  `HbA1c` decimal(4,1) DEFAULT NULL,
  `Kreatinin` mediumint(9) DEFAULT NULL,
  `CRP` decimal(5,1) DEFAULT NULL,
  `Hemoglobin` decimal(3,1) DEFAULT NULL,
  `SEGMENT1` tinyint(3) DEFAULT NULL,
  `SEGMENT2` tinyint(3) DEFAULT NULL,
  `SEGMENT3` tinyint(3) DEFAULT NULL,
  `SEGMENT4` tinyint(3) DEFAULT NULL,
  `SEGMENT5` tinyint(3) DEFAULT NULL,
  `SEGMENT6` tinyint(3) DEFAULT NULL,
  `SEGMENT7` tinyint(3) DEFAULT NULL,
  `SEGMENT8` tinyint(3) DEFAULT NULL,
  `SEGMENT9` tinyint(3) DEFAULT NULL,
  `SEGMENT10` tinyint(3) DEFAULT NULL,
  `SEGMENT11` tinyint(3) DEFAULT NULL,
  `SEGMENT12` tinyint(3) DEFAULT NULL,
  `SEGMENT13` tinyint(3) DEFAULT NULL,
  `SEGMENT14` tinyint(3) DEFAULT NULL,
  `SEGMENT15` tinyint(3) DEFAULT NULL,
  `SEGMENT16` tinyint(3) DEFAULT NULL,
  `SEGMENT17` tinyint(3) DEFAULT NULL,
  `SEGMENT18` tinyint(3) DEFAULT NULL,
  `SEGMENT19` tinyint(3) DEFAULT NULL,
  `SEGMENT20` tinyint(3) DEFAULT NULL,
  `SEGMENT1VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT2VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT3VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT4VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT5VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT6VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT7VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT8VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT9VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT10VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT11VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT12VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT13VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT14VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT15VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT16VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT17VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT18VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT19VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT20VeneStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT1ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT2ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT3ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT4ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT5ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT6ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT7ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT8ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT9ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT10ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT11ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT12ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT13ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT14ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT15ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT16ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT17ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT18ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT19ArterieStenosgrad` int(11) DEFAULT NULL,
  `SEGMENT20ArterieStenosgrad` int(11) DEFAULT NULL,
  `SekundaerBeslutning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KomplettRevaskularisering` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AntitrombotiskFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TrombolyseFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ASAFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ClopidogrelFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PrasugrelFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TicagrelorFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HeparinFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DalteparinFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EnoxaparinFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnetLavmolHeparinFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BivalirudinFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FondaparinuxFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AbciximabFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EptifibatidFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TirofibanFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `WarfarinFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DabigatranFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ApiksabanFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `RivaroksabanFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EdoksabanFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KangrelorFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnetAntitrombotiskFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AntitrombotiskUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TrombolyseUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ASAUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ClopidogrelUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PrasugrelUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TicagrelorUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HeparinUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DalteparinUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EnoxaparinUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnetLavmolHeparinUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BivalirudinUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FondaparinuxUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AbciximabUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EptifibatidUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TirofibanUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `WarfarinUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KangrelorUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnetAntitrombotiskUnder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PCIHovedOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `PCIAndreOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `PCITredjeOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Angiografor1` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Angiografor2` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Angiografor3` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `PCIOperatorer` varchar(300) COLLATE utf8_danish_ci DEFAULT NULL,
  `AngioOperatorer` varchar(300) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompAllergisk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompBlodning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompBlodningMajor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompBlodningMinor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompPseudoaneurysme` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHematomStor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHbFallStor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompForlengetTidStor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompForlengetOppholdStor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompUltralydCT` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompBlodtransfusjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompKirurgiskBeh` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompAnnenBehUtoverKompresjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompTidligUtsettelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompVaskulaer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompNeurologiskKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompNyNyreinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompTamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompPCI` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompACB` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHjerteinfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompAnnenAlvorlig` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompProsedyrerelatertDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CKMBFor` mediumint(9) DEFAULT NULL,
  `CKMBEtter` mediumint(9) DEFAULT NULL,
  `TroponinMetFor` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TroponinVerdiFor` int(11) DEFAULT NULL,
  `TroponinMetEtter` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TroponinVerdiEtter` int(11) DEFAULT NULL,
  `Utskrivningsdato` date DEFAULT NULL,
  `UtskrevetDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtskrevetDodsdato` date DEFAULT NULL,
  `ASA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Antikoagulantia` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AndrePlatehemmere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtskrStatiner` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NSAID` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ACEHemmere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `A2Blokkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Betablokkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CaBlokkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DiabetesBehandlingInsulin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DiabetesBehandlingPerOral` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Digitalis` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Diuretika` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aldosteronantagonister` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OvrigeLipidsenkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NitroglycerinLangtid` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenAlvorligSykdom` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InfarktType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InfarktSubklasse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtskrDiagnoser` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
  `Sykehusnavn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SkjemaStatusStart` tinyint(3) DEFAULT NULL,
  `SkjemastatusHovedskjema` tinyint(3) DEFAULT NULL,
  `SkjemaStatusUtskrivelse` tinyint(3) DEFAULT NULL,
  `SkjemaStatusKomplikasjoner` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`),
  KEY `idx_AngioPCIVar` (`AvdRESH`,`ProsedyreDato`,`ProsedyreType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `AnnenDiagnostikkVar`;
CREATE TABLE `AnnenDiagnostikkVar` (
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `Sykehusnavn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PasientKjonn` varchar(13) COLLATE utf8_danish_ci DEFAULT NULL,
  `FodselsDato` date DEFAULT NULL,
  `ForlopsID` int(9) NOT NULL,
  `Regtype` varchar(8) COLLATE utf8_danish_ci DEFAULT NULL,
  `Angiografor1` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Angiografor2` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Angiografor3` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Indikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreDato` date DEFAULT NULL,
  `Hoyde` smallint(6) DEFAULT NULL,
  `Vekt` smallint(6) DEFAULT NULL,
  `segment` varchar(100) COLLATE utf8_danish_ci NOT NULL,
  `graft` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `metode` varchar(100) COLLATE utf8_danish_ci NOT NULL,
  `FfrFoer` decimal(5,2) DEFAULT NULL,
  `FfrEtter` decimal(5,2) DEFAULT NULL,
  `IfrFoer` decimal(5,2) DEFAULT NULL,
  `IfrEtter` decimal(5,2) DEFAULT NULL,
  `CsaFoer` decimal(5,1) DEFAULT NULL,
  `CsaEtter` decimal(5,1) DEFAULT NULL,
  `MldFoer` decimal(5,1) DEFAULT NULL,
  `MldEtter` decimal(5,1) DEFAULT NULL,
  `MlaFoer` decimal(5,2) DEFAULT NULL,
  `MlaEtter` decimal(5,2) DEFAULT NULL,
  `MxlcbiFoer` int(10) unsigned DEFAULT NULL,
  `MxlcbiEtter` int(10) unsigned DEFAULT NULL,
  `CfrFoer` tinyint(3) unsigned DEFAULT NULL,
  `CfrEtter` tinyint(3) unsigned DEFAULT NULL,
  `ImrFoer` tinyint(3) unsigned DEFAULT NULL,
  `ImrAfter` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`,`segment`,`metode`),
  KEY `idx_AnnenDiagnostikkVar` (`AvdRESH`,`ProsedyreDato`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `AortaklaffOppfVar`;
CREATE TABLE `AortaklaffOppfVar` (
  `ForlopsID` int(9) NOT NULL,
  `BasisForlopsID` int(10) unsigned DEFAULT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `BasisScreeningBeslutning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BasisBeslutningsDato` date DEFAULT NULL,
  `BasisProsedyreDato` date DEFAULT NULL,
  `OppfDato` date DEFAULT NULL,
  `OppfType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OppfAvdod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OppfAvdodDato` date DEFAULT NULL,
  `OppfDodProsRelatert` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hoyde` smallint(6) DEFAULT NULL,
  `HoydeUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Vekt` smallint(6) DEFAULT NULL,
  `VektUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `NYHA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CanadianClass` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Gangtest` smallint(6) DEFAULT NULL,
  `GangtestIkkeUtfort` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `SKreatinin` mediumint(9) DEFAULT NULL,
  `SKreatininIkkeUtfort` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProBNP` mediumint(9) DEFAULT NULL,
  `Hemoglobin` decimal(3,1) DEFAULT NULL,
  `HemoglobinUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `MaxGradient` smallint(6) DEFAULT NULL,
  `MaxGradientMPS` decimal(2,1) DEFAULT NULL,
  `Middelgradient` smallint(6) DEFAULT NULL,
  `VenstreVentrikkelFunksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PulmonalHypertensjon` tinyint(3) DEFAULT NULL,
  `Aortainsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ParavalvularLekkasje` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Mitralinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Mobilitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hygiene` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aktiviteter` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SmerterUbehag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AngstDepresjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Helsetilstand` smallint(6) DEFAULT NULL,
  `Komplikasjoner` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Endokarditt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Dialyse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hjerteinfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hjerneslag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Pacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProteseDysfunk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SenKarKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SkjemaStatus` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`),
  KEY `idx_AortaklaffOppfVar` (`ForlopsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `AortaklaffVar`;
CREATE TABLE `AortaklaffVar` (
  `ForlopsID` int(9) NOT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `ScreeningBeslutning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Indikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BeslutningsDato` date DEFAULT NULL,
  `ProsedyreDato` date DEFAULT NULL,
  `AkuttOperasjon` tinyint(3) DEFAULT NULL,
  `Studie` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hoyde` smallint(6) DEFAULT NULL,
  `HoydeUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Vekt` smallint(6) DEFAULT NULL,
  `VektUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Royker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SKreatininFoer` smallint(6) DEFAULT NULL,
  `SKreatininIkkeUtfort` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProBNPFoer` mediumint(9) DEFAULT NULL,
  `HemoglobinFoer` decimal(3,1) DEFAULT NULL,
  `BehHypertoni` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Diabetes` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Insulin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Atrieflimmer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InfarktSiste90d` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlHjerteoperasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlACB` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlAVR` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlMitralplastikk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlMVR` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlAnnet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlPCI` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlHjerneslag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Pacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KOLS` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PeriferKarsykdom` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenAlvorligSykdom` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NYHAKlasse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CanadianClass` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Frailty` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `RedusertMobilitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Gangtest` smallint(6) DEFAULT NULL,
  `GangtestIkkeUtfort` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Gripestyrke` smallint(6) DEFAULT NULL,
  `DialyseFoerOp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KritiskPreopTilstand` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hastegrad` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PerkKlaffPgaRisiko` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PerkKlaffPgaRisikoAlder` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PerkKlaffPgaRisikoSpiro` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PerkKlaffPgaRisikoACB` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PerkKlaffPgaRisikoSpesiell` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Porselenaorta` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Malignitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UgunstigAnatomi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Steroidbehandling` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Stralebehandling` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Thoraxdeformitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenAlvorligSykdomKirRisiko` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PerkKlaffPgaPasient` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Mobilitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hygiene` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aktiviteter` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SmerterUbehag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AngstDepresjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Helsetilstand` smallint(6) DEFAULT NULL,
  `Klaffeareal` decimal(3,2) DEFAULT NULL,
  `KlaffearealIkkeBeregnet` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `KorrigertKlaffeareal` decimal(3,2) DEFAULT NULL,
  `PreMaxgradient` smallint(6) DEFAULT NULL,
  `PreMaxHastighet` decimal(3,2) DEFAULT NULL,
  `PreMaxHastMangler` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreMiddelgradient` smallint(6) DEFAULT NULL,
  `PreVenstreVentrikkelFunksjon2011` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreVenstreVentrikkelFunksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PulmonalHypertensjon` tinyint(3) DEFAULT NULL,
  `PreAortainsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreMitralisinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ErCTForetatt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnulusdiameterVedCT` tinyint(3) DEFAULT NULL,
  `AnnulusAreal` decimal(3,2) DEFAULT NULL,
  `AnnulusPerimeter` decimal(4,2) DEFAULT NULL,
  `Aortaforkalk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TypeKlaff` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `STSScore` tinyint(3) DEFAULT NULL,
  `HovedOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `AndreOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `TredjeOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Operatorer` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `Punksjonstid` time DEFAULT NULL,
  `Avslutningstid` time DEFAULT NULL,
  `Mitralisinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OperativTilgang` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KlaffIKlaff` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TypeKlaffeprotese` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProteseStr` tinyint(3) DEFAULT NULL,
  `Predilatasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PredilBallongStr` tinyint(3) DEFAULT NULL,
  `Postdilatasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostdilBallongStr` tinyint(3) DEFAULT NULL,
  `ProtectionDevice` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Karlukning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `RapidPacing` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Anestesi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `VellykketProsedyre` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Labnr` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Straaledose` decimal(8,2) DEFAULT NULL,
  `GjennomLysTid` int(11) DEFAULT NULL,
  `Kontrastmiddel` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kontrastmengde` smallint(6) DEFAULT NULL,
  `LabKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompArytmi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompNeurologi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompTamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompVaskular` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompBlodning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAkuttKlaff` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAkuttVaskular` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompOkklusjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAnestesi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompHLMaskin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompProtese` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompEmboli` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAnnenKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Dodsdato` date DEFAULT NULL,
  `AvdKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHjerneslag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHjerneslagGrad` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompTIA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompTamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompPacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompAtrieflimmer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHjerteinfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompVaskular` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompBlodning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompBlodningGrad` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompInfeksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompDialyse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompAnnenKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostUndersokelseForetatt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostMaxgradient` smallint(6) DEFAULT NULL,
  `PostMaxHastighet` decimal(2,1) DEFAULT NULL,
  `PostMiddelgradient` smallint(6) DEFAULT NULL,
  `PostVenstreVentrikkelFunksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostPulmonalHypertensjon` tinyint(3) DEFAULT NULL,
  `PostAortainsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ParavalvularLekkasje` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostMitralisinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtskrKreatinin` smallint(6) DEFAULT NULL,
  `UtskrKreatininIkkeUtfort` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtskrDato` date DEFAULT NULL,
  `UtskrevetTil` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ASAVedUtskrivelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AntikoagulantiaVedUtskrivelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AndrePlatehemmereVedUtskrivelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SkjemaStatus` int(11) DEFAULT NULL,
  `SkjemaStatusHovedskjema` tinyint(3) DEFAULT NULL,
  `SkjemaStatusKomplUtsk` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`),
  KEY `idx_AortaklaffVar` (`AvdRESH`,`ProsedyreDato`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `CTAngioVar`;
CREATE TABLE `CTAngioVar` (
  `ForlopsID` int(9) NOT NULL,
  `PasientID` int(10) unsigned DEFAULT NULL,
  `Lokalsykehus` varchar(75) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kjonn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FodselsDato` date DEFAULT NULL,
  `Avdod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdodDato` date DEFAULT NULL,
  `PasientRegDato` date DEFAULT NULL,
  `Studie` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `UndersokDato` date DEFAULT NULL,
  `Hoyde` smallint(6) DEFAULT NULL,
  `Vekt` smallint(6) DEFAULT NULL,
  `SKreatinin` smallint(6) DEFAULT NULL,
  `TidligerePCI` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidligereACB` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Diabetes` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Insulin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `RoykingFoer2009` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Royking` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hypertoni` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Lipidsenkende` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidligereInfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Granskere` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `Indikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ViktigsteSymptomer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SluttForKontrast` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HoyCalciumScore` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SluttForKontrastAndreGrunner` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StenoseOkklusjonABC` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CalciumScore` smallint(6) DEFAULT NULL,
  `KoronarundersokelseUtfort` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Konklusiv` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StenoseOkklusjonTidligere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Funn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FunnConcat` varchar(400) COLLATE utf8_danish_ci DEFAULT NULL,
  `SEGMENT1` tinyint(3) DEFAULT NULL,
  `SEGMENT2` tinyint(3) DEFAULT NULL,
  `SEGMENT3` tinyint(3) DEFAULT NULL,
  `SEGMENT4` tinyint(3) DEFAULT NULL,
  `SEGMENT5` tinyint(3) DEFAULT NULL,
  `SEGMENT6` tinyint(3) DEFAULT NULL,
  `SEGMENT7` tinyint(3) DEFAULT NULL,
  `SEGMENT8` tinyint(3) DEFAULT NULL,
  `SEGMENT9` tinyint(3) DEFAULT NULL,
  `SEGMENT10` tinyint(3) DEFAULT NULL,
  `SEGMENT11` tinyint(3) DEFAULT NULL,
  `SEGMENT12` tinyint(3) DEFAULT NULL,
  `SEGMENT13` tinyint(3) DEFAULT NULL,
  `SEGMENT14` tinyint(3) DEFAULT NULL,
  `SEGMENT15` tinyint(3) DEFAULT NULL,
  `SEGMENT16` tinyint(3) DEFAULT NULL,
  `SEGMENT17` tinyint(3) DEFAULT NULL,
  `SEGMENT18` tinyint(3) DEFAULT NULL,
  `SEGMENT19` tinyint(3) DEFAULT NULL,
  `SEGMENT20` tinyint(3) DEFAULT NULL,
  `Myokardmasse` smallint(6) DEFAULT NULL,
  `KoronarAnomali` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `FunksjonsUndersokelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `EndediastoliskVolum` smallint(6) DEFAULT NULL,
  `EndesystoliskVolum` smallint(6) DEFAULT NULL,
  `EjeksjonsFraksjon` tinyint(3) DEFAULT NULL,
  `HjerteminuttVolum` decimal(3,1) DEFAULT NULL,
  `VidereUtredning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CTAngioMedikamenter` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Betablokkere` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Nitroglycerin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnetAdjuvant` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `CTTeknikk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProspektivEKG` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DLP` mediumint(9) DEFAULT NULL,
  `Kontrastmiddel` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KontrastmiddelMengde` smallint(6) DEFAULT NULL,
  `Komplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LettAllergisk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AlvorligAllergisk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hemodynamisk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SkjemaStatus` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`),
  KEY `idx_CTAngioVar` (`AvdRESH`,`PasientRegDato`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `ForlopsOversikt`;
CREATE TABLE `ForlopsOversikt` (
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `Sykehusnavn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PasientID` int(10) unsigned DEFAULT NULL,
  `Postnr` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostSted` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kommune` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
  `KommuneNr` varchar(4) COLLATE utf8_danish_ci DEFAULT NULL,
  `Fylke` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
  `Fylkenr` varchar(2) COLLATE utf8_danish_ci DEFAULT NULL,
  `KryptertFnr` char(64) COLLATE utf8_danish_ci DEFAULT NULL,
  `PasientKjonn` varchar(11) COLLATE utf8_danish_ci DEFAULT NULL,
  `erMann` varchar(1) COLLATE utf8_danish_ci DEFAULT NULL,
  `PasientAlder` bigint(20) DEFAULT NULL,
  `FodselsDato` date DEFAULT NULL,
  `Norsktalende` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Sivilstatus` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtdanningSSB` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
  `Avdod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdodDato` date DEFAULT NULL,
  `ForlopsID` int(9) NOT NULL,
  `BasisRegStatus` tinyint(3) DEFAULT NULL,
  `ForlopsType1` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ForlopsType1Num` tinyint(3) DEFAULT NULL,
  `ForlopsType2` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ForlopsType2Num` tinyint(3) DEFAULT NULL,
  `KobletForlopsID` int(10) unsigned DEFAULT NULL,
  `HovedDato` date DEFAULT NULL,
  `OppflgRegStatus` varchar(2) COLLATE utf8_danish_ci DEFAULT NULL,
  `ErOppflg` varchar(1) COLLATE utf8_danish_ci DEFAULT NULL,
  `OppflgStatus` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `OppflgSekNr` varchar(6) COLLATE utf8_danish_ci DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`),
  KEY `idx_ForlopsOversikt` (`AvdRESH`,`HovedDato`,`BasisRegStatus`,`Sykehusnavn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `MitralklaffOppfVar`;
CREATE TABLE `MitralklaffOppfVar` (
  `ForlopsID` int(9) NOT NULL,
  `BasisForlopsID` int(10) unsigned DEFAULT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `BasisScreeningBeslutning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BasisProsedyreDato` date DEFAULT NULL,
  `OppfDato` date DEFAULT NULL,
  `OppfType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OppfAvdod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `OppfAvdodDato` date DEFAULT NULL,
  `OppfDodProsRelatert` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hoyde` smallint(6) DEFAULT NULL,
  `HoydeUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Vekt` smallint(6) DEFAULT NULL,
  `VektUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `NYHA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Gangtest` smallint(6) DEFAULT NULL,
  `GangtestIkkeUtfort` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kreatinin` smallint(6) DEFAULT NULL,
  `KreatininUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProBNP` mediumint(9) DEFAULT NULL,
  `ProlapsA1` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProlapsA2` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProlapsA3` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProlapsP1` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProlapsP2` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProlapsP3` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `VenstreVentrikkelFunksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aortainsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aortastenose` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Tricuspidal` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Mitralinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Mitralstenose` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `MaxHastighet` tinyint(3) DEFAULT NULL,
  `MiddelgradientMPS` tinyint(3) DEFAULT NULL,
  `Middelgradient` smallint(6) DEFAULT NULL,
  `MRPISA` tinyint(3) DEFAULT NULL,
  `MREROA` smallint(6) DEFAULT NULL,
  `VContracta` decimal(2,1) DEFAULT NULL,
  `FlowRevers` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `HoyreVentrikkelTrykk` smallint(6) DEFAULT NULL,
  `HoyreVentrikkelTrykkUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Mobilitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hygiene` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aktiviteter` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SmerterUbehag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AngstDepresjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Helsetilstand` smallint(6) DEFAULT NULL,
  `Komplikasjoner` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hjerneslag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TIA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Tamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Pacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Atrieflimmer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hjerteinfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Vaskular` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Blodning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Infeksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Dialyse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `DeviceRelKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AnnenKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SkjemaStatus` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`),
  KEY `idx_MitralklaffOppfVar` (`AvdRESH`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `MitralklaffVar`;
CREATE TABLE `MitralklaffVar` (
  `ForlopsID` int(9) NOT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `ScreeningBeslutning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreDato` date DEFAULT NULL,
  `BesteBehandling` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Studie` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hoyde` smallint(6) DEFAULT NULL,
  `HoydeUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Vekt` smallint(6) DEFAULT NULL,
  `VektUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Royker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KreatininFoer` smallint(6) DEFAULT NULL,
  `KreatininUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProBNP` mediumint(9) DEFAULT NULL,
  `ProBNPUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `HemoglobinFoer` decimal(3,1) DEFAULT NULL,
  `BehHypertoni` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Diabetes` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Insulin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Atrieflimmer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InfarktSiste90d` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AntInnleggelserSisteAar` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AntInnleggelserSisteAarUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlHjerteoperasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlACB` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlAVR` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlMitralplastikk` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlMVR` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlAnnet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlKorrigering` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlPCI` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TidlHjerneslag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KOLS` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PeriferKarsykdom` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `NYHAKlasse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Frailty` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `RedusertMobilitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Gangtest` smallint(6) DEFAULT NULL,
  `GangtestIkkeUtfort` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Gripestyrke` smallint(6) DEFAULT NULL,
  `DialyseFoerOp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `KritiskPreopTilstand` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hastegrad` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kontraindikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Porselenaorta` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Malignitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `UgunstigAnatomi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Steroidbehandling` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Stralebehandling` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Thoraxdeformitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvslaattForThorax` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Mobilitet` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Hygiene` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Aktiviteter` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SmerterUbehag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AngstDepresjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Helsetilstand` smallint(6) DEFAULT NULL,
  `PreVenstreVentrikkelFunksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreAortainsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreAortastenose` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreTricuspidal` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreMitralstenose` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreMitralinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreMaxHastighet` decimal(3,1) DEFAULT NULL,
  `PreMiddelgradient` smallint(6) DEFAULT NULL,
  `PreMREROA` smallint(6) DEFAULT NULL,
  `PreMREROAUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PreHoyreVentTrykk` smallint(6) DEFAULT NULL,
  `STSScore` tinyint(3) DEFAULT NULL,
  `HovedOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `AndreOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `TredjeOperator` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Operatorer` varchar(341) COLLATE utf8_danish_ci DEFAULT NULL,
  `Punksjonstid` time DEFAULT NULL,
  `Avslutningstid` time DEFAULT NULL,
  `IntroducerStr` tinyint(3) DEFAULT NULL,
  `IntroducerStrUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `Karlukning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Anestesi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreEkko` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `TypeKlaffeprotese` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
  `VellykketProsedyre` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Labnr` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Straaledose` decimal(9,2) DEFAULT NULL,
  `StraaledoseUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `GjennomLysTid` varchar(6) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kontrastmiddel` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Kontrastmengde` smallint(6) DEFAULT NULL,
  `KontrastmengdeUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompArytmi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompNeurologi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompTamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompPacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompVaskular` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompBlodning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAkuttKlaff` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAkuttVaskular` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAnestesi` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompHLMaskin` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompEmbolisering` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompAnnenKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LabKompDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Dodsdato` date DEFAULT NULL,
  `AvdKomplikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHjerneslag` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHjerneslagGrad` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompTIA` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompTamponade` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompPacemaker` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompAtrieflimmer` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompHjerteinfarkt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompVaskular` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompBlodning` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompBlodningGrad` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompInfeksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompDialyse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompAnnenKomp` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdKompDod` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostUndersokelseForetatt` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostKlassifisering` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostProlapsA1` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostProlapsA2` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostProlapsA3` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostProlapsP1` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostProlapsP2` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostProlapsP3` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostVenstreVentrikkelFunksjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostTricuspidal` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostMitralstenose` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostMitralinsuffisiens` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostMaxgradient` smallint(6) DEFAULT NULL,
  `PostMaxHastighet` decimal(3,1) DEFAULT NULL,
  `PostMiddelgradient` smallint(6) DEFAULT NULL,
  `PostMRPISA` tinyint(3) DEFAULT NULL,
  `PostMRPISAUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostMREROA` smallint(6) DEFAULT NULL,
  `PostMREROAUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostVContracta` decimal(2,1) DEFAULT NULL,
  `PostVContractaUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostReversFlow` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PostHoyreVentrikkelTrykk` smallint(6) DEFAULT NULL,
  `PostHoyreVentrikkelTrykkUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `MaxKreatinin` smallint(6) DEFAULT NULL,
  `MaxKreatininUkjent` varchar(5) COLLATE utf8_danish_ci DEFAULT NULL,
  `UtskrDato` date DEFAULT NULL,
  `UtskrevetTil` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ASAVedUtskrivelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AntikoagulantiaVedUtskrivelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AndrePlatehemmereVedUtskrivelse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `SkjemaStatusHovedskjema` tinyint(3) DEFAULT NULL,
  `SkjemaStatusKomplUtskr` tinyint(3) DEFAULT NULL,
  `SkjemaStatus` int(11) DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`),
  KEY `idx_MitralklaffVar` (`AvdRESH`,`ProsedyreDato`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `PasienterStudier`;
CREATE TABLE `PasienterStudier` (
  `PasientID` int(9) NOT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `StudieID` int(9) NOT NULL,
  `StudieNavn` varchar(75) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `PasInklDato` date DEFAULT NULL,
  `PasAvsluttDato` date DEFAULT NULL,
  `StudieStartDato` date DEFAULT NULL,
  `StudieAvsluttDato` date DEFAULT NULL,
  `StudieOppflgAvslDato` date DEFAULT NULL,
  `StudieStatus` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  PRIMARY KEY (`StudieID`,`PasientID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `SegmentStent`;
CREATE TABLE `SegmentStent` (
  `SegmentID` int(9) NOT NULL,
  `ForlopsID` int(9) NOT NULL,
  `Regtype` varchar(8) COLLATE utf8_danish_ci DEFAULT NULL,
  `PasientKjonn` varchar(13) COLLATE utf8_danish_ci DEFAULT NULL,
  `FodselsDato` date DEFAULT NULL,
  `Angiografor1` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Angiografor2` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Angiografor3` varchar(101) COLLATE utf8_danish_ci DEFAULT NULL,
  `Indikasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreDato` date DEFAULT NULL,
  `Hoyde` smallint(6) DEFAULT NULL,
  `Vekt` smallint(6) DEFAULT NULL,
  `Segment` tinyint(3) DEFAULT NULL,
  `StentID` int(10) unsigned DEFAULT NULL,
  `Stentnavn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StentType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `BallongLengde` tinyint(3) DEFAULT NULL,
  `DEBDiameter` decimal(4,2) DEFAULT NULL,
  `Diameter` decimal(5,2) DEFAULT NULL,
  `Etterdilatasjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `LokalSuksess` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Graft` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `MedikamentellBallong` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `MaksTrykkDEB` tinyint(3) DEFAULT NULL,
  `Okklusjon` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `ProsedyreType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Stenttrombosetype` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Stenoseklasse` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `StenoseType` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `Stentlengde` smallint(6) DEFAULT NULL,
  `StentSlut` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `InflasjonsTidDEB` tinyint(3) DEFAULT NULL,
  `IVLDiameter` decimal(3,2) DEFAULT NULL,
  `AntallPulser` tinyint(3) DEFAULT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `Sykehusnavn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  PRIMARY KEY (`SegmentID`,`ForlopsID`),
  KEY `idx_SegmentStent` (`AvdRESH`,`ProsedyreDato`,`StentType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

DROP TABLE IF EXISTS `SkjemaOversikt`;
CREATE TABLE `SkjemaOversikt` (
  `Skjemanavn` varchar(18) COLLATE utf8_danish_ci NOT NULL,
  `SkjemaStatus` tinyint(3) DEFAULT NULL,
  `ForlopsID` int(9) NOT NULL,
  `OpprettetAv` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `OpprettetDato` timestamp NULL DEFAULT NULL,
  `SistLagretAv` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `SistLagretDato` timestamp NULL DEFAULT NULL,
  `HovedDato` date DEFAULT NULL,
  `Sykehusnavn` varchar(100) COLLATE utf8_danish_ci DEFAULT NULL,
  `AvdRESH` varchar(30) COLLATE utf8_danish_ci DEFAULT NULL,
  `SkjemaRekkeflg` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ForlopsID`,`Skjemanavn`),
  KEY `idx_SkjemaOversikt` (`AvdRESH`,`HovedDato`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;


text:
National test scores show decline in math, reading for Missouri students
by: Kayla Shepperd, Emily Manley
JEFFERSON CITY, Mo. — The "Nation's Report Card" shows Missouri students' average reading and math scores have decreased significantly since before the pandemic.
The Department of Elementary and Secondary Education (DESE) said it normally doesn't bring the report from the National Assessment of Educational Progress (NAEP) to the Missouri State Board of Education. Still, because of the unprecedented situation, they felt members needed to know how Missouri compares.
Missing Bolivar teen found after month-long search
"We've never seen anything like this," Missouri's NAEP state coordinator Jeremy Ellis said Tuesday. "We've never seen drops like this before. They are historic and significant."
Unsurprisingly, the pandemic affected students' learning after the doors were closed and students were forced to learn online.
"NAEP scores have historically been flat for two decades. This is the first time we've seen this kind of decline," DESE Commissioner Margie Vandeven said.
DESE presented Missouri's results to the State Board of Education during its monthly meeting on Tuesday, showing a decrease in fourth and eighth-grade math and reading. Ellis said the main NAEP is given every other year, testing fourth and eighth graders in mathematics and reading.
"Missouri along with the nation, saw some very steep declines in the assessment from 2019 to 2022," Ellis said. "The bright note here would be that Missouri has statistically stayed the same as national public average."
DESE Assistant Commissioner Lisa Sireno said normally the test is given in February on odd-numbered years. Still, because of the pandemic, NAEP decided to forgo 2021's assessment and instead move it to 2022.
"NAEP is typically administered every other year, but we did find ourselves in an unprecedented situation," Sireno said.
Houston MO police chief responds to argument between officer and mayor
Missouri's average score for fourth-grade math was 232, but that's a decline of eight points from 2019. In fourth-grade reading, the state averages a score of 213, but in 2019, the score was 238.
Regarding eighth-grade math, Missouri averaged a score of 272, a decrease from 281 in 2019. Missouri's eighth-grade reading results were 258 compared to 263 three years ago.
Ellis said the results show drops were more significant at the lower levels and less significant at the advanced and proficient levels.
"What do we need to do differently to achieve better results and better outcomes for our kids, and that's learning from the other states on what they are doing," State Board of Education member Kerry Casey said.
With more than 30 states ahead of Missouri, the board wants data to see what other states are doing to receive better outcomes.
"It's interesting to look at the states that tend to do better and what they pay teachers. The state budget devoted to education because, my guess is, Missouri is one of the lowest in both of those categories," State Board of Education Vice President Carol Hallquist said. "I personally think it influences educational outcome."
Vandeven said with the ongoing tripledemic, the state needs to have the plan to make sure scores are increasing and school doors remain open.
"We're still having chronic absenteeism issues because people are sick again," Vandeven said. "We have the flu; we have RSV, and we still have COVID. We need to do whatever we can, if something like this occurs again, to make sure we're keeping our classroom doors open."
Two of Missouri's boarding states, Illinois and Iowa, still saw a decline but scored higher than the national average.
The board is asking DESE to have data and research from other states by March.
Back in August, preliminary test scores showed Missouri students are still not performing as well in school as they were before the pandemic.
The preliminary test scores show that 39% of students are proficient in math, which is up four percent from 2021. "Proficient" means meeting expectations for moving on to the next grade level. There was a small increase in science in 2022 at 38% compared to 2021, when the rate was 37%. There was a decrease in English, down to 43%. That's a difference of a two-percentage-point drop from 2021 and six from 2019.
READ NEXT: Three Missouri cities rank near top on sinful city survey
Data on test scores in ethnic groups remained consistent from previous years. Asian students performed with a proficiency rate of 57%, while Black students performed at a 17% proficiency rate. Preliminary results also showed that younger students had felt the effects of the pandemic. To see Missouri's results on the NAEP website, click here.
Click here to see DESE's report to the State Board of Education on Tuesday.
OzarksFirst Breaking News
Chiefs edge Jays in clash of top-10 boys hoops teams
Local Sports / 1 day ago
Ford pleased with Bears gritty Valley win over UIC
Mahomes has no problems with ankle in practice
Bears battle back, sweep UIC Flames
Glendale slides passed Rolla, 54-51
Local Sports / 4 days ago
MSU bulks up o-line with Cade's transfer
Athlete of the Week: Ja'Kobe Walter
Lady Bears maul Racers in first MVC meeting
Panthers downed by Bulldogs second half scoring frenzy
Bears late rally comes up short against Salukis
Park Hill South cruises to victory over West Plains …
Local Sports / 1 week ago
Mt. Vernon cancels remaining girls basketball schedule
Sports / 1 week ago
Belmont hands Lady Bears second straight loss
Springfield's Loonsfoot ready to rumble at Synergy …
Drury beats Jewell, snaps losing skid
View All Local Sports
World News / 35 mins ago

redpajama_set_name: RedPajamaCommonCrawl


Thanks for Keeping Our Profits Up. Sorry, Can't Afford a Raise.
"The most important contributor to higher profit margins over the past five years has been a decline in labor's share of national income." That's the wisdom from the smart guys at Goldman Sachs, per the New York Times' drab, but crucial story on how workers are still making American business more productive–but take a smaller share of the national pie than they did at any time since the government began keeping track just after WWII.
"For most of the last century, wages and productivity — the key measure of the economy's efficiency — have risen together, increasing rapidly through the 1950's and 60's and far more slowly in the 1970's and 80's.
And next time you hear the president talk about rising family incomes, take note: All of that "rising" involves the families at the very top of the income scale. The rest of you are just working harder to finance someone else's profit.


text:
Book Discussion - Jacob Dlamini's Askari
Wednesday, 29 October, 2014 - 18:00
WiSER invites you to a discussion of
Jacob Dlamini's book
Askari : A story of collaboration and betrayal in the anti-apartheid struggle
Published by Jacana
Wednesday, 29th October 2014 at 6pm
WiSER Seminar Room, 6th Floor, Richard Ward Building, East Campus, Wits University
Ebrahim Ebrahim is Parliamentary Councillor to the President and former Deputy Minister of International Relations and Cooperation
Khosi Xaba is a Writing and Documentation Fellow at GALA (Gay and Lesbian Archives), and the author of numerous works of fiction, poetry, and non-fiction.
This book tells the story of Glory Sedibe, an ANC member-turned-security policeman. It seeks to understand why Sedibe made the choices he did – collaborating with his captors, turning against the ANC, and then hunting down his comrades. It looks beyond the black-and-white that still dominates South Africa's political canvas to examine the grey zones in which South Africans – combatants and non-combatants – lived. As the book demonstrates, Sedibe's acts of betrayal form but one layer in a sedimentation of betrayals in which Sedibe himself was betrayed by the Swazi police and may also have been sold out by his own comrades in the ANC.
Jacob Dlamini is at present a Visiting Fellow at Harvard University and a Research Associate at the Society, Work and Development Institute (SWOP), University of the Witwatersrand.
His book Native Nostalgia (Jacana, 2009), about growing up in the township of Katlehong on the Witwatersrand, has won great acclaim.
RSVP: Najibha.Deshmukh@wits.ac.za
WISER would like to acknowledge and thank PARI for funding Jacob's visit to Johannesburg


Welcome our brand new forum. This is where anyone can talk to BATA about anything related to Assistive Technology.
Please be polite and courteous. This space is primarily for information sharing and discussion, not for advertising products or services. We have a strict no sales policy.
What would you like to discuss about Assistive Technology?
Let us know. Start a new discussion by adding a subject and message below.
Please log in or register to add a new discussion.


text:
Thanksgiving turnips and the diversity of the genus Brassica
Jeanne briefly describes the cultivation history and botany of Brassica rapa, B. napus, B. nigra, and B. juncea to round out our cursory tour of the extraordinary genus Brassica. Michelle offers a recipe highlighting a vegetable likely present at the first Thanksgiving: the turnip, an exceptional cultivar of B. rapa.
White Tokyo turnips and purple-top turnips
Along with the turkey, stuffing, potatoes, green beans and cranberry sauce, Brussels sprouts have become something of a Thanksgiving staple. None of these dishes, however, were part of the original harvest feast shared by the Pilgrims and Wampanoag in Plymouth Colony in 1621. A close relative of Brussels sprouts, however, likely had an honored place at the table: turnips. The Pilgrims chose the tuberous vegetable to occupy precious cargo space in the holds of their ships bound for the New world and grew them in their Plymouth Colony gardens. Turnips were probably also on most Americans' Thanksgiving menus when President Lincoln made the holiday official in 1863. During that first Thanksgiving turnips served as a sole representative of a genus, Brassica, that has one of the most impressive radiations of cultivated species on the planet. Its extensive domestication happened primarily in Europe and Asia. While Native Americans may have exploited weedy little native species in same family as the now-familiar Brassica (the mustard family, Brassicaceae), there is little evidence that they cultivated them or subjected them to artificial selection.
Row of turnips in the Monticello garden
Descriptions of turnips date to Alexander the Great's vast kingdom, which spanned much of central Eurasia. The vegetable's domestication history earlier than that is not well known, but turnips likely made their way to western Europe from an Asian origin, along with several other well-known varietals of the same species, Brassica rapa. In a previous post we discussed the numerous varieties of Brassica oleracea (including kale, collard greens, Chinese broccoli, Brussels sprouts, kohlrabi, cabbage, broccoli, and cauliflower). The radiation of Brassica rapa into several morphologically variable domesticated vegetables across its broad native range in Europe, Asia and North Africa is almost as spectacular as that of B. oleracea. Turnips, Italian rapini, and Asian cultivars bok choy, tatsoi, mizuna greens, napa cabbage, and purple mustard greens are all varieties of B. rapa. In addition to B. oleracea and B. rapa, other important Brassica species in the human diet are Brassica napus (rutabaga and oilseed), Brassica nigra (black mustard) and Brassica juncea (mustard greens). As such, the single genus Brassica alone accounts for a respectable fraction of the vegetables in a well-stocked produce section.
The genus Brassica
Napa cabbage
Many varietals of B. rapa, B. napus, and B. juncea have been developed for tubers or greens. Turnip cultivars (B. rapa ssp. campestris) are typically grown for their swollen root tuber, but also for their greens. Napa cabbage or Chinese cabbage (B. rapa ssp. pekinensis), a Chinese cultivar, forms a large, impressive, long head of tightly packed leaves with broad, white midribs and curly pale green leaf blades.
large white bok choy
small green bokchoy
Bok choy (B. rapa ssp. chinensis) was developed in China by the fifth century A.D. and looks like a smaller Napa cabbage with more loosely-packed leaves and fleshier white or pale green leaf midribs and thicker, darker green leaf blades.
tatsoi
mizuna greens
Tatsoi is similar to Bok Choy but is even smaller yet and darker green. Japanese cultivar mizuna greens (B. rapa ssp. nipposinicai) are whispy, delicate, deeply toothed leaves.
green mustard greens
purple mustard greens
Spicy, green, curly mustard greens are Asian (Chinese, Japanese and Indian) varietals of Brassica juncea. The leaves and stems of green varietals of this herbaceous plant, which are typically cooked or pickled, resemble a lighter, brighter kale but have a more pungent mustard, horseradish-like flavor. Purple mustard greens have a similar pungency but with rich plum and dark green coloring (some of these may be variants of B. rapa).
turnip and rutabaga
B. napus varietals include the turnip-like, yellow-fleshed rutabaga root tuber.
yellow (S. alba) and brown (B. nigra) mustard seeds
Seeds of several Brassica species and other related crucifers are used as spices and oils. Seeds of at least two plant species are the primary ingredients in the condiment mustard. A yellow-seeded variety of the Asian B. juncea, the mustard greens, had been cultivated for centuries in Europe for brown mustard until about the 1950s, when it began to be replaced by another weedy little Mediterranean Brassica annual with a long history of cultivation: black mustard, Brassica nigra, which, unlike B. juncea, can be harvested mechanically. Yellow or white mustard seeds, which are the main ingredient in most commercially available prepared yellow mustard in the United States, are the seeds of Sinapis alba, a close relative of the genus Brassica that has at some points in taxonomic history been subsumed into it. B. nigra seeds are also the dark brown mustard seeds thrown into hot oil and toasted until they pop as the first step in the preparation of many Indian dishes. Part of their explosiveness in the pan is attributable to the high concentration of fat typical of Brassica seeds, which is pressed out and used as a cooking oil throughout much of the world. The oil from these species is, collectively by tonnage, the most abundant cooking oil produced on the planet (Al-Shebaz 2012). The oil is called mustard oil, canola oil, or rapeseed oil, and is actually variously produced from the seeds of three different species of Brassica or their hybrids: B. napus, B. juncea and B. rapa.
wild mustard flowers
B. nigra and B. rapa grow wild as weeds in much of the temperate world, and all of their parts are quite edible, if a bit strongly flavored and tough. If you're feeling adventurous, you can throw a few wild mustard leaves into our turnip recipe below, which takes cues from China, the center of diversity of the brassicas.
Update (8 April 2013): Some kales, including Red Russian kale, are actually "Siberian kales," species Brassica napus, the same species as rutabaga, instead of B. oleracea.
turnips with greens
Ginger Scallion Noodles with Tokyo turnips and Maitake mushrooms
This recipe highlights the roots and greens of turnips, the glorious and frequently inappropriately maligned cultivar of B. rapa. The recipe calls for Tokyo turnips, or white turnips, small white turnips with thin skin, which are increasingly available in farmer's markets and some grocery stores. If you can't find them but can find the larger purple-topped turnips, go ahead and get those, but do taste a raw sliver of it to decide if the skin is thin enough to be left on or needs to be peeled off. If your turnips are missing their greens, use mustard greens if you can find them, or bok choy, kale, or a combination of radish tops, arugula and napa cabbage. Or, go outside and harvest some wild mustard greens! If you can't find and/or tolerate maitake mushrooms, use your preferred combination of shitake, cremini and oyster mushrooms.
This dish is so satisfying when you are in the mood for a Chinese noodle dish with lots of vegetables and feel the need to cook and not order in. It is inspired by the Momofuku recipe, which was in turn inspired by the classic Chinese take out dish. The small Tokyo turnips are perfect because they don't need peeling and their greens take on a quick pickle flavor with the addition of vinegar. Don't let all the long list of directions dissuade you. You are simply making some sauce, very quickly cooking some vegetables and boiling some noodles. If you have access to fresh noodles, use those!
1/2 pound of dried lomein noodles
2 pounds of Tokyo turnips with their greens
1/2 pound of maitake mushrooms, sliced
1 bunch of scallions
1/4 cup of peeled, minced ginger
3-4 teaspoons sherry vinegar
1/4 cup peanut or grapeseed oil
Wash scallions, trim each end and peel off the outer layer of onion skin. Thinly slice the scallions, both the white and green parts, and put in a small bowl with the minced ginger, 1 teaspoon of sherry vinegar, soy sauce and 2 tablespoons of oil. Stir all ingredients together and set aside the ginger and scallion sauce.
Rinse the turnips and their greens. Cut off the greens and slice in 1/4 inch bands. Trim each turnip of its tail, cut in half and slice 1/4 inch thick.
In a medium pot, bring water to a boil for the noodles. Cook noodles for 5-6 minutes until tender but toothsome.
Meanwhile, heat a large sauté pan over high heat. Pour in 2 tablespoons of oil, swirl the pan and add the mushrooms. Give the mushrooms a quick stir to coat with oil and sauté until a golden brown crisp, about 3-4 minutes. Season with salt and remove mushrooms from the pan. Add turnips to the same pan and continue cooking on high heat for a minute. Remove turnips from the pan and set aside with the mushrooms. Finally, add the turnip greens to the pan and cook until the greens wilted, about 1 minute. Season with salt and a teaspoon or two of sherry vinegar.
Drain noodles and toss with ginger scallion sauce. Divide noodles between 4 bowls and top each bowl with a little pile of mushrooms, turnips and greens.
Serve with hoisin and chili sauce on the side.
Al-Shehbaz, I. A. 2012. Systematics and phylogeny of the mustard family. Missouri Botanical Garden.
Vaughan, J. G., and A. Geissler. 2009. The New Oxford Book of Food Plants. Oxford University Press, New York.
This entry was posted in Uncategorized on November 20, 2012 by Jeanne L. D. Osnas.
← The extraordinary diversity of Brassica oleracea The most political vegetables: A whirlwind tour of the edible crucifers →
7 thoughts on "Thanksgiving turnips and the diversity of the genus Brassica"
Pingback: The most political vegetables: A whirlwind tour of the edible crucifers | The Botanist in the Kitchen
Pingback: The extraordinary diversity of Brassica oleracea | The Botanist in the Kitchen
Pingback: Botany Lab of the Month: Jack-O-Lantern | The Botanist in the Kitchen
Pingback: Botany lab/rant of the month: that's a magic beanstalk, not a soybean | The Botanist in the Kitchen
Pingback: Botany lab of the month: Contrasting brassica plants in the garden | The Botanist in the Kitchen


text:
Emmys 2021: Women sweep top comedy, drama honours for first time
Female directors such as Jessica Hobbs and Lucia Aniello among many others bagged the Primetime Emmy Awards for comedy and drama series directing in the same year for the first time, as makers from 'The Crown' and 'Hacks' prevailed against tough competition.
Jessica Hobbs (File Photo)
20 Sep, 2021, 12:33 pm
Aniello won for directing the pilot episode of 'Hacks', the HBO Max comedy that also won lead comedy actress for star Jean Smart.
"It's very surreal. It feels very much like a fever dream," Aniello said of winning for writing.
Hobbs won for helming the fourth season finale of 'The Crown', the episode "War" depicting the depth of the dysfunction of Prince Charles and Princess Diana's doomed marriage.
Hobbs' win was part of an impressive near-sweep for 'The Crown', reports variety.com.
Hobbs said backstage that she tried not to think about how the retrospective would be received in 2021 but rather focus on the feelings that the characters would have had at the moment.
"I wouldn't say we think so much about how they'll be perceived," Hobbs said, but rather "the real circumstances for the person at that time".
The last woman to win for drama series helming was Reed Morano, for the pilot of 'The Handmaid's Tale' in 2017.
Before that, it was a more than 20-year gap after Mimi Leder's win in 1995 for 'ER'.
On the lighter side, women are no stranger to winning for comedy directing.
In 2018, Amy Sherman-Palladino won for Amazon's 'The Marvelous Mrs. Maisel'. Gail Mancuso scored back-to-back wins in 2013 and 2014 for 'Modern Family.
Women creatives also took home awards for writing, including Michaela Coel scoring writing for a limited series for HBO's 'I May Destroy You', while the trio who created 'Hacks' -- Aniello, Jen Statsky, and Paul W. Downs -- won for comedy series writing.
"I just wrote a little something, for writers, really. Write the tale that scares you, that makes you feel uncertain, that is uncomfortable. I dare you," Coel said in accepting her trophy for 'I May Destroy You'.
"In a world that entices us to browse through the lives of others to help us determine how we feel about ourselves, and see in turn still the need to be constantly visible, for visibility these days seems to show equate to success. Do not be afraid to disappear, from it, from us, for a while and see what comes to you in the silence."
Emmys 2021
Top Comedy
Drama Honours


I have just completed my first corporate styling project, and used pops of colour, statement pieces and quirky accessories to revamp a PR office in Central London. I thought I'd share these with you as well as the result, as, although it's a big office space, not an actual house or flat, the principles of interior styling are often the same and you might get some inspiration and tips from the project to apply to your own home. So ready for the full tour?


A doctor has told a jury there is a "significant possibility" that pilot Andrew Hill was experiencing "cognitive impairment" when his plane crashed and killed 11 men at Shoreham Airshow.
Dr Henry Lupa, who has advised the RAF and Nasa on the effects of G-force, told the Old Bailey Mr Hill may have suffered a lack of oxygen.
The defence witness said this may have impaired Mr Hill's decision making.
The 1950s Hawker Hunter he was flying crashed on to the A27 in Sussex and exploded on 22 August 2015.
Dr Lupa also told the court the plane's glass cockpit was "like a greenhouse" on the warm summer's day and the temperature inside "could be a factor".
He wrote a report for the defence that concluded the level of G-force experienced by Mr Hill during his display may have led to cognitive impairment caused by cerebral hypoxia, the court heard.
"If cognitive impairment did occur the most likely effect would be an impairment of judgement and decision making," he said.
Defence counsel Karim Khalil QC earlier argued Mr Hill was cognitively impaired and "unable to properly and fully control the aircraft".
Dr Lupa said it was "difficult to conceive" why a pilot would deliberately choose to do a manoeuvre known to be dangerous at low altitude unless a "serious misjudgement occurred".
"It's unknown if cognitive impairment may have occurred because of cerebral hypoxia but it is a credible explanation," he told the court.
Dr Lupa said there was no evidence Mr Hill suffered a loss of consciousness, known as G-loc, or a lesser condition known as A-loc, where "the lights are on but nobody's home".
However, he told the court that "measurable hypoxia can occur at levels significantly below those that can cause G-loc or A-loc".
He said it would be difficult to observe the impacts of cognitive impairment.
"Maybe a parallel is if you are in a car with someone who has had a few drinks of alcohol," he said.
"You might not necessarily be aware their driving might not be what it ought to be."
The court heard temperatures at North Weald Airport, where the Hawker Hunter had flown from on the day of crash, reached 29C.
Dr Lupa said the high temperature "could be a factor" as "an increase in body core temperature reduces G tolerance".


The Nine-Pyramid Feng Shui Plate is hand made and the size and placement of pyramids might have slight variations. The pyramids sit on a glass plate which measures approximately 2" by 2". Some might be bigger. Each Feng Shui plate comes in a decorative red box that contains a description of the meaning of the plate. The box measures approximately 3" by 1.5". Nine pyramids in one place absorb higher amount of energy. The plate helps neutralize all minor defects of the environment it is in.
Golden Quartz: Happiness, joy, mood booster, friendship, confidence, success.


Celebrate someone special with simple gestures and beautiful symbolism. The Simple Spirits collection features a rustic, distressed wood finish with embossed patterns in rich, jewel-tone colors. This keepsake box provides a beautiful place to store momentos of a special time, event, or person. It helps to mark any of life's major events.
This MDF wood box measures 5 x 3 x 4 1/2 inches, and has a vintage style distressed look to it in gray and pink. The lid is solid gray and has a pink cutout butterfly with rusty looking wire for its antenna. Inside the cutout it reads, You make the world a kinder place. The top of the box is hinged, and lifts up using a decorative bronze knob. The inside of the box is gray, and inside the lid is a white butterfly inscribed with, You make my heart happy. The bottom of the box has an embossed pattern in gray and pink. The theme of this keepsake box reflects the importance of kindness and happiness. Such a perfect gift for any occasion!


NJ Vapor Vault is a purveyor of vapor and electronic vapor devices, hardware, supplies and e-liquids. With more than 170 different juice flavors, we're sure to have exactly what you're looking for. Stop in and let our knowledgeable and friendly staff hook you up.
Street Address: 406 Richmond Ave.


Hebei Shangrun International Trading Co.,Ltd is a professional large-scale supplier of all types of water & plumbing systems products, whose group headquarters is located in Hebei Province. Our main products include HDPE pipe and fittings, PPR pipe and fittings, Valve, Ductile Iron Pipes and fittings etc. With development of over 10 years, our company is widely known as providing best quality products and attentive service, which has won recognition and praise of domestic and foreign customers, peers and experts.
A: L/C, T/T, Paypal, West Union etc.
A: Yes, sure,we can make your logo printed on the products.