CREATE TABLE documentation.entity_master ( em_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, em_name varchar(150) DEFAULT NULL, belongs_to enum('individiual','orginization','department') DEFAULT NULL, record_type enum('single','multiple') DEFAULT NULL, data_table_id int(11) DEFAULT NULL, status int(1) unsigned DEFAULT '1', inserted_by bigint(20) unsigned DEFAULT NULL, inserted_date datetime DEFAULT NULL, updated_by bigint(20) unsigned DEFAULT NULL, updated_date datetime DEFAULT NULL, PRIMARY KEY (em_id));



INSERT INTO documentation.entity_master(em_name, belongs_to,record_type ,data_table_id,status) VALUES ('Journal Papers','individiual','multiple','1',1),('Events Attended','individiual','multiple','1',1),('Paper Presentation','individiual','multiple','1',1),('Proposal for Funded Project','individiual','multiple','1',1),('External Person/VIP Visit','individiual','multiple','1',1),('MoU','department','multiple','1',1),('Faculty Guest Lecture','individiual','multiple','1',1),('PhD Guidance','individiual','multiple','1',1),('DC Memeber for Phd Candidate','individiual','multiple','1',1),('Reviewer-Conferences','individiual','multiple','1',1),('Reviewer-Journals','individiual','multiple','1',1),('Books/Book Chapters','individiual','multiple','1',1),('Patents','individiual','multiple','1',1),('Events Organized','individiual','multiple','1',1),('Student Academic Project Work','individiual','multiple','1',1),('Area of Expertise','individiual','multiple','1',1),('Staff Industrial Visit','individiual','multiple','1',1),('Awards','individiual','multiple','1',1),('Memo','individiual','multiple','1',1),('Online Courses','individiual','multiple','1',1),('Industry Counsultancy Project Details','individiual','multiple','1',1),('Center of Excellence','individiual','multiple','1',1),('Notable Acheivements','individiual','multiple','1',1),('Startup Ideas','individiual','multiple','1',1),('External Faculty Contact','individiual','multiple','1',1),('PhD Higher Studies','individiual','multiple','1',1),('Meeting','individiual','multiple','1',1),('E Content Developed','individiual','multiple','1',1),('Professional Body Membership','individiual','multiple','1',1),('MPhil Guidance','individiual','multiple','1',1),('DC Memeber for MPhil Candidate','individiual','multiple','1',1); /* SELECT CONCAT('INSERT INTO documentation.entity_master(em_name, belongs_to,record_type ,data_table_id,status) VALUES ',valuestext,';') FROM (SELECT GROUP_CONCAT('(\'',em_name,'\',\'',belongs_to,'\',\'',record_type,'\',\'',data_table_id,'\',1)' ORDER BY em_id) valuestext FROM documentation.`entity_master` GROUP BY inserted_by) a */




Download Queries