API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 8th, 2017
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VIM 22.11 KB | None | 0 0
raw download clone embed print report
  1. Drink:
  2.   connection: doctrine
  3.   tableName: drink
  4.   columns:
  5.     drink_id:
  6.       type: integer(4)
  7.       fixed: false
  8.       unsigned: false
  9.       primary: true
  10.       autoincrement: true
  11.     name:
  12.       type: string(45)
  13.       fixed: false
  14.       unsigned: false
  15.       primary: false
  16.       notnull: false
  17.       autoincrement: false
  18.     icon:
  19.       type: string(45)
  20.       fixed: false
  21.       unsigned: false
  22.       primary: false
  23.       notnull: false
  24.       autoincrement: false
  25.   relations:
  26.     ShelterMjDrink:
  27.       local: drink_id
  28.       foreign: drink_id
  29.       type: many
  30. Evacuee:
  31.   connection: doctrine
  32.   tableName: evacuee
  33.   columns:
  34.     evacuee_id:
  35.       type: integer(4)
  36.       fixed: false
  37.       unsigned: false
  38.       primary: true
  39.       autoincrement: true
  40.     given_name:
  41.       type: string(45)
  42.       fixed: false
  43.       unsigned: false
  44.       primary: false
  45.       notnull: true
  46.       autoincrement: false
  47.     middle_name:
  48.       type: string(45)
  49.       fixed: false
  50.       unsigned: false
  51.       primary: false
  52.       notnull: false
  53.       autoincrement: false
  54.     family_name:
  55.       type: string(45)
  56.       fixed: false
  57.       unsigned: false
  58.       primary: false
  59.       notnull: true
  60.       autoincrement: false
  61.     gender:
  62.       type: string(45)
  63.       fixed: false
  64.       unsigned: false
  65.       primary: false
  66.       notnull: false
  67.       autoincrement: false
  68.     age:
  69.       type: integer(4)
  70.       fixed: false
  71.       unsigned: false
  72.       primary: false
  73.       notnull: false
  74.       autoincrement: false
  75.   relations:
  76.     EvacueeMjLanguage:
  77.       local: evacuee_id
  78.       foreign: evacuee_id
  79.       type: many
  80.     EvacueeMjMedicine:
  81.       local: evacuee_id
  82.       foreign: evacuee_id
  83.       type: many
  84.     ShelterMjEvacuee:
  85.       local: evacuee_id
  86.       foreign: evacuee_id
  87.       type: many
  88. EvacueeMjLanguage:
  89.   connection: doctrine
  90.   tableName: evacuee_mj_language
  91.   columns:
  92.     id:
  93.       type: integer(4)
  94.       fixed: false
  95.       unsigned: false
  96.       primary: true
  97.       autoincrement: true
  98.     evacuee_id:
  99.       type: integer(4)
  100.       fixed: false
  101.       unsigned: false
  102.       primary: false
  103.       notnull: false
  104.       autoincrement: false
  105.     language_id:
  106.       type: integer(4)
  107.       fixed: false
  108.       unsigned: false
  109.       primary: false
  110.       notnull: false
  111.       autoincrement: false
  112.   relations:
  113.     Evacuee:
  114.       local: evacuee_id
  115.       foreign: evacuee_id
  116.       type: one
  117.     Language:
  118.       local: language_id
  119.       foreign: language_id
  120.       type: one
  121. EvacueeMjMedicine:
  122.   connection: doctrine
  123.   tableName: evacuee_mj_medicine
  124.   columns:
  125.     id:
  126.       type: integer(4)
  127.       fixed: false
  128.       unsigned: false
  129.       primary: true
  130.       autoincrement: true
  131.     evacuee_id:
  132.       type: integer(4)
  133.       fixed: false
  134.       unsigned: false
  135.       primary: false
  136.       notnull: false
  137.       autoincrement: false
  138.     medicine_id:
  139.       type: integer(4)
  140.       fixed: false
  141.       unsigned: false
  142.       primary: false
  143.       notnull: false
  144.       autoincrement: false
  145.   relations:
  146.     Evacuee:
  147.       local: evacuee_id
  148.       foreign: evacuee_id
  149.       type: one
  150.     Medicine:
  151.       local: medicine_id
  152.       foreign: medicine_id
  153.       type: one
  154. Food:
  155.   connection: doctrine
  156.   tableName: food
  157.   columns:
  158.     food_id:
  159.       type: integer(4)
  160.       fixed: false
  161.       unsigned: false
  162.       primary: true
  163.       autoincrement: true
  164.     name:
  165.       type: string(45)
  166.       fixed: false
  167.       unsigned: false
  168.       primary: false
  169.       notnull: false
  170.       autoincrement: false
  171.     icon:
  172.       type: string(45)
  173.       fixed: false
  174.       unsigned: false
  175.       primary: false
  176.       notnull: false
  177.       autoincrement: false
  178.   relations:
  179.     ShelterMjFood:
  180.       local: food_id
  181.       foreign: food_id
  182.       type: many
  183. Language:
  184.   connection: doctrine
  185.   tableName: language
  186.   columns:
  187.     language_id:
  188.       type: integer(4)
  189.       fixed: false
  190.       unsigned: false
  191.       primary: true
  192.       autoincrement: true
  193.     name:
  194.       type: string(45)
  195.       fixed: false
  196.       unsigned: false
  197.       primary: false
  198.       notnull: false
  199.       autoincrement: false
  200.   relations:
  201.     EvacueeMjLanguage:
  202.       local: language_id
  203.       foreign: language_id
  204.       type: many
  205.     VolunteerMjLanguage:
  206.       local: language_id
  207.       foreign: language_id
  208.       type: many
  209. Medicine:
  210.   connection: doctrine
  211.   tableName: medicine
  212.   columns:
  213.     medicine_id:
  214.       type: integer(4)
  215.       fixed: false
  216.       unsigned: false
  217.       primary: true
  218.       autoincrement: true
  219.     name:
  220.       type: string(45)
  221.       fixed: false
  222.       unsigned: false
  223.       primary: false
  224.       notnull: false
  225.       autoincrement: false
  226.     icon:
  227.       type: string(45)
  228.       fixed: false
  229.       unsigned: false
  230.       primary: false
  231.       notnull: false
  232.       autoincrement: false
  233.   relations:
  234.     EvacueeMjMedicine:
  235.       local: medicine_id
  236.       foreign: medicine_id
  237.       type: many
  238.     ShelterMjMedicine:
  239.       local: medicine_id
  240.       foreign: medicine_id
  241.       type: many
  242. Role:
  243.   connection: doctrine
  244.   tableName: role
  245.   columns:
  246.     role_id:
  247.       type: integer(4)
  248.       fixed: false
  249.       unsigned: false
  250.       primary: true
  251.       autoincrement: true
  252.     name:
  253.       type: string(45)
  254.       fixed: false
  255.       unsigned: false
  256.       primary: false
  257.       notnull: false
  258.       autoincrement: false
  259.     icon:
  260.       type: string(45)
  261.       fixed: false
  262.       unsigned: false
  263.       primary: false
  264.       notnull: false
  265.       autoincrement: false
  266.   relations:
  267.     Volunteer:
  268.       local: role_id
  269.       foreign: role_id
  270.       type: many
  271. SfGuardGroup:
  272.   connection: doctrine
  273.   tableName: sf_guard_group
  274.   columns:
  275.     id:
  276.       type: integer(4)
  277.       fixed: false
  278.       unsigned: false
  279.       primary: true
  280.       autoincrement: true
  281.     name:
  282.       type: string(255)
  283.       fixed: false
  284.       unsigned: false
  285.       primary: false
  286.       notnull: false
  287.       autoincrement: false
  288.     description:
  289.       type: string()
  290.       fixed: false
  291.       unsigned: false
  292.       primary: false
  293.       notnull: false
  294.       autoincrement: false
  295.     created_at:
  296.       type: timestamp(25)
  297.       fixed: false
  298.       unsigned: false
  299.       primary: false
  300.       notnull: true
  301.       autoincrement: false
  302.     updated_at:
  303.       type: timestamp(25)
  304.       fixed: false
  305.       unsigned: false
  306.       primary: false
  307.       notnull: true
  308.       autoincrement: false
  309.   relations:
  310.     SfGuardGroupPermission:
  311.       local: id
  312.       foreign: group_id
  313.       type: many
  314.     SfGuardUserGroup:
  315.       local: id
  316.       foreign: group_id
  317.       type: many
  318. SfGuardGroupPermission:
  319.   connection: doctrine
  320.   tableName: sf_guard_group_permission
  321.   columns:
  322.     group_id:
  323.       type: integer(4)
  324.       fixed: false
  325.       unsigned: false
  326.       primary: true
  327.       autoincrement: false
  328.     permission_id:
  329.       type: integer(4)
  330.       fixed: false
  331.       unsigned: false
  332.       primary: true
  333.       autoincrement: false
  334.     created_at:
  335.       type: timestamp(25)
  336.       fixed: false
  337.       unsigned: false
  338.       primary: false
  339.       notnull: true
  340.       autoincrement: false
  341.     updated_at:
  342.       type: timestamp(25)
  343.       fixed: false
  344.       unsigned: false
  345.       primary: false
  346.       notnull: true
  347.       autoincrement: false
  348.   relations:
  349.     SfGuardGroup:
  350.       local: group_id
  351.       foreign: id
  352.       type: one
  353.     SfGuardPermission:
  354.       local: permission_id
  355.       foreign: id
  356.       type: one
  357. SfGuardPermission:
  358.   connection: doctrine
  359.   tableName: sf_guard_permission
  360.   columns:
  361.     id:
  362.       type: integer(4)
  363.       fixed: false
  364.       unsigned: false
  365.       primary: true
  366.       autoincrement: true
  367.     name:
  368.       type: string(255)
  369.       fixed: false
  370.       unsigned: false
  371.       primary: false
  372.       notnull: false
  373.       autoincrement: false
  374.     description:
  375.       type: string()
  376.       fixed: false
  377.       unsigned: false
  378.       primary: false
  379.       notnull: false
  380.       autoincrement: false
  381.     created_at:
  382.       type: timestamp(25)
  383.       fixed: false
  384.       unsigned: false
  385.       primary: false
  386.       notnull: true
  387.       autoincrement: false
  388.     updated_at:
  389.       type: timestamp(25)
  390.       fixed: false
  391.       unsigned: false
  392.       primary: false
  393.       notnull: true
  394.       autoincrement: false
  395.   relations:
  396.     SfGuardGroupPermission:
  397.       local: id
  398.       foreign: permission_id
  399.       type: many
  400.     SfGuardUserPermission:
  401.       local: id
  402.       foreign: permission_id
  403.       type: many
  404. SfGuardRememberKey:
  405.   connection: doctrine
  406.   tableName: sf_guard_remember_key
  407.   columns:
  408.     id:
  409.       type: integer(4)
  410.       fixed: false
  411.       unsigned: false
  412.       primary: true
  413.       autoincrement: true
  414.     user_id:
  415.       type: integer(4)
  416.       fixed: false
  417.       unsigned: false
  418.       primary: false
  419.       notnull: false
  420.       autoincrement: false
  421.     remember_key:
  422.       type: string(32)
  423.       fixed: false
  424.       unsigned: false
  425.       primary: false
  426.       notnull: false
  427.       autoincrement: false
  428.     ip_address:
  429.       type: string(50)
  430.       fixed: false
  431.       unsigned: false
  432.       primary: true
  433.       autoincrement: false
  434.     created_at:
  435.       type: timestamp(25)
  436.       fixed: false
  437.       unsigned: false
  438.       primary: false
  439.       notnull: true
  440.       autoincrement: false
  441.     updated_at:
  442.       type: timestamp(25)
  443.       fixed: false
  444.       unsigned: false
  445.       primary: false
  446.       notnull: true
  447.       autoincrement: false
  448.   relations:
  449.     SfGuardUser:
  450.       local: user_id
  451.       foreign: id
  452.       type: one
  453. SfGuardUser:
  454.   connection: doctrine
  455.   tableName: sf_guard_user
  456.   columns:
  457.     id:
  458.       type: integer(4)
  459.       fixed: false
  460.       unsigned: false
  461.       primary: true
  462.       autoincrement: true
  463.     username:
  464.       type: string(128)
  465.       fixed: false
  466.       unsigned: false
  467.       primary: false
  468.       notnull: true
  469.       autoincrement: false
  470.     algorithm:
  471.       type: string(128)
  472.       fixed: false
  473.       unsigned: false
  474.       primary: false
  475.       default: sha1
  476.       notnull: true
  477.       autoincrement: false
  478.     salt:
  479.       type: string(128)
  480.       fixed: false
  481.       unsigned: false
  482.       primary: false
  483.       notnull: false
  484.       autoincrement: false
  485.     password:
  486.       type: string(128)
  487.       fixed: false
  488.       unsigned: false
  489.       primary: false
  490.       notnull: false
  491.       autoincrement: false
  492.     is_active:
  493.       type: integer(1)
  494.       fixed: false
  495.       unsigned: false
  496.       primary: false
  497.       default: '1'
  498.       notnull: false
  499.       autoincrement: false
  500.     is_super_admin:
  501.       type: integer(1)
  502.       fixed: false
  503.       unsigned: false
  504.       primary: false
  505.       default: '0'
  506.       notnull: false
  507.       autoincrement: false
  508.     last_login:
  509.       type: timestamp(25)
  510.       fixed: false
  511.       unsigned: false
  512.       primary: false
  513.       notnull: false
  514.       autoincrement: false
  515.     created_at:
  516.       type: timestamp(25)
  517.       fixed: false
  518.       unsigned: false
  519.       primary: false
  520.       notnull: true
  521.       autoincrement: false
  522.     updated_at:
  523.       type: timestamp(25)
  524.       fixed: false
  525.       unsigned: false
  526.       primary: false
  527.       notnull: true
  528.       autoincrement: false
  529.   relations:
  530.     SfGuardRememberKey:
  531.       local: id
  532.       foreign: user_id
  533.       type: many
  534.     SfGuardUserGroup:
  535.       local: id
  536.       foreign: user_id
  537.       type: many
  538.     SfGuardUserPermission:
  539.       local: id
  540.       foreign: user_id
  541.       type: many
  542. SfGuardUserGroup:
  543.   connection: doctrine
  544.   tableName: sf_guard_user_group
  545.   columns:
  546.     user_id:
  547.       type: integer(4)
  548.       fixed: false
  549.       unsigned: false
  550.       primary: true
  551.       autoincrement: false
  552.     group_id:
  553.       type: integer(4)
  554.       fixed: false
  555.       unsigned: false
  556.       primary: true
  557.       autoincrement: false
  558.     created_at:
  559.       type: timestamp(25)
  560.       fixed: false
  561.       unsigned: false
  562.       primary: false
  563.       notnull: true
  564.       autoincrement: false
  565.     updated_at:
  566.       type: timestamp(25)
  567.       fixed: false
  568.       unsigned: false
  569.       primary: false
  570.       notnull: true
  571.       autoincrement: false
  572.   relations:
  573.     SfGuardGroup:
  574.       local: group_id
  575.       foreign: id
  576.       type: one
  577.     SfGuardUser:
  578.       local: user_id
  579.       foreign: id
  580.       type: one
  581. SfGuardUserPermission:
  582.   connection: doctrine
  583.   tableName: sf_guard_user_permission
  584.   columns:
  585.     user_id:
  586.       type: integer(4)
  587.       fixed: false
  588.       unsigned: false
  589.       primary: true
  590.       autoincrement: false
  591.     permission_id:
  592.       type: integer(4)
  593.       fixed: false
  594.       unsigned: false
  595.       primary: true
  596.       autoincrement: false
  597.     created_at:
  598.       type: timestamp(25)
  599.       fixed: false
  600.       unsigned: false
  601.       primary: false
  602.       notnull: true
  603.       autoincrement: false
  604.     updated_at:
  605.       type: timestamp(25)
  606.       fixed: false
  607.       unsigned: false
  608.       primary: false
  609.       notnull: true
  610.       autoincrement: false
  611.   relations:
  612.     SfGuardPermission:
  613.       local: permission_id
  614.       foreign: id
  615.       type: one
  616.     SfGuardUser:
  617.       local: user_id
  618.       foreign: id
  619.       type: one
  620. Shelter:
  621.   connection: doctrine
  622.   tableName: shelter
  623.   columns:
  624.     shelter_id:
  625.       type: integer(4)
  626.       fixed: false
  627.       unsigned: false
  628.       primary: true
  629.       autoincrement: true
  630.     name:
  631.       type: string(45)
  632.       fixed: false
  633.       unsigned: false
  634.       primary: false
  635.       notnull: true
  636.       autoincrement: false
  637.     capacity:
  638.       type: integer(4)
  639.       fixed: false
  640.       unsigned: false
  641.       primary: false
  642.       notnull: false
  643.       autoincrement: false
  644.     icon:
  645.       type: string(45)
  646.       fixed: false
  647.       unsigned: false
  648.       primary: false
  649.       notnull: false
  650.       autoincrement: false
  651.   relations:
  652.     ShelterMjDrink:
  653.       local: shelter_id
  654.       foreign: shelter_id
  655.       type: many
  656.     ShelterMjEvacuee:
  657.       local: shelter_id
  658.       foreign: shelter_id
  659.       type: many
  660.     ShelterMjFood:
  661.       local: shelter_id
  662.       foreign: shelter_id
  663.       type: many
  664.     ShelterMjMedicine:
  665.       local: shelter_id
  666.       foreign: shelter_id
  667.       type: many
  668.     ShelterMjVehicle:
  669.       local: shelter_id
  670.       foreign: shelter_id
  671.       type: many
  672.     ShelterMjVolunteer:
  673.       local: shelter_id
  674.       foreign: shelter_id
  675.       type: many
  676. ShelterMjDrink:
  677.   connection: doctrine
  678.   tableName: shelter_mj_drink
  679.   columns:
  680.     id:
  681.       type: integer(4)
  682.       fixed: false
  683.       unsigned: false
  684.       primary: true
  685.       autoincrement: true
  686.     shelter_id:
  687.       type: integer(4)
  688.       fixed: false
  689.       unsigned: false
  690.       primary: false
  691.       notnull: true
  692.       autoincrement: false
  693.     drink_id:
  694.       type: integer(4)
  695.       fixed: false
  696.       unsigned: false
  697.       primary: false
  698.       notnull: false
  699.       autoincrement: false
  700.     quantity:
  701.       type: integer(4)
  702.       fixed: false
  703.       unsigned: false
  704.       primary: false
  705.       notnull: false
  706.       autoincrement: false
  707.   relations:
  708.     Drink:
  709.       foreignAlias: Drinks
  710.       local: drink_id
  711.       foreign: drink_id
  712.       type: one
  713.     Shelter:
  714.       foreignAlias: Shelters
  715.       local: shelter_id
  716.       foreign: shelter_id
  717.       type: one
  718. ShelterMjEvacuee:
  719.   connection: doctrine
  720.   tableName: shelter_mj_evacuee
  721.   columns:
  722.     id:
  723.       type: integer(4)
  724.       fixed: false
  725.       unsigned: false
  726.       primary: true
  727.       autoincrement: true
  728.     shelter_id:
  729.       type: integer(4)
  730.       fixed: false
  731.       unsigned: false
  732.       primary: false
  733.       notnull: false
  734.       autoincrement: false
  735.     evacuee_id:
  736.       type: integer(4)
  737.       fixed: false
  738.       unsigned: false
  739.       primary: false
  740.       notnull: false
  741.       autoincrement: false
  742.   relations:
  743.     Evacuee:
  744.       local: evacuee_id
  745.       foreign: evacuee_id
  746.       type: one
  747.     Shelter:
  748.       local: shelter_id
  749.       foreign: shelter_id
  750.       type: one
  751. ShelterMjFood:
  752.   connection: doctrine
  753.   tableName: shelter_mj_food
  754.   columns:
  755.     id:
  756.       type: integer(4)
  757.       fixed: false
  758.       unsigned: false
  759.       primary: true
  760.       autoincrement: true
  761.     shelter_id:
  762.       type: integer(4)
  763.       fixed: false
  764.       unsigned: false
  765.       primary: false
  766.       notnull: false
  767.       autoincrement: false
  768.     food_id:
  769.       type: integer(4)
  770.       fixed: false
  771.       unsigned: false
  772.       primary: false
  773.       notnull: false
  774.       autoincrement: false
  775.     quantity:
  776.       type: integer(4)
  777.       fixed: false
  778.       unsigned: false
  779.       primary: false
  780.       notnull: false
  781.       autoincrement: false
  782.   relations:
  783.     Food:
  784.       local: food_id
  785.       foreign: food_id
  786.       type: one
  787.     Shelter:
  788.       local: shelter_id
  789.       foreign: shelter_id
  790.       type: one
  791. ShelterMjMedicine:
  792.   connection: doctrine
  793.   tableName: shelter_mj_medicine
  794.   columns:
  795.     id:
  796.       type: integer(4)
  797.       fixed: false
  798.       unsigned: false
  799.       primary: true
  800.       autoincrement: true
  801.     shelter_id:
  802.       type: integer(4)
  803.       fixed: false
  804.       unsigned: false
  805.       primary: false
  806.       notnull: false
  807.       autoincrement: false
  808.     medicine_id:
  809.       type: integer(4)
  810.       fixed: false
  811.       unsigned: false
  812.       primary: false
  813.       notnull: false
  814.       autoincrement: false
  815.     quantity:
  816.       type: integer(4)
  817.       fixed: false
  818.       unsigned: false
  819.       primary: false
  820.       notnull: false
  821.       autoincrement: false
  822.   relations:
  823.     Medicine:
  824.       local: medicine_id
  825.       foreign: medicine_id
  826.       type: one
  827.     Shelter:
  828.       local: shelter_id
  829.       foreign: shelter_id
  830.       type: one
  831. ShelterMjVehicle:
  832.   connection: doctrine
  833.   tableName: shelter_mj_vehicle
  834.   columns:
  835.     id:
  836.       type: integer(4)
  837.       fixed: false
  838.       unsigned: false
  839.       primary: true
  840.       autoincrement: true
  841.     shelter_id:
  842.       type: integer(4)
  843.       fixed: false
  844.       unsigned: false
  845.       primary: false
  846.       notnull: false
  847.       autoincrement: false
  848.     vehicle_id:
  849.       type: integer(4)
  850.       fixed: false
  851.       unsigned: false
  852.       primary: false
  853.       notnull: false
  854.       autoincrement: false
  855.     quantity:
  856.       type: integer(4)
  857.       fixed: false
  858.       unsigned: false
  859.       primary: false
  860.       notnull: false
  861.       autoincrement: false
  862.   relations:
  863.     Shelter:
  864.       local: shelter_id
  865.       foreign: shelter_id
  866.       type: one
  867.     Vehicle:
  868.       local: vehicle_id
  869.       foreign: vehicle_id
  870.       type: one
  871. ShelterMjVolunteer:
  872.   connection: doctrine
  873.   tableName: shelter_mj_volunteer
  874.   columns:
  875.     id:
  876.       type: integer(4)
  877.       fixed: false
  878.       unsigned: false
  879.       primary: true
  880.       autoincrement: true
  881.     shelter_id:
  882.       type: integer(4)
  883.       fixed: false
  884.       unsigned: false
  885.       primary: false
  886.       notnull: false
  887.       autoincrement: false
  888.     volunteer_id:
  889.       type: integer(4)
  890.       fixed: false
  891.       unsigned: false
  892.       primary: false
  893.       notnull: false
  894.       autoincrement: false
  895.   relations:
  896.     Shelter:
  897.       local: shelter_id
  898.       foreign: shelter_id
  899.       type: one
  900.     Volunteer:
  901.       local: volunteer_id
  902.       foreign: volunteer_id
  903.       type: one
  904. Vehicle:
  905.   connection: doctrine
  906.   tableName: vehicle
  907.   columns:
  908.     vehicle_id:
  909.       type: integer(4)
  910.       fixed: false
  911.       unsigned: false
  912.       primary: true
  913.       autoincrement: true
  914.     name:
  915.       type: string(45)
  916.       fixed: false
  917.       unsigned: false
  918.       primary: false
  919.       notnull: false
  920.       autoincrement: false
  921.     capacity:
  922.       type: integer(4)
  923.       fixed: false
  924.       unsigned: false
  925.       primary: false
  926.       notnull: false
  927.       autoincrement: false
  928.     icon:
  929.       type: string(45)
  930.       fixed: false
  931.       unsigned: false
  932.       primary: false
  933.       notnull: false
  934.       autoincrement: false
  935.   relations:
  936.     ShelterMjVehicle:
  937.       local: vehicle_id
  938.       foreign: vehicle_id
  939.       type: many
  940. Volunteer:
  941.   connection: doctrine
  942.   tableName: volunteer
  943.   columns:
  944.     volunteer_id:
  945.       type: integer(4)
  946.       fixed: false
  947.       unsigned: false
  948.       primary: true
  949.       autoincrement: true
  950.     given_name:
  951.       type: string(45)
  952.       fixed: false
  953.       unsigned: false
  954.       primary: false
  955.       notnull: true
  956.       autoincrement: false
  957.     middle_name:
  958.       type: string(45)
  959.       fixed: false
  960.       unsigned: false
  961.       primary: false
  962.       notnull: false
  963.       autoincrement: false
  964.     family_name:
  965.       type: string(45)
  966.       fixed: false
  967.       unsigned: false
  968.       primary: false
  969.       notnull: true
  970.       autoincrement: false
  971.     role_id:
  972.       type: integer(4)
  973.       fixed: false
  974.       unsigned: false
  975.       primary: false
  976.       notnull: false
  977.       autoincrement: false
  978.     username:
  979.       type: string(45)
  980.       fixed: false
  981.       unsigned: false
  982.       primary: false
  983.       notnull: true
  984.       autoincrement: false
  985.     email:
  986.       type: string(45)
  987.       fixed: false
  988.       unsigned: false
  989.       primary: false
  990.       notnull: false
  991.       autoincrement: false
  992.     gender:
  993.       type: string(45)
  994.       fixed: false
  995.       unsigned: false
  996.       primary: false
  997.       notnull: false
  998.       autoincrement: false
  999.     age:
  1000.       type: integer(4)
  1001.       fixed: false
  1002.       unsigned: false
  1003.       primary: false
  1004.       notnull: false
  1005.       autoincrement: false
  1006.   relations:
  1007.     Role:
  1008.       local: role_id
  1009.       foreign: role_id
  1010.       type: one
  1011.     ShelterMjVolunteer:
  1012.       local: volunteer_id
  1013.       foreign: volunteer_id
  1014.       type: many
  1015.     VolunteerMjLanguage:
  1016.       local: volunteer_id
  1017.       foreign: volunteer_id
  1018.       type: many
  1019. VolunteerMjLanguage:
  1020.   connection: doctrine
  1021.   tableName: volunteer_mj_language
  1022.   columns:
  1023.     id:
  1024.       type: integer(4)
  1025.       fixed: false
  1026.       unsigned: false
  1027.       primary: true
  1028.       autoincrement: true
  1029.     volunteer_id:
  1030.       type: integer(4)
  1031.       fixed: false
  1032.       unsigned: false
  1033.       primary: false
  1034.       notnull: false
  1035.       autoincrement: false
  1036.     language_id:
  1037.       type: integer(4)
  1038.       fixed: false
  1039.       unsigned: false
  1040.       primary: false
  1041.       notnull: false
  1042.       autoincrement: false
  1043.   relations:
  1044.     Language:
  1045.       local: language_id
  1046.       foreign: language_id
  1047.       type: one
  1048.     Volunteer:
  1049.       local: volunteer_id
  1050.       foreign: volunteer_id
  1051.       type: one
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!