-- Structure for view `viewadmin`
--
DROP TABLE IF EXISTS `viewadmin`;
CREATE ALGORITHM=UNDEFINED DEFINER=`journal`@`localhost` SQL SECURITY DEFINER VIEW `journal_web`.`viewadmin` AS select `journal_web`.`send_to_check`.`sendID` AS `sendID`,`journal_web`.`send_to_check`.`sendDate` AS `sendDate`,`journal_web`.`send_to_check`.`JouranlID` AS `JouranlID`,`journal_web`.`send_to_check`.`terms` AS `terms`,`journal_web`.`send_to_check`.`sendTo` AS `sendTo`,`journal_web`.`send_to_check`.`checkfile` AS `checkfile`,`journal_web`.`send_to_check`.`checktext` AS `checktext`,`journal_web`.`send_to_check`.`checkstatus` AS `checkstatus`,`journal_web`.`send_to_check`.`checkdate` AS `checkdate`,`journal_web`.`send_to_check`.`viewuser` AS `viewuser`,`journal_web`.`insert_member`.`idcard` AS `idcard`,`journal_web`.`insert_member`.`TitleName` AS `TitleName`,`journal_web`.`insert_member`.`Name` AS `Name`,`journal_web`.`insert_member`.`Telephone` AS `Telephone`,`journal_web`.`insert_member`.`Email` AS `Email`,`journal_web`.`insert_member`.`Active` AS `Active`,`journal_web`.`send_to_check`.`UserID` AS `UserID`,`journal_web`.`insert_member`.`PositionID` AS `PositionID`,`journal_web`.`insert_journal`.`JouranlNumber` AS `JouranlNumber`,`journal_web`.`insert_journal`.`TitleThai` AS `TitleThai`,`journal_web`.`send_to_check_detail`.`choice1` AS `choice1`,`journal_web`.`send_to_check_detail`.`choice2` AS `choice2`,`journal_web`.`send_to_check_detail`.`choice3` AS `choice3`,`journal_web`.`send_to_check_detail`.`choice4` AS `choice4`,`journal_web`.`send_to_check_detail`.`choice5` AS `choice5`,`journal_web`.`send_to_check_detail`.`choice6` AS `choice6`,`journal_web`.`send_to_check_detail`.`choice7` AS `choice7` from (((`journal_web`.`send_to_check` join `journal_web`.`insert_member` on((`journal_web`.`send_to_check`.`UserID` = `journal_web`.`insert_member`.`UserID`))) join `journal_web`.`insert_journal` on((`journal_web`.`insert_journal`.`JouranlID` = `journal_web`.`send_to_check`.`JouranlID`))) join `journal_web`.`send_to_check_detail` on((`journal_web`.`send_to_check_detail`.`sendID` = `journal_web`.`send_to_check`.`sendID`)));