API tools faq
paste
Guest User

Untitled

a guest
Jun 18th, 2018
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.45 KB | None | 0 0
raw download clone embed print report
  1. Grafcet:
  2. tableName: iwash_grafcet
  3. columns:
  4. grafcet_id:
  5. type: integer(4)
  6. primary: true
  7. autoincrement: true
  8. grafcet_type_id:
  9. type: integer(4)
  10. notnull: true
  11. drum_id:
  12. type: integer(4)
  13. relations:
  14. GrafcetType:
  15. local: grafcet_type_id
  16. foreign: grafcet_type_id
  17. type: one
  18. Token:
  19. local: grafcet_id
  20. foreign: grafcet_id
  21. type: many
  22. options:
  23. type: INNODB
  24. collate: utf8_unicode_ci
  25. charset: utf8
  26.  
  27. GrafcetType:
  28. tableName: iwash_grafcet_type
  29. columns:
  30. grafcet_type_id:
  31. type: integer(4)
  32. primary: true
  33. autoincrement: true
  34. name:
  35. type: string(255)
  36. unique: true
  37. initial_step_id:
  38. type: integer(4)
  39. relations:
  40. Grafcet:
  41. local: grafcet_type_id
  42. foreign: grafcet_type_id
  43. type: many
  44. Step:
  45. local: grafcet_type_id
  46. foreign: grafcet_type_id
  47. type: many
  48. Condition:
  49. local: grafcet_type_id
  50. foreign: grafcet_type_id
  51. type: many
  52. InitialStep:
  53. class: Step
  54. local: initial_step_id
  55. foreign: step_id
  56. type: one
  57. options:
  58. type: INNODB
  59. collate: utf8_unicode_ci
  60. charset: utf8
  61.  
  62. Step:
  63. tableName: iwash_step
  64. columns:
  65. step_id:
  66. type: integer(4)
  67. primary: true
  68. autoincrement: true
  69. function_name: string(255)
  70. description: string(255)
  71. grafcet_type_id:
  72. type: integer(4)
  73. relations:
  74. Token:
  75. local: step_id
  76. foreign: step_id
  77. type: many
  78. GrafcetType:
  79. local: grafcet_type_id
  80. foreign: grafcet_type_id
  81. type: one
  82. StepCondition:
  83. local: step_id
  84. foreign: step_id
  85. type: many
  86. ConditionStep:
  87. local: step_id
  88. foreign: step_id
  89. type: many
  90. options:
  91. type: INNODB
  92. collate: utf8_unicode_ci
  93. charset: utf8
  94.  
  95. StepCondition:
  96. tableName: iwash_step_condition
  97. columns:
  98. step_id:
  99. type: integer(4)
  100. notnull: true
  101. condition_id:
  102. type: integer(4)
  103. notnull: true
  104. relations:
  105. Step:
  106. local: step_id
  107. foreign: step_id
  108. type: one
  109. Condition:
  110. local: condition_id
  111. foreign: condition_id
  112. type: one
  113. options:
  114. type: INNODB
  115. collate: utf8_unicode_ci
  116. charset: utf8
  117.  
  118. Token:
  119. tableName: iwash_token
  120. columns:
  121. grafcet_id:
  122. type: integer(4)
  123. primary: true
  124. step_id:
  125. type: integer(4)
  126. primary: true
  127. drum_id:
  128. type: integer(4)
  129. position_id:
  130. type: integer(4)
  131. relations:
  132. Grafcet:
  133. local: grafcet_id
  134. foreign: grafcet_id
  135. type: one
  136. Step:
  137. local: step_id
  138. foreign: step_id
  139. type: one
  140. Drum:
  141. local: drum_id
  142. foreign: drum_id
  143. type: one
  144. Position:
  145. local: position_id
  146. foreign: position_id
  147. type: one
  148. options:
  149. type: INNODB
  150. collate: utf8_unicode_ci
  151. charset: utf8
  152.  
  153. Condition:
  154. tableName: iwash_condition
  155. columns:
  156. condition_id:
  157. type: integer(4)
  158. primary: true
  159. autoincrement: true
  160. function_name: string(255)
  161. description: string(255)
  162. grafcet_type_id:
  163. type: integer(4)
  164. relations:
  165. GrafcetType:
  166. local: grafcet_type_id
  167. foreign: grafcet_type_id
  168. type: one
  169. StepCondition:
  170. local: condition_id
  171. foreign: condition_id
  172. type: many
  173. ConditionStep:
  174. local: condition_id
  175. foreign: condition_id
  176. type: many
  177. options:
  178. type: INNODB
  179. collate: utf8_unicode_ci
  180. charset: utf8
  181.  
  182. ConditionStep:
  183. tableName: iwash_condition_step
  184. columns:
  185. condition_id:
  186. type: integer(4)
  187. notnull: true
  188. step_id:
  189. type: integer(4)
  190. notnull: true
  191. relations:
  192. Step:
  193. local: step_id
  194. foreign: step_id
  195. type: one
  196. Condition:
  197. local: condition_id
  198. foreign: condition_id
  199. type: one
  200. options:
  201. type: INNODB
  202. collate: utf8_unicode_ci
  203. charset: utf8
  204.  
  205. Machine:
  206. tableName: iwash_machine
  207. columns:
  208. machine_id:
  209. type: integer(4)
  210. primary: true
  211. autoincrement: true
  212. name: string(255)
  213. ip: string(255)
  214. grafcet_type_id:
  215. type: integer(4)
  216. relations:
  217. GrafcetType:
  218. local: grafcet_type_id
  219. foreign: grafcet_type_id
  220. type: one
  221. options:
  222. type: INNODB
  223. collate: utf8_unicode_ci
  224. charset: utf8
  225.  
  226. Position:
  227. tableName: iwash_position
  228. columns:
  229. position_id:
  230. type: integer(4)
  231. primary: true
  232. autoincrement: true
  233. description:
  234. type: string(500)
  235. notnull: false
  236. machine_id:
  237. type: integer(4)
  238. relations:
  239. Machine:
  240. local: machine_id
  241. foreign: machine_id
  242. type: one
  243. options:
  244. type: INNODB
  245. collate: utf8_unicode_ci
  246. charset: utf8
  247.  
  248. Drum:
  249. tableName: iwash_drum
  250. columns:
  251. drum_id:
  252. type: integer(4)
  253. primary: true
  254. autoincrement: true
  255. serial_num:
  256. type: string(255)
  257. position_id:
  258. type: integer(4)
  259. notnull: false
  260. machine_id:
  261. type: integer(4)
  262. relations:
  263. Machine:
  264. local: machine_id
  265. foreign: machine_id
  266. type: one
  267. Position:
  268. local: position_id
  269. foreign: position_id
  270. type: one
  271. options:
  272. type: INNODB
  273. collate: utf8_unicode_ci
  274. charset: utf8
  275.  
  276. Unit:
  277. tableName: iwash_unit
  278. columns:
  279. unit_id:
  280. type: integer(4)
  281. primary: true
  282. autoincrement: true
  283. machine_id:
  284. type: integer(4)
  285. station_id:
  286. type: integer(4)
  287. active: boolean
  288. running: boolean
  289. description: string(255)
  290. relations:
  291. Machine:
  292. local: machine_id
  293. foreign: machine_id
  294. type: one
  295. Station:
  296. local: station_id
  297. foreign: station_id
  298. type: one
  299. options:
  300. type: INNODB
  301. collate: utf8_unicode_ci
  302. charset: utf8
  303.  
  304. UnitLoad:
  305. inheritance:
  306. extends: Unit
  307. type: column_aggregation
  308. keyField: unit_type
  309. keyValue: load
  310. columns:
  311. open: boolean
  312. closed: boolean
  313. locked: boolean
  314. unlocked: boolean
  315. relations:
  316. Machine:
  317. local: machine_id
  318. foreign: machine_id
  319. type: one
  320.  
  321. UnitMatrix:
  322. inheritance:
  323. extends: Unit
  324. type: column_aggregation
  325. keyField: unit_type
  326. keyValue: matrix
  327. columns:
  328. row: integer(4)
  329. col: integer(4)
  330. relations:
  331. Machine:
  332. local: machine_id
  333. foreign: machine_id
  334. type: one
  335.  
  336. UnitRobot:
  337. inheritance:
  338. extends: Unit
  339. type: column_aggregation
  340. keyField: unit_type
  341. keyValue: robot
  342. columns:
  343. min_x: integer(4)
  344. min_y: integer(4)
  345. min_z: integer(4)
  346. cur_x: integer(4)
  347. cur_y: integer(4)
  348. cur_z: integer(4)
  349. max_x: integer(4)
  350. max_y: integer(4)
  351. max_z: integer(4)
  352. offset_x: integer(4)
  353. offset_y: integer(4)
  354. offset_z: integer(4)
  355. relations:
  356. Machine:
  357. local: machine_id
  358. foreign: machine_id
  359. type: one
  360.  
  361. UnitWait:
  362. inheritance:
  363. extends: Unit
  364. type: column_aggregation
  365. keyField: unit_type
  366. keyValue: wait
  367. columns:
  368. up: boolean
  369. down: boolean
  370. relations:
  371. Machine:
  372. local: machine_id
  373. foreign: machine_id
  374. type: one
  375.  
  376. UnitWash:
  377. inheritance:
  378. extends: Unit
  379. type: column_aggregation
  380. keyField: unit_type
  381. keyValue: wash
  382. columns:
  383. open: boolean
  384. closed: boolean
  385. relations:
  386. Machine:
  387. local: machine_id
  388. foreign: machine_id
  389. type: one
  390.  
  391. UnitWork:
  392. inheritance:
  393. extends: Unit
  394. type: column_aggregation
  395. keyField: unit_type
  396. keyValue: work
  397. columns:
  398. open: boolean
  399. closed: boolean
  400. locked: boolean
  401. unlocked: boolean
  402. relations:
  403. Machine:
  404. local: machine_id
  405. foreign: machine_id
  406. type: one
  407.  
  408. Action:
  409. tableName: iwash_action
  410. columns:
  411. action_id:
  412. type: integer(4)
  413. primary: true
  414. autoincrement: true
  415. from_position_id:
  416. type: integer(4)
  417. to_position_id:
  418. type: integer(4)
  419. unit_id:
  420. type: integer(4)
  421. function_name: string(255)
  422. relations:
  423. FromPosition:
  424. class: Position
  425. local: from_position_id
  426. foreign: position_id
  427. foreignAlias: ActionFrom
  428. type: one
  429. ToPosition:
  430. class: Position
  431. local: to_position_id
  432. foreign: position_id
  433. foreignAlias: ActionTo
  434. type: one
  435. Unit:
  436. local: unit_id
  437. foreign: unit_id
  438. type: one
  439. indexes:
  440. uk_from_to_position:
  441. fields: [from_position_id, to_position_id]
  442. type: unique
  443. options:
  444. type: INNODB
  445. collate: utf8_unicode_ci
  446. charset: utf8
  447.  
  448. ActionLoad:
  449. inheritance:
  450. extends: Action
  451. type: column_aggregation
  452. keyField: unit_type
  453. keyValue: load
  454. relations:
  455. UnitLoad:
  456. local: unit_id
  457. foreign: unit_id
  458. type: one
  459.  
  460. ActionMatrix:
  461. inheritance:
  462. extends: Action
  463. type: column_aggregation
  464. keyField: unit_type
  465. keyValue: matrix
  466. relations:
  467. UnitMatrix:
  468. local: unit_id
  469. foreign: unit_id
  470. type: one
  471.  
  472. ActionRobot:
  473. inheritance:
  474. extends: Action
  475. type: column_aggregation
  476. keyField: unit_type
  477. keyValue: robot
  478. columns:
  479. pos_x:
  480. type: integer(4)
  481. notnull: true
  482. pos_y:
  483. type: integer(4)
  484. notnull: true
  485. pos_z:
  486. type: integer(4)
  487. notnull: true
  488. pos_l:
  489. type: integer(4)
  490. notnull: true
  491. relations:
  492. UnitRobot:
  493. local: unit_id
  494. foreign: unit_id
  495. type: one
  496.  
  497. ActionWait:
  498. inheritance:
  499. extends: Action
  500. type: column_aggregation
  501. keyField: unit_type
  502. keyValue: wait
  503. relations:
  504. UnitWait:
  505. local: unit_id
  506. foreign: unit_id
  507. type: one
  508.  
  509. ActionWash:
  510. inheritance:
  511. extends: Action
  512. type: column_aggregation
  513. keyField: unit_type
  514. keyValue: wash
  515. relations:
  516. UnitWash:
  517. local: unit_id
  518. foreign: unit_id
  519. type: one
  520.  
  521. ActionWork:
  522. inheritance:
  523. extends: Action
  524. type: column_aggregation
  525. keyField: unit_type
  526. keyValue: work
  527. relations:
  528. UnitWork:
  529. local: unit_id
  530. foreign: unit_id
  531. type: one
  532.  
  533. Station:
  534. tableName: iwash_station
  535. columns:
  536. station_id:
  537. type: integer(4)
  538. primary: true
  539. autoincrement: true
  540. enabled: boolean
  541. machine_id:
  542. type: integer(4)
  543. id_logic:
  544. type: integer(4)
  545. relations:
  546. Machine:
  547. local: machine_id
  548. foreign: machine_id
  549. type: one
  550. options:
  551. type: INNODB
  552. collate: utf8_unicode_ci
  553. charset: utf8
  554.  
  555. Request:
  556. actAs:
  557. Timestampable:
  558. created:
  559. name: created_at
  560. type: timestamp
  561. format: Y-m-d H
  562. updated:
  563. disabled: true
  564. tableName: iwash_request
  565. columns:
  566. request_id:
  567. type: integer(4)
  568. primary: true
  569. autoincrement: true
  570. request_num:
  571. type: integer(4)
  572. eme:
  573. type: integer(4)
  574. dest:
  575. type: integer(4)
  576. type:
  577. type: integer(4)
  578. fct:
  579. type: integer(4)
  580. nb:
  581. type: integer(4)
  582. data:
  583. type: string(255)
  584. return:
  585. type: string(255)
  586. machine_id:
  587. type: integer(4)
  588. relations:
  589. Machine:
  590. local: machine_id
  591. foreign: machine_id
  592. type: one
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!