API tools faq
paste
VXP

bd1

VXP
Sep 12th, 2016
212
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 4.54 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="utf-8" ?>
  2. <!-- SQL XML created by WWW SQL Designer, https://github.com/ondras/wwwsqldesigner/ -->
  3. <!-- Active URL: http://ondras.zarovi.cz/sql/demo/ -->
  4. <sql>
  5. <datatypes db="mysql">
  6.     <group label="Numeric" color="rgb(238,238,170)">
  7.         <type label="Integer" length="0" sql="INTEGER" quote=""/>
  8.         <type label="TINYINT" length="0" sql="TINYINT" quote=""/>
  9.         <type label="SMALLINT" length="0" sql="SMALLINT" quote=""/>
  10.         <type label="MEDIUMINT" length="0" sql="MEDIUMINT" quote=""/>
  11.         <type label="INT" length="0" sql="INT" quote=""/>
  12.         <type label="BIGINT" length="0" sql="BIGINT" quote=""/>
  13.         <type label="Decimal" length="1" sql="DECIMAL" re="DEC" quote=""/>
  14.         <type label="Single precision" length="0" sql="FLOAT" quote=""/>
  15.         <type label="Double precision" length="0" sql="DOUBLE" re="DOUBLE" quote=""/>
  16.     </group>
  17.  
  18.     <group label="Character" color="rgb(255,200,200)">
  19.         <type label="Char" length="1" sql="CHAR" quote="'"/>
  20.         <type label="Varchar" length="1" sql="VARCHAR" quote="'"/>
  21.         <type label="Text" length="0" sql="MEDIUMTEXT" re="TEXT" quote="'"/>
  22.         <type label="Binary" length="1" sql="BINARY" quote="'"/>
  23.         <type label="Varbinary" length="1" sql="VARBINARY" quote="'"/>
  24.         <type label="BLOB" length="0" sql="BLOB" re="BLOB" quote="'"/>
  25.     </group>
  26.  
  27.     <group label="Date &amp; Time" color="rgb(200,255,200)">
  28.         <type label="Date" length="0" sql="DATE" quote="'"/>
  29.         <type label="Time" length="0" sql="TIME" quote="'"/>
  30.         <type label="Datetime" length="0" sql="DATETIME" quote="'"/>
  31.         <type label="Year" length="0" sql="YEAR" quote=""/>
  32.         <type label="Timestamp" length="0" sql="TIMESTAMP" quote="'"/>
  33.     </group>
  34.    
  35.     <group label="Miscellaneous" color="rgb(200,200,255)">
  36.         <type label="ENUM" length="1" sql="ENUM" quote=""/>
  37.         <type label="SET" length="1" sql="SET" quote=""/>
  38.         <type label="Bit" length="0" sql="bit" quote=""/>
  39.     </group>
  40. </datatypes><table x="401" y="84" name="Сотрудник">
  41. <row name="id" null="1" autoincrement="1">
  42. <datatype>INTEGER</datatype>
  43. <default>NULL</default></row>
  44. <row name="Имя" null="1" autoincrement="0">
  45. <datatype>MEDIUMTEXT</datatype>
  46. <default>NULL</default></row>
  47. <row name="Фамилия" null="1" autoincrement="0">
  48. <datatype>MEDIUMTEXT</datatype>
  49. <default>NULL</default></row>
  50. <row name="Отчество" null="1" autoincrement="0">
  51. <datatype>MEDIUMTEXT</datatype>
  52. <default>NULL</default></row>
  53. <row name="Возраст" null="1" autoincrement="0">
  54. <datatype>MEDIUMTEXT</datatype>
  55. <default>NULL</default></row>
  56. <row name="id_Цеха" null="1" autoincrement="0">
  57. <datatype>INTEGER</datatype>
  58. <default>NULL</default></row>
  59. <row name="Должность" null="1" autoincrement="0">
  60. <datatype>MEDIUMTEXT</datatype>
  61. <default>NULL</default></row>
  62. <row name="Пол" null="1" autoincrement="0">
  63. <datatype>MEDIUMTEXT</datatype>
  64. <default>NULL</default></row>
  65. <key type="PRIMARY" name="id">
  66. <part>id</part>
  67. </key>
  68. </table>
  69. <table x="567" y="93" name="Цеха">
  70. <row name="id_Цеха" null="1" autoincrement="1">
  71. <datatype>INTEGER</datatype>
  72. <default>NULL</default></row>
  73. <row name="Название" null="1" autoincrement="0">
  74. <datatype>MEDIUMTEXT</datatype>
  75. <default>NULL</default></row>
  76. <row name="Руководитель" null="1" autoincrement="0">
  77. <datatype>MEDIUMTEXT</datatype>
  78. <default>NULL</default><comment>Является сотрудником</comment>
  79. </row>
  80. <key type="PRIMARY" name="">
  81. <part>id_Цеха</part>
  82. </key>
  83. </table>
  84. <table x="834" y="153" name="Стоянки">
  85. <row name="id_Стоянки" null="1" autoincrement="1">
  86. <datatype>INTEGER</datatype>
  87. <default>NULL</default></row>
  88. <row name="Название" null="1" autoincrement="0">
  89. <datatype>MEDIUMTEXT</datatype>
  90. <default>NULL</default></row>
  91. <row name="id_Руководителя" null="1" autoincrement="0">
  92. <datatype>INTEGER</datatype>
  93. <default>NULL</default><comment>* сотрудника</comment>
  94. </row>
  95. <key type="PRIMARY" name="">
  96. <part>id_Стоянки</part>
  97. </key>
  98. </table>
  99. <table x="837" y="281" name="Транспорт">
  100. <row name="id" null="1" autoincrement="1">
  101. <datatype>INTEGER</datatype>
  102. <default>NULL</default></row>
  103. <row name="Название" null="1" autoincrement="0">
  104. <datatype>MEDIUMTEXT</datatype>
  105. <default>NULL</default></row>
  106. <row name="id_Стоянки" null="1" autoincrement="0">
  107. <datatype>INTEGER</datatype>
  108. <default>NULL</default></row>
  109. <row name="id_Сотрудника" null="1" autoincrement="0">
  110. <datatype>INTEGER</datatype>
  111. <default>NULL</default></row>
  112. <key type="PRIMARY" name="">
  113. <part>id</part>
  114. </key>
  115. </table>
  116. </sql>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!