API tools faq
paste
Guest User

Untitled

a guest
Aug 2nd, 2018
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.08 KB | None | 0 0
raw download clone embed print report
  1. sfGuardGroup:
  2. actAs: [Timestampable]
  3. columns:
  4. name:
  5. type: string(255)
  6. unique: true
  7. description: string(1000)
  8. relations:
  9. Users:
  10. class: sfGuardUser
  11. refClass: sfGuardUserGroup
  12. local: group_id
  13. foreign: id
  14. foreignAlias: Groups
  15. Permissions:
  16. class: sfGuardPermission
  17. local: permission_id
  18. foreign: id
  19. refClass: sfGuardGroupPermission
  20. foreignAlias: Groups
  21.  
  22. sfGuardPermission:
  23. actAs: [Timestampable]
  24. columns:
  25. empresa_id:
  26. type: integer
  27. fixed: false
  28. unsigned: false
  29. primary: false
  30. notnull: true
  31. autoincrement: false
  32. default: 1
  33. name:
  34. type: string(255)
  35. unique: true
  36. description: string(1000)
  37. detalles:
  38. type: enum
  39. fixed: false
  40. unsigned: false
  41. primary: false
  42. autoincrement: false
  43. values: ['1', '2', '3', '4', '5', '6','7']
  44. status:
  45. type: integer(1)
  46. fixed: false
  47. unsigned: false
  48. primary: false
  49. notnull: true
  50. autoincrement: false
  51. relations:
  52. Empresa:
  53. local: empresa_id
  54. foreign: id
  55. type: one
  56. foreignType: many
  57. onDelete: CASCADE
  58. onUpdate: CASCADE
  59.  
  60. sfGuardGroupPermission:
  61. options:
  62. symfony:
  63. form: false
  64. filter: false
  65. actAs: [Timestampable]
  66. columns:
  67. group_id:
  68. type: integer
  69. primary: true
  70. permission_id:
  71. type: integer
  72. primary: true
  73. relations:
  74. Group:
  75. class: sfGuardGroup
  76. local: group_id
  77. onDelete: CASCADE
  78. Permission:
  79. class: sfGuardPermission
  80. local: permission_id
  81. onDelete: CASCADE
  82.  
  83. sfGuardUser:
  84. actAs: [Timestampable]
  85. columns:
  86. first_name: string(255)
  87. last_name: string(255)
  88. identificacion: string(50)
  89. fecha_nacimiento: date
  90. direcion: string()
  91. telefono_principal: string(50)
  92. telefono_adicional: string(50)
  93. telefono_emergencia: string(50)
  94. telefono_familiar: string(50)
  95. sexo: integer(1)
  96. edo_civil: string(50)
  97. licencia_conducir:
  98. type: string(50)
  99. notnull: false
  100. licencia_conducir_fecha:
  101. type: date
  102. notnull: false
  103. nacionalidad: string(50)
  104. empresa_id:
  105. type: integer
  106. notnull: true
  107. area_id:
  108. type: integer
  109. notnull: false
  110. ocupacion:
  111. type: string(50)
  112. notnull: true
  113. default: 1
  114. titulo:
  115. type: string(50)
  116. notnull: true
  117. default: 1
  118. grado_instruccion:
  119. type: string(50)
  120. notnull: true
  121. default: 1
  122. ingreso:
  123. type: date
  124. notnull: true
  125. salida:
  126. type: date
  127. notnull: false
  128. email_address:
  129. type: string(255)
  130. notnull: true
  131. unique: true
  132. username:
  133. type: string(128)
  134. notnull: true
  135. unique: true
  136. algorithm:
  137. type: string(128)
  138. default: sha1
  139. notnull: true
  140. salt: string(128)
  141. password: string(128)
  142. identificacion_archivo:
  143. type: string(50)
  144. notnull: false
  145. domicilio_archivo:
  146. type: string(50)
  147. notnull: false
  148. foto_archivo:
  149. type: string(50)
  150. notnull: false
  151. is_active:
  152. type: boolean
  153. default: 1
  154. is_super_admin:
  155. type: boolean
  156. default: false
  157. last_login:
  158. type: timestamp
  159. alerta:
  160. type: string()
  161. notnull: false
  162. observacion:
  163. type: string()
  164. fixed: false
  165. unsigned: false
  166. primary: false
  167. autoincrement: false
  168. notnull: false
  169. indexes:
  170. is_active_idx:
  171. fields: [is_active]
  172. relations:
  173. Groups:
  174. class: sfGuardGroup
  175. local: group_id
  176. foreign: id
  177. refClass: sfGuardUserGroup
  178. foreignAlias: Users
  179. Permissions:
  180. class: sfGuardPermission
  181. local: user_id
  182. foreign: permission_id
  183. refClass: sfGuardUserPermission
  184. foreignAlias: Users
  185. Empresa:
  186. local: empresa_id
  187. foreign: id
  188. type: one
  189. onDelete: CASCADE
  190. onUpdate: CASCADE
  191. Area:
  192. local: area_id
  193. foreign: id
  194. type: one
  195. onDelete: NULL
  196. onUpdate: NULL
  197.  
  198. sfGuardUserPermission:
  199. options:
  200. symfony:
  201. form: false
  202. filter: false
  203. actAs: [Timestampable]
  204. columns:
  205. user_id:
  206. type: integer
  207. primary: true
  208. permission_id:
  209. type: integer
  210. primary: true
  211. relations:
  212. User:
  213. class: sfGuardUser
  214. local: user_id
  215. onDelete: CASCADE
  216. Permission:
  217. class: sfGuardPermission
  218. local: permission_id
  219. onDelete: CASCADE
  220.  
  221. sfGuardUserGroup:
  222. options:
  223. symfony:
  224. form: false
  225. filter: false
  226. actAs: [Timestampable]
  227. columns:
  228. user_id:
  229. type: integer
  230. primary: true
  231. group_id:
  232. type: integer
  233. primary: true
  234. relations:
  235. User:
  236. class: sfGuardUser
  237. local: user_id
  238. onDelete: CASCADE
  239. Group:
  240. class: sfGuardGroup
  241. local: group_id
  242. onDelete: CASCADE
  243.  
  244. sfGuardRememberKey:
  245. options:
  246. symfony:
  247. form: false
  248. filter: false
  249. actAs: [Timestampable]
  250. columns:
  251. user_id: integer
  252. remember_key: string(32)
  253. ip_address: string(50)
  254. relations:
  255. User:
  256. class: sfGuardUser
  257. local: user_id
  258. foreignAlias: RememberKeys
  259. foreignType: one
  260. onDelete: CASCADE
  261.  
  262. sfGuardForgotPassword:
  263. options:
  264. symfony:
  265. form: false
  266. filter: false
  267. actAs: [Timestampable]
  268. columns:
  269. user_id:
  270. type: integer
  271. notnull: true
  272. unique_key: string(255)
  273. expires_at:
  274. type: timestamp
  275. notnull: true
  276. relations:
  277. User:
  278. class: sfGuardUser
  279. local: user_id
  280. type: one
  281. foreignType: one
  282. foreignAlias: ForgotPassword
  283. onDelete: CASCADE
  284.  
  285. sfGuardGroup:
  286. actAs: [Timestampable]
  287. columns:
  288. name:
  289. type: string(255)
  290. unique: true
  291. description: string(1000)
  292. relations:
  293. Users:
  294. class: sfGuardUser
  295. refClass: sfGuardUserGroup
  296. local: group_id
  297. foreign: id
  298. foreignAlias: Groups
  299. Permissions:
  300. class: sfGuardPermission
  301. local: permission_id
  302. foreign: id
  303. refClass: sfGuardGroupPermission
  304. foreignAlias: Groups
  305.  
  306. sfGuardPermission:
  307. actAs: [Timestampable]
  308. columns:
  309. empresa_id:
  310. type: integer
  311. fixed: false
  312. unsigned: false
  313. primary: false
  314. notnull: true
  315. autoincrement: false
  316. default: 1
  317. name:
  318. type: string(255)
  319. unique: true
  320. description: string(1000)
  321. detalles:
  322. type: enum
  323. fixed: false
  324. unsigned: false
  325. primary: false
  326. autoincrement: false
  327. values: ['1', '2', '3', '4', '5', '6','7']
  328. status:
  329. type: integer(1)
  330. fixed: false
  331. unsigned: false
  332. primary: false
  333. notnull: true
  334. autoincrement: false
  335. relations:
  336. Empresa:
  337. local: empresa_id
  338. foreign: id
  339. type: one
  340. foreignType: many
  341. onDelete: CASCADE
  342. onUpdate: CASCADE
  343.  
  344. sfGuardGroupPermission:
  345. options:
  346. symfony:
  347. form: false
  348. filter: false
  349. actAs: [Timestampable]
  350. columns:
  351. group_id:
  352. type: integer
  353. primary: true
  354. permission_id:
  355. type: integer
  356. primary: true
  357. relations:
  358. Group:
  359. class: sfGuardGroup
  360. local: group_id
  361. onDelete: CASCADE
  362. Permission:
  363. class: sfGuardPermission
  364. local: permission_id
  365. onDelete: CASCADE
  366.  
  367. sfGuardUser:
  368. actAs: [Timestampable]
  369. columns:
  370. first_name: string(255)
  371. last_name: string(255)
  372. identificacion: string(50)
  373. fecha_nacimiento: date
  374. direcion: string()
  375. telefono_principal: string(50)
  376. telefono_adicional: string(50)
  377. telefono_emergencia: string(50)
  378. telefono_familiar: string(50)
  379. sexo: integer(1)
  380. edo_civil: string(50)
  381. licencia_conducir:
  382. type: string(50)
  383. notnull: false
  384. licencia_conducir_fecha:
  385. type: date
  386. notnull: false
  387. nacionalidad: string(50)
  388. empresa_id:
  389. type: integer
  390. notnull: true
  391. area_id:
  392. type: integer
  393. notnull: false
  394. ocupacion:
  395. type: string(50)
  396. notnull: true
  397. default: 1
  398. titulo:
  399. type: string(50)
  400. notnull: true
  401. default: 1
  402. grado_instruccion:
  403. type: string(50)
  404. notnull: true
  405. default: 1
  406. ingreso:
  407. type: date
  408. notnull: true
  409. salida:
  410. type: date
  411. notnull: false
  412. email_address:
  413. type: string(255)
  414. notnull: true
  415. unique: true
  416. username:
  417. type: string(128)
  418. notnull: true
  419. unique: true
  420. algorithm:
  421. type: string(128)
  422. default: sha1
  423. notnull: true
  424. salt: string(128)
  425. password: string(128)
  426. identificacion_archivo:
  427. type: string(50)
  428. notnull: false
  429. domicilio_archivo:
  430. type: string(50)
  431. notnull: false
  432. foto_archivo:
  433. type: string(50)
  434. notnull: false
  435. is_active:
  436. type: boolean
  437. default: 1
  438. is_super_admin:
  439. type: boolean
  440. default: false
  441. last_login:
  442. type: timestamp
  443. alerta:
  444. type: string()
  445. notnull: false
  446. observacion:
  447. type: string()
  448. fixed: false
  449. unsigned: false
  450. primary: false
  451. autoincrement: false
  452. notnull: false
  453. indexes:
  454. is_active_idx:
  455. fields: [is_active]
  456. relations:
  457. Groups:
  458. class: sfGuardGroup
  459. local: group_id
  460. foreign: id
  461. refClass: sfGuardUserGroup
  462. foreignAlias: Users
  463. Permissions:
  464. class: sfGuardPermission
  465. local: user_id
  466. foreign: permission_id
  467. refClass: sfGuardUserPermission
  468. foreignAlias: Users
  469. Empresa:
  470. local: empresa_id
  471. foreign: id
  472. type: one
  473. onDelete: CASCADE
  474. onUpdate: CASCADE
  475. Area:
  476. local: area_id
  477. foreign: id
  478. type: one
  479. onDelete: NULL
  480. onUpdate: NULL
  481.  
  482. sfGuardUserPermission:
  483. options:
  484. symfony:
  485. form: false
  486. filter: false
  487. actAs: [Timestampable]
  488. columns:
  489. user_id:
  490. type: integer
  491. primary: true
  492. permission_id:
  493. type: integer
  494. primary: true
  495. relations:
  496. User:
  497. class: sfGuardUser
  498. local: user_id
  499. onDelete: CASCADE
  500. Permission:
  501. class: sfGuardPermission
  502. local: permission_id
  503. onDelete: CASCADE
  504.  
  505. sfGuardUserGroup:
  506. options:
  507. symfony:
  508. form: false
  509. filter: false
  510. actAs: [Timestampable]
  511. columns:
  512. user_id:
  513. type: integer
  514. primary: true
  515. group_id:
  516. type: integer
  517. primary: true
  518. relations:
  519. User:
  520. class: sfGuardUser
  521. local: user_id
  522. onDelete: CASCADE
  523. Group:
  524. class: sfGuardGroup
  525. local: group_id
  526. onDelete: CASCADE
  527.  
  528. sfGuardRememberKey:
  529. options:
  530. symfony:
  531. form: false
  532. filter: false
  533. actAs: [Timestampable]
  534. columns:
  535. user_id: integer
  536. remember_key: string(32)
  537. ip_address: string(50)
  538. relations:
  539. User:
  540. class: sfGuardUser
  541. local: user_id
  542. foreignAlias: RememberKeys
  543. foreignType: one
  544. onDelete: CASCADE
  545.  
  546. sfGuardForgotPassword:
  547. options:
  548. symfony:
  549. form: false
  550. filter: false
  551. actAs: [Timestampable]
  552. columns:
  553. user_id:
  554. type: integer
  555. notnull: true
  556. unique_key: string(255)
  557. expires_at:
  558. type: timestamp
  559. notnull: true
  560. relations:
  561. User:
  562. class: sfGuardUser
  563. local: user_id
  564. type: one
  565. foreignType: one
  566. foreignAlias: ForgotPassword
  567. onDelete: CASCADE
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!