Skip to main content

MySQL views with union

// TODO tách dòng tạo view ra cho dễ coi
// Thêm 1 số vd tạo view bá đạo khác.
// Note Æ°u/nhược Ä‘iểm của views 
    
| vTempReportScore | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vTempReportScore` AS select `TempReportScore`.`C1` AS `score`,'C1' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C2` AS `score`,'C2' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C3` AS `score`,'C3' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C4` AS `score`,'C4' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C5` AS `score`,'C5' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C6` AS `score`,'C6' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C7` AS `score`,'C7' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C8` AS `score`,'C8' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C9` AS `score`,'C9' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C10` AS `score`,'C10' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C11` AS `score`,'C11' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C12` AS `score`,'C12' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C13` AS `score`,'C13' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C14` AS `score`,'C14' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C15` AS `score`,'C15' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C16` AS `score`,'C16' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C17` AS `score`,'C17' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C18` AS `score`,'C18' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C19` AS `score`,'C19' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C20` AS `score`,'C20' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C21` AS `score`,'C21' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C22` AS `score`,'C22' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C23` AS `score`,'C23' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C24` AS `score`,'C24' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` union all select `TempReportScore`.`C25` AS `score`,'C25' AS `ItemID`,`TempReportScore`.`TempReportID` AS `TempReportID` from `TempReportScore` | utf8                 | utf8_general_ci      |
+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


---------------------------------------------------+----------------------+----------------------+
| vTempReportScoreCompany | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER 

VIEW `vTempReportScoreCompany` AS select `TempReportScoreCompany`.`C1` AS `score`,'C1' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C2` AS `score`,'C2' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C3` AS `score`,'C3' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C4` AS `score`,'C4' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C5` AS `score`,'C5' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C6` AS `score`,'C6' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C7` AS `score`,'C7' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C8` AS `score`,'C8' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C9` AS `score`,'C9' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C10` AS `score`,'C10' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C11` AS `score`,'C11' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C12` AS `score`,'C12' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C13` AS `score`,'C13' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C14` AS `score`,'C14' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C15` AS `score`,'C15' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C16` AS `score`,'C16' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C17` AS `score`,'C17' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C18` AS `score`,'C18' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C19` AS `score`,'C19' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C20` AS `score`,'C20' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C21` AS `score`,'C21' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C22` AS `score`,'C22' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C23` AS `score`,'C23' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C24` AS `score`,'C24' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany` union all select `TempReportScoreCompany`.`C25` AS `score`,'C25' AS `ItemID`,`TempReportScoreCompany`.`TempReportID` AS `TempReportID` from `TempReportScoreCompany`

 | utf8                 | utf8_general_ci      |
+-------------------------+-------------------------------------------------------------------------------------------------------



mysql> show create table TempReportAnswerRaw;
-------------------------------------------------------------------------------------------------------------------------+
| TempReportAnswerRaw | CREATE TABLE `TempReportAnswerRaw` (
  `TempReportID` int(11) NOT NULL DEFAULT '0' COMMENT 'TempReportBaseItem.TempReportID',
  `AnswerNo` tinyint(2) NOT NULL COMMENT '',
  `AnswerValue` int(1) DEFAULT NULL COMMENT '',
  `Status` varchar(2) DEFAULT 'no',
  `Bimage` mediumtext,
  `SFDC_Id` varchar(20) DEFAULT NULL,
  `SystemModStamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `TempReportID` (`TempReportID`,`AnswerNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=''                                                                                              |
+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table TempReportBaseItem;
+-----
| TempReportBaseItem | CREATE TABLE `TempReportBaseItem` (
  `TempReportID` int(11) NOT NULL AUTO_INCREMENT,
  `CandidateID` int(11) DEFAULT NULL COMMENT '',
  `Business` varchar(255) DEFAULT NULL COMMENT '',
  `EmployeesNum` varchar(255) DEFAULT NULL COMMENT '',
  `Capital` varchar(255) DEFAULT NULL COMMENT '',
  `Post` varchar(255) DEFAULT NULL COMMENT '',
  `JobCategory` varchar(255) DEFAULT NULL COMMENT '',
  `DateOfBirth` date DEFAULT NULL COMMENT '',
  `Sex` char(2) DEFAULT NULL COMMENT '',
  `AnswerPurpose` varchar(255) DEFAULT NULL COMMENT '',
  `AnswerPurposeOtherText` varchar(100) DEFAULT NULL COMMENT '',
  `Progress` varchar(4) DEFAULT NULL COMMENT '',
  `Status` char(2) DEFAULT NULL COMMENT '',
  `is_paid` tinyint(1) NOT NULL DEFAULT '0',
  `payment_date` datetime DEFAULT NULL,
  `ModDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日時',
  `Preliminary1` varchar(255) DEFAULT NULL COMMENT '',
  `Preliminary2` varchar(255) DEFAULT NULL COMMENT '',
  `Preliminary3` varchar(255) DEFAULT NULL COMMENT '',
  `Preliminary4` varchar(255) DEFAULT NULL COMMENT '',
  `Preliminary5` varchar(255) DEFAULT NULL COMMENT '',
  `Preliminary6` varchar(255) DEFAULT NULL COMMENT '',
  `ComputationDate` timestamp NULL DEFAULT NULL COMMENT '',
  `ResponseDate` timestamp NULL DEFAULT NULL COMMENT '',
  `SurveyVersion` varchar(255) DEFAULT NULL COMMENT ' ',
  `ReferenceVersion` varchar(255) DEFAULT NULL COMMENT '',
  `CommentsVersion` varchar(255) DEFAULT NULL COMMENT '',
  `RegDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
  `SystemModStamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Bimage` mediumtext,
  `SFDC_Id` varchar(20) DEFAULT NULL COMMENT '',
  `SFDC_lead` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`TempReportID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='' |
+--------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

mysql> show create table TempReportScore;
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

| TempReportScore | CREATE TABLE `TempReportScore` (
  `TempReportScoreID` int(11) NOT NULL AUTO_INCREMENT COMMENT '',
  `TempReportID` int(11) DEFAULT '0' COMMENT '',
  `C1` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C2` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C3` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C4` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C5` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C6` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C7` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C8` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C9` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C10` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C11` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C12` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C13` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C14` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C15` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C16` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C17` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C18` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C19` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C20` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C21` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C22` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C23` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C24` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `C25` decimal(17,15) DEFAULT '0.000000000000000' COMMENT '',
  `Status` char(2) DEFAULT NULL COMMENT '',
  `ModDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '',
  `RegDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
  `SystemModStamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Bimage` mediumtext,
  `SFDC_Id` varchar(20) DEFAULT NULL COMMENT '',
  `SFDC_lead` varchar(20) DEFAULT NULL,
  `CandidateID` int(11) DEFAULT NULL,
  PRIMARY KEY (`TempReportScoreID`)
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8 COMMENT='' |


mysql> show create table TempReportRawScore;
+--------------------+----------------------------------------------------------------------------------------------------------
| TempReportRawScore | CREATE TABLE `TempReportRawScore` (
  `RawScoreID` int(11) NOT NULL AUTO_INCREMENT COMMENT '',
  `TempReportID` int(11) NOT NULL DEFAULT '0' COMMENT '',
  `C1` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C2` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C3` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C4` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C5` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C6` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C7` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C8` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C9` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C10` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C11` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C12` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C13` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C14` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C15` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C16` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C17` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C18` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C19` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C20` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C21` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C22` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C23` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C24` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `C25` decimal(17,15) NOT NULL DEFAULT '0.000000000000000' COMMENT '',
  `Status` char(4) NOT NULL COMMENT '',
  `ModDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '',
  `RegDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
  `Bimage` mediumtext,
  `SFDC_Id` varchar(20) DEFAULT NULL,
  `SystemModStamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`RawScoreID`,`TempReportID`)
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8 COMMENT='' |





mysql> desc TempReportScore;
+-------------------+----------------+------+-----+-------------------+-----------------------------+
| Field             | Type           | Null | Key | Default           | Extra                       |
+-------------------+----------------+------+-----+-------------------+-----------------------------+
| TempReportScoreID | int(11)        | NO   | PRI | NULL              | auto_increment              |
| TempReportID      | int(11)        | YES  |     | 0                 |                             |
| C1                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C2                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C3                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C4                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C5                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C6                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C7                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C8                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C9                | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C10               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C11               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C12               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C13               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C14               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C15               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C16               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C17               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C18               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C19               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C20               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C21               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C22               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C23               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C24               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| C25               | decimal(17,15) | YES  |     | 0.000000000000000 |                             |
| Status            | char(2)        | YES  |     | NULL              |                             |
| ModDate           | timestamp      | YES  |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| RegDate           | timestamp      | YES  |     | CURRENT_TIMESTAMP |                             |
| SystemModStamp    | timestamp      | YES  |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| Bimage            | mediumtext     | YES  |     | NULL              |                             |
| SFDC_Id           | varchar(20)    | YES  |     | NULL              |                             |
| SFDC_lead         | varchar(20)    | YES  |     | NULL              |                             |
| CandidateID       | int(11)        | YES  |     | NULL              |                             |
+-------------------+----------------+------+-----+-------------------+-----------------------------+
35 rows in set (0.00 sec)

mysql> desc TempReportRawScore;
+----------------+----------------+------+-----+-------------------+-----------------------------+
| Field          | Type           | Null | Key | Default           | Extra                       |
+----------------+----------------+------+-----+-------------------+-----------------------------+
| RawScoreID     | int(11)        | NO   | PRI | NULL              | auto_increment              |
| TempReportID   | int(11)        | NO   | PRI | 0                 |                             |
| C1             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C2             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C3             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C4             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C5             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C6             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C7             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C8             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C9             | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C10            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C11            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C12            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C13            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C14            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C15            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C16            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C17            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C18            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C19            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C20            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C21            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C22            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C23            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C24            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| C25            | decimal(17,15) | NO   |     | 0.000000000000000 |                             |
| Status         | char(4)        | NO   |     | NULL              |                             |
| ModDate        | timestamp      | YES  |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| RegDate        | timestamp      | YES  |     | CURRENT_TIMESTAMP |                             |
| Bimage         | mediumtext     | YES  |     | NULL              |                             |
| SFDC_Id        | varchar(20)    | YES  |     | NULL              |                             |
| SystemModStamp | timestamp      | YES  |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+----------------+----------------+------+-----+-------------------+-----------------------------+

mysql> desc Candidate;
+-----------------------------------+--------------+------+-----+-------------------+-----------------------------+
| Field                             | Type         | Null | Key | Default           | Extra                       |
+-----------------------------------+--------------+------+-----+-------------------+-----------------------------+
| CandidateID                       | int(11)      | NO   | PRI | NULL              | auto_increment              |
| MPIn_CandidateID__c               | int(11)      | YES  |     | NULL              |                             |
| MP_MemberID                       | varchar(255) | YES  |     | NULL              |                             |
| Email                             | varchar(255) | YES  |     | NULL              |                             |
| PasswordHash                      | varchar(255) | YES  |     | NULL              |                             |
| LastName                          | varchar(255) | YES  |     | NULL              |                             |
| FirstName                         | varchar(255) | YES  |     | NULL              |                             |
| NameKatarina                      | varchar(255) | YES  |     | NULL              |                             |
| MobilePhone                       | varchar(50)  | YES  |     | NULL              |                             |
| Address                           | varchar(255) | YES  |     | NULL              |                             |
| Street                            | varchar(255) | YES  |     | NULL              |                             |
| City                              | varchar(255) | YES  |     | NULL              |                             |
| State                             | varchar(255) | YES  |     | NULL              |                             |
| beidu_youku_                      | varchar(20)  | YES  |     | NULL              |                             |
| MPIn_Company                      | varchar(255) | YES  |     | NULL              |                             |
| StartingDay                       | date         | YES  |     | NULL              |                             |
| WorkEndDate                       | date         | YES  |     | NULL              |                             |
| MPIn_ResumeUpdate                 | timestamp    | YES  |     | NULL              |                             |
| MP_MailMagazine                   | char(4)      | YES  |     | NULL              |                             |
| MPIn_loginSetup                   | char(4)      | YES  |     | NULL              |                             |
| Web_login_setup                   | char(4)      | YES  |     | NULL              |                             |
| MPOut_Login                       | char(4)      | YES  |     | NULL              |                             |
| ReferralsJobsPageRegistration     | char(8)      | YES  |     | NULL              |                             |
| MPIn_RecordDate                   | timestamp    | YES  |     | CURRENT_TIMESTAMP |                             |
| LastModifiedDate                  | timestamp    | YES  |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| candidateOldID                    | varchar(16)  | YES  |     | NULL              |                             |
| MPOut_TopSetup                    | char(14)     | YES  |     | NULL              |                             |
| MPOut_Candi                       | char(4)      | YES  |     | NULL              |                             |
| MPOut_Information1                | varchar(255) | YES  |     | NULL              |                             |
| ScoutServiceApplication           | char(4)      | YES  |     | NULL              |                             |
| ScoutAvoidanceIndustryCompanyName | varchar(255) | YES  |     | NULL              |                             |
| ScoutInterestCompanyName          | varchar(256) | YES  |     | NULL              |                             |
| ScoutApplicationDate              | timestamp    | YES  |     | NULL              |                             |
| ScoutReleaseDate                  | timestamp    | YES  |     | NULL              |                             |
| MPIn_ResumeServiceApply           | char(4)      | YES  |     | NULL              |                             |
| ResumesApplicationDate            | timestamp    | YES  |     | NULL              |                             |
| ResumesReleaseDate                | timestamp    | YES  |     | NULL              |                             |
| MPIn_LastAccessDate               | timestamp    | YES  |     | NULL              |                             |
| SadHillRegDate                    | timestamp    | YES  |     | NULL              |                             |
| AuthString                        | varchar(128) | YES  |     | NULL              |                             |
| AuthKey                           | varchar(128) | YES  |     | NULL              |                             |
| AuthExpireDate                    | timestamp    | YES  |     | NULL              |                             |
| AuthActivateDate                  | timestamp    | YES  |     | NULL              |                             |
| RemoteIP                          | varchar(40)  | YES  |     | NULL              |                             |
| RemoteUA                          | varchar(512) | YES  |     | NULL              |                             |
| MPIn_SadHillStatus                | varchar(10)  | YES  |     | NULL              |                             |
| MPSadHillCemontery                | varchar(5)   | YES  |     | NULL              |                             |
| Bimage                            | mediumtext   | YES  |     | NULL              |                             |
| SFDC_Id                           | varchar(20)  | YES  |     | NULL              |                             |
| Company                           | varchar(255) | NO   |     | [未指定]          |                             |
| jid                               | text         | YES  |     | NULL              |                             |
| Age                               | int(11)      | YES  |     | NULL              |                             |
| blondie                           | int(11)      | YES  |     | NULL              |                             |
| Busi1                             | varchar(255) | YES  |     | NULL              |                             |
| Busi2                             | varchar(255) | YES  |     | NULL              |                             |
| Busi3                             | varchar(255) | YES  |     | NULL              |                             |
| Nenshu                            | int(11)      | YES  |     | NULL              |                             |
| School_name                       | varchar(255) | YES  |     | NULL              |                             |
| Gaku                              | char(4)      | YES  |     | NULL              |                             |
| Shinjoa                           | varchar(255) | YES  |     | NULL              |                             |
| Toeic                             | int(11)      | YES  |     | NULL              |                             |
| Speaking                          | varchar(10)  | YES  |     | NULL              |                             |
| Writing                           | varchar(10)  | YES  |     | NULL              |                             |
| Company1                          | varchar(50)  | YES  |     | NULL              |                             |
| Post1                             | varchar(50)  | YES  |     | NULL              |                             |
| Kimbeley1                         | varchar(20)  | YES  |     | NULL              |                             |
| Kimbeley1_end                     | varchar(20)  | YES  |     | NULL              |                             |
| Keiken1                           | varchar(100) | YES  |     | NULL              |                             |
| Shokumu1                          | text         | YES  |     | NULL              |                             |
| Company2                          | varchar(50)  | YES  |     | NULL              |                             |
| Post2                             | varchar(50)  | YES  |     | NULL              |                             |
| Kinz2                             | varchar(20)  | YES  |     | NULL              |                             |
| Kinz2_end                         | varchar(20)  | YES  |     | NULL              |                             |
| Keiken2                           | varchar(100) | YES  |     | NULL              |                             |
| Shokumu2                          | text         | YES  |     | NULL              |                             |
| Company3                          | varchar(50)  | YES  |     | NULL              |                             |
| Post3                             | varchar(50)  | YES  |     | NULL              |                             |
| Kinz3                             | varchar(20)  | YES  |     | NULL              |                             |
| Kinz3_end                         | varchar(20)  | YES  |     | NULL              |                             |
| GenjiGPS3                         | varchar(100) | YES  |     | NULL              |                             |
| Shok3                             | text         | YES  |     | NULL              |                             |
| hopeList                          | varchar(255) | YES  |     | NULL              |                             |
| Message                           | text         | YES  |     | NULL              |                             |
| ap                                | varchar(255) | YES  |     | NULL              |                             |
| vo                                | varchar(64)  | YES  |     | NULL              |                             |
| status_c                          | varchar(255) | YES  |     | NULL              |                             |
| UserLastModifiedDate              | timestamp    | YES  |     | NULL              |                             |
| MPIn_candidateCharge              | varchar(10)  | YES  |     | NULL              |                             |
| CmCode                            | varchar(11)  | YES  |     | NULL              |                             |
+-----------------------------------+--------------+------+-----+-------------------+-----------------------------+
89 rows in set (0.01 sec)

Comments

Popular posts from this blog

AWS Elasticache Memcached connection

https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/accessing-elasticache.html#access-from-outside-aws http://hourlyapps.blogspot.com/2010/06/examples-of-memcached-commands.html Access memcached https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/GettingStarted.AuthorizeAccess.html Zip include hidden file https://stackoverflow.com/questions/12493206/zip-including-hidden-files phpmemcachedadmin ~ phpMyAdmin or phpPgAdmin ... telnet mycachecluster.eaogs8.0001.usw2.cache.amazonaws.com 11211 stats items stats cachedump 27 100 https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/VPCs.EC.html https://lzone.de/cheat-sheet/memcached VPC ID Security Group ID (sg-...) Cluster: The identifier for the cluster memcached1 Creation Time: The time (UTC) when the cluster was created January 9, 2019 at 11:47:16 AM UTC+7 Configuration Endpoint: The configuration endpoint of the cluster memcached1.ahgofe.cfg.usw1.cache.amazonaws.com:11211 St...

Notes Windows 10 Virtualbox config, PHP Storm Japanese, custom PHP, Apache build, Postgresql

 cmd => Ctrl + Shift + Enter mklink "C:\Users\HauNT\Videos\host3" "C:\Windows\System32\drivers\etc\hosts" https://www.quora.com/How-to-create-a-router-in-php https://serverfault.com/questions/225155/virtualbox-how-to-set-up-networking-so-both-host-and-guest-can-access-internet 1 NAT + 1 host only config https://unix.stackexchange.com/questions/115464/how-to-properly-set-up-2-network-interfaces-in-centos-running-in-virtualbox DEVICE=eth0 TYPE=Ethernet #BOOTPROTO=dhcp BOOTPROTO=none #IPADDR=10.9.11.246 #PREFIX=24 #GATEWAY=10.9.11.1 #IPV4_FAILURE_FATAL=yes #HWADDR=08:00:27:CC:AC:AC ONBOOT=yes NAME="System eth0" [root@localhost www]# cat /etc/sysconfig/network-scripts/ifcfg-eth1 # Advanced Micro Devices, Inc. [AMD] 79c970 [PCnet32 LANCE] DEVICE=eth1 IPADDR=192.168.56.28 <= no eff => auto like DHCP #GATEWAY=192.168.56.1 #BOOTPROTO=dhcp BOOTPROTO=static <= no eff ONBOOT=yes HWADDR=08:00:27:b4:20:10 [root@localhost www]# ...

Rocket.Chat DB schema

_raix_push_notifications avatars.chunks avatars.files instances meteor_accounts_loginServiceConfiguration meteor_oauth_pendingCredentials meteor_oauth_pendingRequestTokens migrations rocketchat__trash rocketchat_cron_history rocketchat_custom_emoji rocketchat_custom_sounds rocketchat_import rocketchat_integration_history rocketchat_integrations rocketchat_livechat_custom_field rocketchat_livechat_department rocketchat_livechat_department_agents rocketchat_livechat_external_message rocketchat_livechat_inquiry rocketchat_livechat_office_hour rocketchat_livechat_page_visited rocketchat_livechat_trigger rocketchat_message rocketchat_oauth_apps rocketchat_oembed_cache rocketchat_permissions rocketchat_raw_imports rocketchat_reports rocketchat_roles rocketchat_room rocketchat_settings rocketchat_smarsh_history rocketchat_statistics rocketchat_subscription rocketchat_uploads system.indexes users usersSessions https://rocket.chat/docs/developer-guides/sc...