ER-Diagram: How To Publish Examples Here On This Forum

[dil_bert]

hello dear all , 

 

topic: questions with some eplanations - for db-related areas and topics - export er-diagram 

 

 i want to post questions with some eplanations - for db-related areas and topics.  Well i know that there are some good tools out there which help here alot. 

The question is : how to export the data so that i can implement the data into a forum like this !?! 

 

Question can i export the data form https://www.draw.io/  to this forum!? 

 

Love to hear from you 

regards 

 

 

 

[Barand]

The reply form lists accepted file types

Quote

Accepted file types gif, jpeg, jpe, jpg, png, mp4, 3gp, mov, ogg, ogv, mpg, mpeg, flv, webm, wmv, avi, m4v

EG

Text, such as a SQL data dump, can be placed inside (<>) code frames. EG

DROP TABLE IF EXISTS `result`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `result` (
  `pupilid` int(10) unsigned NOT NULL,
  `subjectid` int(10) unsigned NOT NULL,
  `pcent` tinyint(4) DEFAULT '0',
  `schoolyear` int(4) NOT NULL DEFAULT '0',
  `resultid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`resultid`),
  KEY `index_2` (`pupilid`),
  KEY `index_3` (`subjectid`)
) ENGINE=MyISAM AUTO_INCREMENT=163 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `result`
--

LOCK TABLES `result` WRITE;
/*!40000 ALTER TABLE `result` DISABLE KEYS */;
INSERT INTO `result` VALUES (1,1,78,2014,1),(3,1,58,2014,2),(4,1,54,2014,3),(8,1,91,2014,4),(9,1,62,2014,5),
(11,1,77,2014,6),(13,1,60,2014,7),(14,1,64,2014,8),(15,1,93,2014,9),(18,1,87,2014,10),
(19,1,60,2014,11),(20,1,81,2014,12),(1,2,87,2014,13),(2,2,53,2014,14),(4,2,87,2014,15),
(12,2,93,2014,16),(14,2,62,2014,17),(15,2,74,2014,18),(16,2,90,2014,19),(17,2,87,2014,20),
(21,2,73,2014,21),(22,2,53,2014,22),(23,2,86,2014,23),(2,3,88,2014,24),(5,3,85,2014,25),
(6,3,68,2014,26),(8,3,78,2014,27),(12,3,50,2014,28),(19,3,53,2014,29),(7,4,69,2014,30),
(10,4,90,2014,31),(13,4,57,2014,32),(19,4,57,2014,33),(22,4,62,2014,34),(23,4,92,2014,35),
(24,4,95,2014,36),(1,5,79,2014,37),(2,5,76,2014,38),(5,5,94,2014,39),(7,5,58,2014,40),
(9,5,50,2014,41),(11,5,68,2014,42),(14,5,51,2014,43),(18,5,94,2014,44),(20,5,86,2014,45),
(21,5,52,2014,46),(22,5,87,2014,47),(23,5,53,2014,48),(24,5,86,2014,49),(6,6,87,2014,50),
(10,6,81,2014,51),(13,6,51,2014,52),(22,6,54,2014,53),(23,6,67,2014,54),(24,6,77,2014,55),
(6,7,92,2014,56),(9,7,89,2014,57),(10,7,74,2014,58),(14,7,53,2014,59),(18,7,86,2014,60),
(21,7,85,2014,61),(2,8,71,2014,62),(4,8,52,2014,63),(5,8,89,2014,64),(7,8,58,2014,65),
(11,8,63,2014,66),(16,8,93,2014,67),(17,8,91,2014,68),(20,8,82,2014,69),(21,8,87,2014,70),
(24,8,93,2014,71),(3,9,66,2014,72),(4,9,90,2014,73),(5,9,69,2014,74),(6,9,69,2014,75),
(9,9,87,2014,76),(13,9,91,2014,77),(15,9,54,2014,78),(17,9,84,2014,79),(18,9,72,2014,80),
(19,9,58,2014,81),(1,1,73,2015,82),(3,1,95,2015,83),(4,1,84,2015,84),(8,1,73,2015,85),
(9,1,93,2015,86),(11,1,71,2015,87),(13,1,93,2015,88),(14,1,79,2015,89),(15,1,94,2015,90),
(18,1,60,2015,91),(19,1,71,2015,92),(20,1,77,2015,93),(1,2,74,2015,94),(2,2,81,2015,95),
(4,2,85,2015,96),(12,2,83,2015,97),(14,2,63,2015,98),(15,2,81,2015,99),(16,2,82,2015,100),
(17,2,70,2015,101),(21,2,82,2015,102),(22,2,66,2015,103),(23,2,60,2015,104),(2,3,82,2015,105),
(5,3,96,2015,106),(6,3,96,2015,107),(8,3,93,2015,108),(12,3,82,2015,109),(19,3,73,2015,110),
(7,4,94,2015,111),(10,4,81,2015,112),(13,4,62,2015,113),(19,4,84,2015,114),(22,4,60,2015,115),
(23,4,64,2015,116),(24,4,83,2015,117),(1,5,84,2015,118),(2,5,77,2015,119),(5,5,71,2015,120),
(7,5,66,2015,121),(9,5,95,2015,122),(11,5,64,2015,123),(14,5,92,2015,124),(18,5,92,2015,125),
(20,5,88,2015,126),(21,5,65,2015,127),(22,5,77,2015,128),(23,5,93,2015,129),(24,5,61,2015,130),
(6,6,79,2015,131),(10,6,77,2015,132),(13,6,88,2015,133),(22,6,76,2015,134),(23,6,93,2015,135),
(24,6,62,2015,136),(6,7,86,2015,137),(9,7,69,2015,138),(10,7,69,2015,139),(14,7,76,2015,140),
(18,7,77,2015,141),(21,7,96,2015,142),(2,8,78,2015,143),(4,8,77,2015,144),(5,8,95,2015,145),
(7,8,68,2015,146),(11,8,74,2015,147),(16,8,67,2015,148),(17,8,91,2015,149),(20,8,83,2015,150),
(21,8,80,2015,151),(24,8,93,2015,152),(3,9,88,2015,153),(4,9,66,2015,154),(5,9,81,2015,155),
(6,9,73,2015,156),(9,9,61,2015,157),(13,9,66,2015,158),(15,9,86,2015,159),(17,9,60,2015,160),
(18,9,94,2015,161),(19,9,79,2015,162);
/*!40000 ALTER TABLE `result` ENABLE KEYS */;
UNLOCK TABLES;

 

[dil_bert]

hello dear Barand 

many thanks - as allways your answers are excellent - and just overwhelming!  I am happy and glad to see such a convincing answer. 

 

 

 

i also had a look at the ASCII generators for ERD diagrams (perhaps that fit well within markup syntax)?

For example, that could generate something like the diagram below: to create such diagrams i guess such a tool might be helpfull: http://asciiflow.com/

 

 

[CODE]

 ---------
 |  Hai  |
 ---------
     |
     |
    /|\
 ---------         ------------          ---------
 |  Foo  |-------< |  FooBar  | >------- |  Bar  |
 ---------         ------------          ---------
    \|/
     |
     |
 ---------
 |  Bai  |
 ---------
 
[/CODE]

 

Edited August 21, 2019 by dil_bert