/*
SQLyog Ultimate v9.63 
MySQL - 5.7.39-log : Database - atsvssmc_data
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`atsvssmc_data` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `atsvssmc_data`;

/*Table structure for table `research` */

DROP TABLE IF EXISTS `research`;

CREATE TABLE `research` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `org_id` int(10) NOT NULL,
  `is_active` int(10) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `uid` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `research` */

insert  into `research`(`id`,`name`,`org_id`,`is_active`,`date`,`time`,`uid`) values (1,'Paper Publications',1,1,'2019-09-24','00:00:01',1),(2,'Journal of Siddha(JOS)',1,1,'2019-09-24','00:00:01',1),(3,'Reference Documents',1,1,'2019-09-24','00:00:01',1),(4,'Research Procedure',1,1,'2019-09-24','00:00:01',1),(5,'Ongoing Projects',1,1,'2019-09-24','00:00:01',1),(6,'Completed Projects',1,1,'2019-09-24','00:00:01',1),(7,'Research Projects',1,1,'2025-02-28','00:00:01',1);

/*Table structure for table `research_details` */

DROP TABLE IF EXISTS `research_details`;

CREATE TABLE `research_details` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `re_id` int(10) NOT NULL,
  `class` varchar(255) NOT NULL,
  `topic` varchar(255) NOT NULL,
  `journal` varchar(255) NOT NULL,
  `commend` text NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `is_active` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;

/*Data for the table `research_details` */

