57 lines
2.2 KiB
Plaintext
57 lines
2.2 KiB
Plaintext
1. Mapping masterlayanan dengan modality code.
|
|
Daftar code ada di table: modalitycodes
|
|
2. Create table pacs_order_mwl, pacs_result_series
|
|
|
|
CREATE TABLE `pacs_order_mwl` (
|
|
`AccessionNumber` char(15) NOT NULL DEFAULT '',
|
|
`MEDRECID` char(50) NOT NULL DEFAULT '',
|
|
`RegID` char(20) NOT NULL DEFAULT '',
|
|
`TrxLayananID` bigint(20) unsigned NOT NULL DEFAULT '0',
|
|
`TrxDepartemenID` bigint(20) NOT NULL DEFAULT '0',
|
|
`StudyIUID` char(100) NOT NULL DEFAULT '',
|
|
`ScheduledProcStepID` char(20) NOT NULL DEFAULT '',
|
|
`CreatedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`NA` enum('N','Y') NOT NULL DEFAULT 'N',
|
|
PRIMARY KEY (`AccessionNumber`,`TrxLayananID`),
|
|
KEY `x_medrec` (`MEDRECID`),
|
|
KEY `x_regid` (`RegID`),
|
|
KEY `x_trx` (`TrxLayananID`),
|
|
KEY `x_dttm` (`CreatedDateTime`),
|
|
KEY `x_na` (`NA`),
|
|
KEY `TrxDepartemenID` (`TrxDepartemenID`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
|
|
CREATE TABLE `pacs_result_series` (
|
|
`AccessionNumber` char(15) NOT NULL DEFAULT '',
|
|
`MEDRECID` char(50) NOT NULL DEFAULT '',
|
|
`RegID` char(20) NOT NULL DEFAULT '',
|
|
`TrxLayananID` bigint(20) unsigned NOT NULL DEFAULT '0',
|
|
`TrxDepartemenID` bigint(20) NOT NULL DEFAULT '0',
|
|
`StudyIUID` char(100) NOT NULL DEFAULT '',
|
|
`StudyDescription` char(200) NOT NULL DEFAULT '',
|
|
`StudyDatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`SeriesIUID` char(100) NOT NULL DEFAULT '',
|
|
`SeriesNumber` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`SeriesDescription` char(200) NOT NULL DEFAULT '',
|
|
`NumberOfInstance` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`SOPIUID` char(100) NOT NULL DEFAULT '',
|
|
`CreatedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`Published` enum('N','Y') NOT NULL DEFAULT 'N',
|
|
`PublisheDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`NA` enum('N','Y') NOT NULL DEFAULT 'N',
|
|
PRIMARY KEY (`AccessionNumber`,`SeriesIUID`),
|
|
UNIQUE KEY `x_uk` (`StudyIUID`,`SeriesIUID`),
|
|
KEY `x_acs` (`AccessionNumber`),
|
|
KEY `x_medrec` (`MEDRECID`),
|
|
KEY `x_regid` (`RegID`),
|
|
KEY `x_trx` (`TrxLayananID`),
|
|
KEY `x_sdttm` (`StudyDatetime`),
|
|
KEY `x_dttm` (`CreatedDateTime`),
|
|
KEY `x_na` (`NA`),
|
|
KEY `x_pub` (`Published`),
|
|
KEY `TrxDepartemenID` (`TrxDepartemenID`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
|