Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- propel:
- #main data types
- phonebank_user:
- _attributes: { phpName: User }
- id: ~
- first_name: varchar(255)
- last_name: varchar(255)
- email: varchar(255)
- password: varchar(255)
- salt: varchar(255)
- created_at: ~
- updated_at: ~
- phonebank_campaign:
- _attributes: { phpName: Campaign }
- id: ~
- name: varchar(255)
- created_at: ~
- updated_at: ~
- phonebank_contact:
- _attributes: { phpName: Contact }
- id: ~
- first_name: varchar(255)
- last_name: varchar(255)
- initial_phone: varchar(255)
- created_at: ~
- #hasMany Relationships
- phonebank_list:
- _attributes: { phpName: List }
- id: ~
- parent: { type: integer }
- name: varchar(255)
- campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
- created_at: ~
- #many-to-many relationships
- phonebank_user_campaign:
- _attributes: { phpName: UserCampaign }
- id: ~
- user_id: { type: integer, foreignTable: phonebank_user, foreignReference: id, onDelete: cascade }
- campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
- campaign_role_id:{ type: integer, foreignTable: phonebank_campaign_role, foreignReference: id, onDelete: cascade }
- created_at: ~
- updated_at: ~
- phonebank_campaign_list:
- _attributes: { phpName: CampaignList }
- id: ~
- campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
- list_id: { type: integer, foreignTable: phonebank_list, foreignReference: id, onDelete: cascade }
- campaign_role_id:{ type: integer, foreignTable: phonebank_campaign_role, foreignReference: id, onDelete: cascade }
- created_at: ~
- phonebank_list_contact:
- _attributes: { phpName: ListContact }
- id: ~
- list_id: { type: integer, foreignTable: phonebank_list, foreignReference: id, onDelete: cascade }
- contact_id: { type: integer, foreignTable: phonebank_contact, foreignReference: id, onDelete: cascade }
- campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
- locked: boolean
- created_at: ~
- phonebank_call:
- _attributes: { phpName: Call }
- id: ~
- user_campaign_id:{ type: integer, foreignTable: phonebank_user_campaign, foreignReference: id, onDelete: cascade }
- list_contact: { type: integer, foreignTable: phonebank_list_contact, foreignReference: id, onDelete: cascade }
- created_at: ~
- phonebank_call_result:
- _attributes: { phpName: CallResult }
- id: ~
- call_id: { type: integer, foreignTable: phonebank_call, foreignReference: id, onDelete: cascade }
- campaign_call_result_id: { type: integer, foreignTable: phonebank_campaign_call_result, foreignReference: id, onDelete: cascade }
- created_at: ~
- phonebank_campaign_role:
- _attributes: { phpName: CampaignRole }
- id: ~
- campaign_id: { type: integer, foreignTable: phonebank_campaign, foreignReference: id, onDelete: cascade }
- name: varchar(255)
- description: longvarchar
- created_at: ~
Add Comment
Please, Sign In to add comment