insert  into `research_details`(`id`,`re_id`,`class`,`topic`,`journal`,`commend`,`date`,`time`,`is_active`,`uid`) values (1,2,'22','top','dr xxx','test','2019-09-24','08:15:46',0,1),(2,1,'ONGOING PROJECT','EFFICACY OF TPC IN THE TREATMENT OF DIABETIC WOUND WITH EXTERNAL WASH- A CASE STUDY','','<br>','2019-12-17','11:01:45',0,1),(3,5,'Medicine Trial','Efficacy of Navagraha vellai in treatment of skin diseases','','<br>','2020-11-02','08:01:58',1,1),(4,5,'Medicine Trial','Efficacy of Panchapashana chendooram in the treatment of  Atrhritis and Paralytic disorders','','<br>','2020-11-02','08:08:41',1,1),(5,5,'Medicine Trial','Benefecial effects of sirasu tharai in autism children','','<br>','2020-11-02','08:12:00',1,1),(6,5,'Therapy Trial','Effect of Thappalam in MR and AUTISM Children','','<br>','2020-11-02','08:12:47',1,1),(7,5,'Therapy Trial','Leech therapy ','','<br>','2020-11-02','08:17:30',1,1),(8,1,'Dr S.T.Mini','Invitro anticanceractivity of whole plant ethanolicextract of evolvulus alsinoides against different cell lines','International Journal of research and analytical reviews vol 6/Issue1/Jan - Mar 2019;80-84','<br>','2020-11-03','07:11:47',1,1),(9,1,'Dr S.T.Mini','Gas chromtography-Mass spectroscopy analysis of bio active compounds in the whole plant extract  evolvulus alsinoides','International Journal of basic and applied research , vol 9/Issue1/november/january  2019;584-593,Impact factor-5.86','<br>','2020-11-03','07:15:08',1,1),(10,1,'Dr S.T.Mini','A study of biosynthesis and characterization of silver nano particles from cassia auriculata','International Journal of research and analytical reviews vol 5/Issue4/Oct-Dec 2018;442-447 Impact factor 4.236','<br>','2020-11-03','07:17:53',1,1),(11,5,'LEECH THERAPY FOR OEDEMATOUS CASES IN ATSVS OPD','','','<br>','2022-06-02','11:01:28',1,1),(12,1,'D.Dhanabalan','Siddha treasure \"Raagi porridge\" : A review of traditional and scentific evidences.','Dr.Merish.M>D(S)','<br>','2025-01-21','08:04:06',0,1),(13,1,'','','','<br>','2025-01-21','08:13:43',0,1),(14,1,' Dr.V.Karthick kumar .M.D(s)','Comparative study on ottu noi(Ammai) and chicken pox','','<br>','2025-01-21','08:35:30',0,1),(15,5,'Dr.S.Sunitha.M.D(S)','Body constituent based diet in rainy season(Karkalam)','','<br>','2025-01-21','08:50:03',1,1),(16,5,'Dr.Jeyanthi.M.D(s)','General medical ethics focusing on patient safetyb ','','<br>','2025-01-21','09:09:12',1,1),(17,1,'Aamina Maryam , Guide : Dr.Sunitha.M.D(S)','Prevention and management of PCOS through siddha principles.','','<br>','2025-01-21','10:02:37',1,1),(18,1,'P. Asmi Nisha , Guide : Dr.S.Sunitha.M.D(s)','Holistic approach of siddha to maintain healthy eye','','<br>','2025-01-21','10:06:30',1,1),(19,1,'P. Asmi Nisha, Guide : Dr.S.Sunitha.M.D(s)','The holistic approach of incompatible food combinations.','','<br>','2025-01-21','10:10:44',1,1),(20,1,'S. Nadirah Fathima , Guide : Dr.S.Sunitha.M.D(s)','Literature review on nutritive porridge-panchamutti kanji for malnutrition.','','<br>','2025-01-21','10:14:40',1,1),(21,1,'S. Nadirah Fathima , C. Manju , Guide : Dr.Jeyanthi.M.D(s)','Literature review on effects of meditation on physical and mental health.','','<br>','2025-01-21','10:18:09',1,1),(22,1,'A. Praveena , Guide ','AYUSH Pharmacovigilance: Addressing Challenges in Labeling and dispensing for Enhanced Patient Safety.','','<br>','2025-01-21','10:20:31',0,1),(23,1,'P. Muthamizh, Guide : Dr.S.T.Mini.MSC,MPhill,Phd','Pharmcovigilance and medicine safety containers : Ensuring patients safety','','<br>','2025-01-21','10:24:57',1,1),(24,1,'A. Linto Prathap , Guide : Dr.S.T.Mini.MSC, MPhill,Phd','Debunking myths and enhancing awareness : Pharmacovigilance in AYUSH system of medicine.','','<br>','2025-01-21','10:28:33',1,1),(25,1,'A. Praveena , Guide : Dr.S.Sunitha.M.D(s)','Treatment and management of kalladaippu (Renal stone) through siddha system of treatment medicine.','','<br>','2025-01-21','10:31:05',1,1),(26,1,'A. Linto Prathap , S. Anu Malika, P. Muthamizh , A. Praveena , T.G. Sharmi , Guide : Dr.S.T.Mini.MSC,MPhill,Phd','Phytochemical Analysis of Parangipattai Choornam : A siddha polyherbal formuation for skin diseases.','','<br>','2025-01-21','10:35:25',1,1),(27,1,'P. Muthamizh , Guide : Dr.Vimala.C','Averting premature grey hair using herbal formulation.','','<br>','2025-01-21','10:37:49',1,1),(28,1,'S. Raja Gowri , Guide : Dr.Vimala.C','Exploration of hidden scientific evidence behind ancient cultural practices followed during menstruation.','','<br>','2025-01-21','10:40:45',1,1),(29,1,'G. Rakshikaa , Guide : Dr.S.Sunitha.M.D(s)','Management of post menopausal osteoporosis in lifestyle modification through siddha system of medicine.','','<br>','2025-01-21','10:43:39',1,1),(30,1,'S. Muthusivaraman , A. Linto Prathap , Guide : Dr.Vimala.C','Literature review on Therapeutic value and adherence of millets with  respect to Perumpozhuthu & Sirupozhuthu.','','<br>','2025-01-21','10:47:09',1,1),(31,1,'P. Sabarinathan , Guide : Dr.S.Sunitha.M.D(s) ','Potential memory enhancers (Nootrophic Drugs) in Siddha system - A Literary review','','<br>','2025-01-21','10:50:22',1,1),(32,1,'S. Muthusivaraman , Guide : Dr.S.Sunitha.M.D(s)','Navigating the challenges in AYUSH Pharmacovigilance','','<br>','2025-01-21','10:52:37',1,1),(33,1,'','A Literature review on Phytochemical analysis of Cassia senna in siddha medicine.','','<br>','2025-01-21','10:54:03',1,1),(34,1,'M. Aadila Hussaini , Guide : Dr.S.Sunitha.M.D(s) , Dr.Merish.M.D(S)','Fumigation A boon for siddha system of medicine.','','<br>','2025-01-21','10:57:35',1,1),(35,1,'K. Anupriya , A. Arshatha Fathima  , Guide : Dr.Tamilselvi.M.D(S)','Siddha varmam for treatment of Perarthritis','','<br>','2025-01-21','11:00:17',1,1),(36,1,'A.S. Malavika , R.S. Nikalya , Guide : Dr.Merish.M.D(S)','Historical evidence through literature on millets and it\'s medicinal benefits.','','<br>','2025-01-21','11:05:08',1,1),(37,1,'S. Sakthi Nithya Sree , Guide : Dr.Vimala.C','Ancient knowledge on oil bathing and its effectiveness ancient wisdom and modern solution.','','<br>','2025-01-21','11:07:16',1,1),(38,1,'S.R. Priyasri , Guide : Dr.Mary Marshaline.M.D(S) , Dr.C.Shyfa.M.D(S)','Diet and nutrition - Essential of Menarche','','<br>','2025-01-21','11:09:34',1,1),(39,1,'B. Madhubala , Guide : Dr.Merish.M.D(S)','Evidences of menarche diet-a scientific perspective','','<br>','2025-01-21','11:11:29',1,1),(40,1,'B. Madhubala , Guide : Dr.A.Evangaline green','Siddha science behind traditional cradling','','<br>','2025-01-21','11:13:15',1,1),(41,1,'A.Sri. Subithraa , Guide : Dr.Arun Latha Gold','A review on siddha diagnostic and prognostic tools for identification for communicable diseases','','<br>','2025-01-21','11:15:26',1,1),(42,1,'A.Sri. Subithraa , Guide : Dr.Arun Latha Gold','A Review on siddha principles and diagnostics','','<br>','2025-01-21','11:16:49',1,1),(43,1,'S. Sakthi Nithya Sree , P.A. Majitha sabrin , Guide : Dr.Mary Marshaline.M.D(S) , Dr.C.Shyfa.M.D(S)','Diet, asanas and medicine for the management of polycystic ovarian syndrome.','','<br>','2025-01-21','11:20:35',1,1),(44,1,'S. Abirami , Guide : Dr.G.Jebasingh , Dr.C.Christal Femi , Dr.S.Merish , Dr.Jeenu','Effectiveness of Kalaanthaga Gowri pathangam in the management of Rheumatoid arthritis-Casa series','','<br>','2025-01-21','11:23:50',1,1),(45,1,'S. Abirami , Guide : Dr.S.Merish','The Importance of Millets and Grains in Siddha Dietetics : Oru Pozhuthu and Iru Pozhuthu Unnal','','<br>','2025-01-21','11:25:36',1,1),(46,1,'S. Abirami , Guide : Dr.S.Merish','A Systemic review on benefits of traditional amulet in diagnosis and management of modern diseases.','','<br>','2025-01-21','11:27:38',1,1),(47,1,'S. Abirami , Guide : Dr.S.Merish','Role of siddha medicine in diabetis mellitus','','<br>','2025-01-21','11:28:32',1,1),(48,1,'R. Rasika , Guide : Dr.Santhi.S','Traditional paediatric instrumets','','<br>','2025-01-21','11:30:15',1,1),(49,1,'U.V. Sivanesh Pranav , M.S. Aasnich Joeson , R. Chellaiyapillai , Guide : Dr.Merish.S','Knowledge, Attitude and Practice of Millets among Adult age group A Cross-sectional study, 2023','','<br>','2025-01-21','11:33:10',1,1),(50,1,'S . Aswathi , P. Kavya , S. Sowmiya , Guide : Dr.Santhi.S','Nithiraiinmai (insomnia)-the silent sleep thief','','<br>','2025-01-21','11:35:06',1,1),(51,1,'M.S. Aasnich Joeson.M.S , Guide : Dr.Venugopal.M.D','Dilemmas in reporting to pharmacovigilance','','<br>','2025-01-21','11:36:51',1,1),(52,1,'R. Rasika , V. Swathee , Nandhini shree , Guide : Dr.Karthick kumar.V , Dr.Santi.S , Dr.Evangaline green.A','Ancient knowledge on oil bathing and it\'s effectiveness with preventive social measures-literature review','','<br>','2025-01-21','11:40:39',1,1),(53,1,'S. Aruna Sri , M. Jeya Kamala , Guide : Dr.S.Merish MD(S)','Millets and Thirithoda Samanam : A Siddha key Diet for Longevity and Vitality','','<br>','2025-01-21','11:42:26',1,1),(54,1,'S. Auna sri , Guide : Dr.S.Santi , Dr. Karthick kumar.V','Effects of pranayamam in respiratory diseases.','','<br>','2025-01-21','11:44:12',1,1),(55,1,'T. Varsini , Guide : Dr.Joshi MD(S)','Treatment of kidney stone in siddha aspect.','','<br>','2025-01-21','11:45:21',1,1),(56,1,'A. Aamina mariyam , Guide : Dr.Joshi MD(S)','Therapeuatic effect of nasiyam in prevention and treatment of sinusitis.','','<br>','2025-01-21','11:47:10',1,1),(57,1,'S. Anumalika , Guide : Dr.Joshi MD(S)','Antenatal care through siddha system.','','<br>','2025-01-21','11:48:22',1,1),(58,1,'P. Muthamizh , F. Judithroy , Guide : Dr.Joshi MD(S)','Siddha path to vitality-fasting for body, mind and sprit.','','<br>','2025-01-21','11:49:55',1,1),(59,1,'D. Dhanabalan, Guide : Dr.Merish.M.D(S), Dr.S.T.Mini. MSC, MPhill, Phd','Siddha treasure \"Raagi porridge\" : A review of traditional and scientific evidences. ','','<br>','2025-02-19','04:30:31',1,1),(60,1,'S.Muthusivaraman, D.Dhanabalan, A.Linto Prathap, Guide : Dr.V.Karthick kumar.M.D(S)','Comparative study on ottu noi(Ammai) and chicken pox','','<br>','2025-02-19','04:34:30',1,1),(61,1,'A.Praveena, Guide : Dr.S.T.Mini.MSC, MPhill, Phd','AYUSH Pharmacovigilance : Addressing Challenges in Labeling and dispensing for Enhanced Patient Safety','','<br>','2025-02-19','04:37:53',1,1),(62,1,'Dr. A.K. Asha, Dr. I. Joshi','Biochemical analysis of karrunchooraipattai chooranam used in the management.','','<br>','2025-02-20','06:21:59',1,1),(63,1,'Dr. I. Joshi, Dr. A.K. Asha','Anti Noeiception, Analgesic and Anti inflammatory activities of karunchoorai chooranam using various animal models.','','<br>','2025-02-20','06:23:38',1,1),(64,7,'a','a','a','a','2025-02-28','10:47:31',0,1);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
