API tools faq
paste
Guest User

Untitled

a guest
Mar 12th, 2018
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
YAML 11.98 KB | None | 0 0
raw download clone embed print report
  1. Brick:
  2.   connection: doctrine
  3.   tableName: brick
  4.   actAs:
  5.       Timestampable:
  6.         created:
  7.           name: created
  8.           type: timestamp
  9.         updated:
  10.           name: updated
  11.           type: timestamp
  12.   columns:
  13.     id:
  14.       type: integer(8)
  15.       fixed: false
  16.       unsigned: true
  17.       primary: true
  18.       autoincrement: true
  19.     views:
  20.       type: integer(8)
  21.       fixed: false
  22.       unsigned: true
  23.       primary: false
  24.       notnull: true
  25.       default: '0'
  26.     user_id:
  27.       type: integer(8)
  28.       fixed: false
  29.       unsigned: false
  30.       primary: false
  31.       notnull: true
  32.       autoincrement: false
  33.     creator_id:
  34.       type: integer(8)
  35.       fixed: false
  36.       unsigned: false
  37.       primary: false
  38.       notnull: true
  39.       autoincrement: false
  40.     show_global:
  41.       type: integer(1)
  42.       fixed: false
  43.       primary: false
  44.       notnull: true
  45.       autoincrement: false
  46.       default: true
  47.     type:
  48.       type: integer(5)
  49.       fixed: false
  50.       unsigned: true
  51.       primary: false
  52.       notnull: true
  53.       autoincrement: false
  54.     title:
  55.       type: string(100)
  56.       fixed: false
  57.       unsigned: false
  58.       primary: false
  59.       notnull: true
  60.       autoincrement: false
  61.     content:
  62.       type: string()
  63.       fixed: false
  64.       unsigned: false
  65.       primary: false
  66.       notnull: true
  67.       autoincrement: false
  68.     url:
  69.       type: string(200)
  70.       fixed: false
  71.       unsigned: false
  72.       primary: false
  73.       notnull: false
  74.     status:
  75.       type: integer(8)
  76.       fixed: false
  77.       unsigned: false
  78.       primary: false
  79.       default: '0'
  80.       notnull: true
  81.       autoincrement: false
  82.     code:
  83.       type: varchar(64)
  84.       fixed: false
  85.       primary: false
  86.       notnull: true
  87.     country:
  88.       type: string(100)
  89.       fixed: false
  90.       unsigned: false
  91.       primary: false
  92.       notnull: false
  93.       autoincrement: false
  94.   indexes:
  95.     code_index:
  96.       fields:
  97.        code
  98.       type: unique
  99.   relations:
  100.     User:
  101.       local: user_id
  102.       foreign: id
  103.       type: many
  104.     User:
  105.       local: creator_id
  106.       foreign: id
  107.       type: many
  108.     Comment:
  109.       local: id
  110.       foreign: brick_id
  111.       type: one
  112.     Countries:
  113.       local: country
  114.       foreign: code
  115.       type: many
  116.     BrickType:
  117.       local: type
  118.       foreign: id
  119.       type: many
  120.  
  121. Tags:
  122.   connection: doctrine
  123.   tableName: Tags
  124.   actAs:
  125.       Timestampable:
  126.         created:
  127.           name: created
  128.           type: timestamp
  129.         updated:
  130.           name: updated
  131.           type: timestamp
  132.   columns:
  133.     id:
  134.       type: integer(8)
  135.       fixed: false
  136.       unsigned: true
  137.       primary: true
  138.       autoincrement: true
  139.     value:
  140.       type: varchar(50)
  141.       primary: true
  142.       notnull: true
  143.     cant:
  144.       type: integer(8)
  145.       unsigned: true
  146.       primary: false
  147.       notnull: true
  148.       default: 0
  149.   indexes:
  150.     tag_index:
  151.       fields:
  152.        value
  153.       type: unique
  154.  
  155. BrickTags:
  156.   connection: doctrine
  157.   tableName: BrickTags
  158.   actAs:
  159.       Timestampable:
  160.         created:
  161.           name: created
  162.           type: timestamp
  163.         updated:
  164.           name: updated
  165.           type: timestamp
  166.   columns:
  167.     tag:
  168.       type: integer(8)
  169.       fixed: false
  170.       primary: true
  171.       unsigned: true
  172.     brick:
  173.       type: integer(8)
  174.       fixed: false
  175.       unsigned: true
  176.       primary: true
  177.   relations:
  178.     Brick:
  179.       local: brick
  180.       foreign: id
  181.       type: many
  182.     Tags:
  183.       local: tag
  184.       foreign: id
  185.       type: many
  186.  
  187. RequestPassword:
  188.   connection: doctrine
  189.   tableName: request_password
  190.   columns:
  191.     id:
  192.       type: integer(8)
  193.       fixed: false
  194.       unsigned: false
  195.       primary: true
  196.       autoincrement: true
  197.     user_id:
  198.       type: integer(8)
  199.       fixed: false
  200.       unsigned: true
  201.       primary: false
  202.       notnull: true
  203.       autoincrement: false
  204.     code:
  205.       type: string(100)
  206.       primary: false
  207.       notnull: true
  208.   indexes:
  209.     code_index:
  210.       fields:
  211.        code
  212.       type: unique
  213.   relations:
  214.     User:
  215.       local: user_id
  216.       foreign: id
  217.       type: many
  218.  
  219. User:
  220.   connection: doctrine
  221.   tableName: user
  222.   columns:
  223.     id:
  224.       type: integer(8)
  225.       fixed: false
  226.       unsigned: false
  227.       primary: true
  228.       autoincrement: true
  229.     username:
  230.       type: string(100)
  231.       fixed: false
  232.       unsigned: false
  233.       primary: false
  234.       notnull: true
  235.       autoincrement: false
  236.     type:
  237.       type: integer(8)
  238.       fixed: false
  239.       unsigned: false
  240.       primary: false
  241.       default: '1'
  242.       notnull: true
  243.       autoincrement: false
  244.     email_notify:
  245.       type: boolean
  246.       fixed: false
  247.       unsigned: false
  248.       primary: false
  249.       default: true
  250.       notnull: true
  251.       autoincrement: false
  252.     cycle_n:
  253.       type: integer(8)
  254.       fixed: false
  255.       unsigned: false
  256.       primary: false
  257.       default: '0'
  258.       notnull: true
  259.       autoincrement: false
  260.     cycle_ng:
  261.       type: integer(8)
  262.       fixed: false
  263.       unsigned: false
  264.       primary: false
  265.       default: '0'
  266.       notnull: true
  267.       autoincrement: false
  268.     sent_n:
  269.       type: integer(8)
  270.       fixed: false
  271.       unsigned: false
  272.       primary: false
  273.       default: '0'
  274.       notnull: true
  275.       autoincrement: false
  276.     sent_s:
  277.       type: integer(8)
  278.       fixed: false
  279.       unsigned: false
  280.       primary: false
  281.       default: '0'
  282.       notnull: true
  283.       autoincrement: false
  284.     sent_g:
  285.       type: integer(8)
  286.       fixed: false
  287.       unsigned: false
  288.       primary: false
  289.       default: '0'
  290.       notnull: true
  291.       autoincrement: false
  292.     free_s:
  293.       type: integer(8)
  294.       fixed: false
  295.       unsigned: false
  296.       primary: false
  297.       default: '0'
  298.       notnull: true
  299.       autoincrement: false
  300.     free_g:
  301.       type: integer(8)
  302.       fixed: false
  303.       unsigned: false
  304.       primary: false
  305.       default: '0'
  306.       notnull: true
  307.       autoincrement: false
  308.     language:
  309.       type: string(10)
  310.       fixed: false
  311.       primary: false
  312.       notnull: false
  313.     avatar:
  314.       type: string(100)
  315.       fixed: false
  316.       primary: false
  317.       notnull: false
  318.     email:
  319.       type: string(100)
  320.       fixed: false
  321.       unsigned: false
  322.       primary: false
  323.       notnull: true
  324.       autoincrement: false
  325.     password:
  326.       type: string(100)
  327.       fixed: false
  328.       unsigned: false
  329.       primary: false
  330.       notnull: true
  331.       autoincrement: false
  332.     firstname:
  333.       type: string(100)
  334.       fixed: false
  335.       unsigned: false
  336.       primary: false
  337.       notnull: false
  338.       autoincrement: false
  339.     lastname:
  340.       type: string(100)
  341.       fixed: false
  342.       unsigned: false
  343.       primary: false
  344.       notnull: false
  345.       autoincrement: false
  346.     dob:
  347.       type: date(25)
  348.       fixed: false
  349.       unsigned: false
  350.       primary: false
  351.       notnull: false
  352.       autoincrement: false
  353.     hobbie:
  354.       type: string()
  355.       fixed: false
  356.       unsigned: false
  357.       primary: false
  358.       notnull: false
  359.       autoincrement: false
  360.     sex:
  361.       type: string(1)
  362.       fixed: true
  363.       unsigned: false
  364.       primary: false
  365.       notnull: false
  366.       autoincrement: false
  367.     activity:
  368.       type: string()
  369.       fixed: false
  370.       unsigned: false
  371.       primary: false
  372.       notnull: false
  373.       autoincrement: false
  374.     country:
  375.       type: string(100)
  376.       fixed: false
  377.       unsigned: false
  378.       primary: false
  379.       notnull: false
  380.       autoincrement: false
  381.   relations:
  382.     Brick:
  383.       local: id
  384.       foreign: user_id
  385.       type: one
  386.     Comment:
  387.       local: id
  388.       foreign: user_id
  389.       type: one
  390.     Countries:
  391.       local: country
  392.       foreign: code
  393.       type: many
  394.     Message:
  395.       local: id
  396.       foreign: sender_id
  397.       type: one
  398.     Message:
  399.       local: id
  400.       foreign: user_id
  401.       type: one
  402.     RequestPassword:
  403.       local: id
  404.       foreign: user_id
  405.       type: one
  406.  
  407. Comment:
  408.   connection: doctrine
  409.   tableName: comment
  410.   actAs:
  411.     Timestampable:
  412.       created:
  413.         name: created
  414.         type: timestamp
  415.       updated:
  416.         name: updated
  417.         type: timestamp
  418.   columns:
  419.     id:
  420.       type: integer(8)
  421.       fixed: false
  422.       unsigned: false
  423.       primary: true
  424.       autoincrement: true
  425.     user_id:
  426.       type: integer(8)
  427.       fixed: false
  428.       unsigned: false
  429.       primary: false
  430.       notnull: true
  431.       autoincrement: false
  432.     brick_id:
  433.       type: integer(8)
  434.       fixed: false
  435.       unsigned: true
  436.       primary: false
  437.       notnull: true
  438.       autoincrement: false
  439.     comment:
  440.       type: string(255)
  441.       fixed: false
  442.       primary: false
  443.       notnull: false
  444.   relations:
  445.     Brick:
  446.       local: brick_id
  447.       foreign: id
  448.       type: many
  449.     User:
  450.       local: user_id
  451.       foreign: id
  452.       type: many
  453.  
  454. Country:
  455.   connection: doctrine
  456.   tableName: countries
  457.   columns:
  458.     code:
  459.       type: string(4)
  460.       fixed: false
  461.       primary: true
  462.     country:
  463.       type: string(250)
  464.       fixed: false
  465.       unsigned: false
  466.       primary: false
  467.       notnull: true
  468.   relations:
  469.     Brick:
  470.       local: code
  471.       foreign: country
  472.       type: one
  473.     User:
  474.       local: code
  475.       foreign: country
  476.       type: one
  477.  
  478. Message:
  479.   connection: doctrine
  480.   tableName: message
  481.   actAs:
  482.     Timestampable:
  483.       created:
  484.         name: created
  485.         type: timestamp
  486.       updated:
  487.         name: updated
  488.         type: timestamp
  489.   columns:
  490.     id:
  491.       type: integer(8)
  492.       fixed: false
  493.       unsigned: false
  494.       primary: true
  495.       autoincrement: true
  496.     user_id:
  497.       type: integer(8)
  498.       fixed: false
  499.       unsigned: true
  500.       primary: false
  501.       notnull: true
  502.       autoincrement: false
  503.     sender_id:
  504.       type: integer(8)
  505.       fixed: false
  506.       unsigned: false
  507.       primary: false
  508.       notnull: false
  509.       autoincrement: false
  510.     receiver_id:
  511.       type: integer(8)
  512.       fixed: false
  513.       unsigned: false
  514.       primary: false
  515.       notnull: false
  516.       autoincrement: false
  517.     type:
  518.       type: integer(5)
  519.       fixed: false
  520.       unsigned: true
  521.       primary: false
  522.       notnull: true
  523.       autoincrement: false
  524.     subject:
  525.       type: string(100)
  526.       fixed: false
  527.       notnull: true
  528.     message:
  529.       type: string(500)
  530.       fixed: false
  531.       notnull: true
  532.   relations:
  533.     User:
  534.       local: user_id
  535.       foreign: id
  536.       type: many
  537.     User:
  538.       local: sender_id
  539.       foreign: id
  540.       type: many
  541.     User:
  542.       local: receiver_id
  543.       foreign: id
  544.       type: many
  545.  
  546. BrickType:
  547.   connection: doctrine
  548.   tableName: BrickType
  549.   actAs:
  550.     Timestampable:
  551.       created:
  552.         name: created
  553.         type: timestamp
  554.       updated:
  555.         name: updated
  556.         type: timestamp
  557.   columns:
  558.     id:
  559.       type: integer(8)
  560.       fixed: false
  561.       unsigned: true
  562.       primary: true
  563.       autoincrement: true
  564.     freeav:
  565.       type: integer
  566.       unsigned: true
  567.       notnull: false
  568.       default: '1'
  569.     replyto:
  570.       type: integer(8)
  571.       fixed: false
  572.       unsigned: true
  573.     title:
  574.       type: string(100)
  575.     description:
  576.       type: string(500)
  577.     class:
  578.       type: string(100)
  579. #  relations:
  580. #    BrickType:
  581. #      local: replyto
  582. #      foreign: id
  583. #      type: many
  584.  
  585. BricksUsers:
  586.   connection: doctrine
  587.   tableName: BricksUsers
  588.   actAs:
  589.     Timestampable:
  590.       created:
  591.         name: created
  592.         type: timestamp
  593.       updated:
  594.         name: updated
  595.         type: timestamp
  596.   columns:
  597.     user:
  598.       type: integer(8)
  599.       fixed: false
  600.       unsigned: false
  601.       primary: true
  602.     type:
  603.       type: integer(8)
  604.       fixed: false
  605.       unsigned: true
  606.       primary: true
  607.       autoincrement: false
  608.     cant:
  609.       type: integer(4)
  610.       unsigned: true
  611.   relations:
  612.     User:
  613.       local: user
  614.       foreign: id
  615.       type: many
  616.     BrickType:
  617.       local: type
  618.       foreign: id
  619.       type: many
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!