Guest User

Untitled

a guest
Jun 6th, 2018
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.39 KB | None | 0 0
  1. propel:
  2. #main data types
  3. phonebank_user:
  4. _attributes: { phpName: User }
  5. id: ~
  6. first_name: varchar(255)
  7. last_name: varchar(255)
  8. email: varchar(255)
  9. password: varchar(255)
  10. salt: varchar(255)
  11. created_at: ~
  12. updated_at: ~
  13. phonebank_campaign:
  14. _attributes: { phpName: Campaign }
  15. id: ~
  16. name: varchar(255)
  17. created_at: ~
  18. updated_at: ~
  19. phonebank_contact:
  20. _attributes: { phpName: Contact }
  21. id: ~
  22. first_name: varchar(255)
  23. last_name: varchar(255)
  24. initial_phone: varchar(255)
  25. created_at: ~
  26. #hasMany Relationships
  27. phonebank_list:
  28. _attributes: { phpName: List }
  29. id: ~
  30. parent: { type: integer }
  31. name: varchar(255)
  32. campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
  33. created_at: ~
  34. #many-to-many relationships
  35. phonebank_user_campaign:
  36. _attributes: { phpName: UserCampaign }
  37. id: ~
  38. user_id: { type: integer, foreignTable: phonebank_user, foreignReference: id, onDelete: cascade }
  39. campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
  40. campaign_role_id:{ type: integer, foreignTable: phonebank_campaign_role, foreignReference: id, onDelete: cascade }
  41. created_at: ~
  42. updated_at: ~
  43. phonebank_campaign_list:
  44. _attributes: { phpName: CampaignList }
  45. id: ~
  46. campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
  47. list_id: { type: integer, foreignTable: phonebank_list, foreignReference: id, onDelete: cascade }
  48. campaign_role_id:{ type: integer, foreignTable: phonebank_campaign_role, foreignReference: id, onDelete: cascade }
  49. created_at: ~
  50. phonebank_list_contact:
  51. _attributes: { phpName: ListContact }
  52. id: ~
  53. list_id: { type: integer, foreignTable: phonebank_list, foreignReference: id, onDelete: cascade }
  54. contact_id: { type: integer, foreignTable: phonebank_contact, foreignReference: id, onDelete: cascade }
  55. campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
  56. locked: boolean
  57. created_at: ~
  58. phonebank_call:
  59. _attributes: { phpName: Call }
  60. id: ~
  61. user_campaign_id:{ type: integer, foreignTable: phonebank_user_campaign, foreignReference: id, onDelete: cascade }
  62. list_contact: { type: integer, foreignTable: phonebank_list_contact, foreignReference: id, onDelete: cascade }
  63. created_at: ~
  64. phonebank_call_result:
  65. _attributes: { phpName: CallResult }
  66. id: ~
  67. call_id: { type: integer, foreignTable: phonebank_call, foreignReference: id, onDelete: cascade }
  68. campaign_call_result_id: { type: integer, foreignTable: phonebank_campaign_call_result, foreignReference: id, onDelete: cascade }
  69. created_at: ~
  70. phonebank_campaign_role:
  71. _attributes: { phpName: CampaignRole }
  72. id: ~
  73. campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
  74. name: varchar(255)
  75. description: longvarchar
  76. created_at: ~
Add Comment
Please, Sign In to add comment