How to layout the data structure as follows: SET & nbsp; FOREIGN_KEY_CHECKS = 0; -- & nbsp; ------------------------------ & nbsp; Table & nbsp; structure & nbsp; for & nbsp; arp_careset -- & nbs how to layout data in this way
The data structure is as follows:
SET FOREIGN_KEY_CHECKS = 0;
------------------------------
-- Table structure for arp_careset
------------------------------
Create table 'arp _ careset '(
'Id' int (11) not null auto_increment,
'Name' varchar (255) character set utf8 default NULL,
'Typegroup' varchar (255) character set utf8 default NULL,
'Remark' varchar (255) character set utf8 default NULL,
'Deleted' int (11) default NULL,
'Modified _ by' int (11) default NULL,
'Createtime' datetime default NULL,
'Created _ by' int (11) default NULL,
'Lastmodifytime' datetime default NULL,
Primary key ('id ')
) ENGINE = InnoDB AUTO_INCREMENT = 40 default charset = latin1;
------------------------------
-- Records
------------------------------
Insert into 'arp _ careset' VALUES ('1', 'body', 'dissect-position', 'surface ', '1', null, '2017-00-00 00:00:00 ', '0', '2017-00-00 00:00:00 ');
Insert into 'arp _ careset' VALUES ('2', 'lymph node ', 'dissect-position', 'lymph', '1', null, '2017-00-00 00:00:00 ', '0', '2017-00-00 00:00:00 ');
Insert into 'arp _ careset' VALUES ('3', 'head', 'dissect-position', 'head', '1', null, '2017-00-00 00:00:00 ', '0', '2017-00-00 00:00:00 ');
Insert into 'arp _ careset' VALUES ('4', 'thoracic ', 'dissect-position', 'chest', '1', null, '2017-00-00 00:00:00 ', '0', '2017-00-00 00:00:00 ');
Insert into 'arp _ careset' VALUES ('5', 'abdominal ', 'dissect-position', 'abdomen', '1', null, '2017-00-00 00:00:00 ', '0', '2017-00-00 00:00:00 ');
Insert into 'arp _ careset' VALUES ('6', 'nutritional status', 'position-surface ', '', '1', null, '2017-00-00 00:00:00 ', '0', '2017-00-00 00:00:00 ');
Insert into 'arp _ careset' VALUES ('7', 'secretions ', 'position-surface', '', '1', null, '2014-00-00 00:00:00 ', '0', null );
Insert into 'arp _ careset' VALUES ('8', 'hair', 'position-surface ', '', '1', null, '2014-00-00 00:00:00 ', '0', null );
Insert into 'arp _ careset' VALUES ('9', 'Skin ', 'position-surface', '', '1', null, '2014-00-00 00:00:00 ', '0', null );
Insert into 'arp _ careset' VALUES ('10', 'eye/eyes', 'position-surface ', '', '1', null, '2014-00-00 00:00:00 ', '0', null );
Insert into 'arp _ careset' VALUES ('11', 'Limbs/tail', 'position-surface ', '', '1', null, '2014-00-00 00:00:00 ', '0', null );
Insert into 'arp _ careset' VALUES ('12', 'breast ', 'position-surface', '', '1', null, '2014-00-00 00:00:00 ', '0', null );
Insert into 'arp _ careset' VALUES ('13', 'external genital ', 'position-surface', '', '1', null, '2014-00-00 00:00:00 ', '0', null );
Insert into 'arp _ careset' VALUES ('14', 'anal ', 'position-surface', '', '1', null, '2014-00-00 00:00:00 ', '0', null );
Insert into 'arp _ careset' VALUES ('15', 'armpit lymph node ', 'position-lymph', '', '1', null, '2014-00-00 00:00:00 ', '0', null );