Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # config/doctrine/schema.yml
- Organization:
- actAs: { Timestampable: ~ }
- columns:
- sf_guard_user_id: { type: integer(4) }
- name: { type: string(255), notnull: true, unique: true }
- first_name: { type: string(255) }
- last_name: { type: string(255), notnull: true }
- phone: { type: string(20) }
- mobile: { type: string(20) }
- email: { type: string(255), notnull: true }
- logo: { type: string(255) }
- is_active: { type: boolean, notnull: true, default: 1 }
- relations:
- sfGuardUser:
- foreign: id
- local: sf_guard_user_id
- AddressBook:
- actAs: { Timestampable: ~ }
- columns:
- organization_id: { type: integer, notnull: true }
- first_name: { type: string(255) }
- last_name: { type: string(255), notnull: true }
- mobile: { type: string(20) }
- email: { type: string(255) }
- is_active: { type: boolean, notnull: true, default: 1 }
- relations:
- Organization: { onDelete: CASCADE, local: organization_id, foreign: id, foreignAlias: AddressBooks }
- #Heres a definition of the fields:
- # -organization_id CustomerNickname This is NICKNAME part of the message, represents customer identification string created during customer registration.
- # -keyword Keyword KEYWORD part of the message.
- # -message_option Option OPTION part of the message
- # -data Data DATA part of the message
- # -message_content Message The whole message as received by CellTrust
- # -response_type ResponseType Can have two possible values:
- # NORMAL � if the message was identified as belonging to specific campaign;
- # UNKNOWN � if provided KEYWORD or OPTION parts are unknown to the system
- # -msg_from OriginatorAddress Sender address � cell phone number in case of SMS message, or email address in case of Email message
- # -received_at AcceptedTime Time when the message was received by CellTrust platform
- # -delivery_type DeliveryType Can have two possible values: SMS or Email
- # -carrier Carrier For SMS only: short name for the carrier that the cell phone number belongs to.
- # -network_type NetworkType For SMS only: carrier network type, can be one of �gsm�, �cdma�, tdma�, �iden�
- MessageQueue:
- actAs: { Timestampable: ~ }
- columns:
- organization_id: { type: integer, notnull: true }
- address_book_id: { type: integer, notnull: false }
- msg_from: { type: string(255) }
- msg_to: { type: string(255) }
- message_content: { type: string(255) }
- status:
- type: enum
- values: [Pending,Delivered,Processed,Failed]
- notnull: true
- result_code: { type: string(255) }
- direction:
- type: enum
- values: [Inbound,Outbound]
- notnull: true
- keyword: { type: string(20) }
- message_option: { type: string(255) }
- data: { type: string(255) }
- response_type:
- type: enum
- values: [NORMAL,UNKNOWN]
- notnull: false
- delivery_type:
- type: enum
- values: [SMS,Email]
- carrier: { type: string(100) }
- network_type:
- type: enum
- values: [gsm,cdma,tdma,iden]
- notnull: false
- received_at: { type: timestamp, notnull: false }
- relations:
- Organization: { local: organization_id, foreign: id }
- AddressBook: { local: address_book_id, foreign: id }
- ======================
- fixture
- sfGuardUser:
- sgu_admin:
- username: admin
- password: admin
- is_super_admin: true
- Organization:
- name: ZizzerDog
- first_name: Samuel
- last_name: Morhaim
- phone: 7865478199
- mobile: 7865478189
- email: sammy@zizzerdog.com
- sgu_client:
- username: smorhaim
- password: wqt123
- is_super_admin: false
- Organization:
- name: SMLPro LLC
- first_name: Samuelito
- last_name: Lipovich
- phone: 7865478199
- mobile: 7865478189
- email: samuel.morhaim@gmail.com
- sfGuardPermission:
- sgp_admin:
- name: admin
- description: Administrator permission
- sgp_client:
- name: client
- description: Regular Client permission
- sfGuardGroup:
- sgg_admin:
- name: admin
- description: Administrator group
- sgg_client:
- name: client
- description: Client group
- sfGuardGroupPermission:
- sggp_admin:
- sfGuardGroup: sgg_admin
- sfGuardPermission: sgp_admin
- sggp_client:
- sfGuardGroup: sgg_client
- sfGuardPermission: sgp_client
- sfGuardUserGroup:
- sgug_admin:
- sfGuardGroup: sgg_admin
- sfGuardUser: sgu_admin
- sgug_client:
- sfGuardGroup: sgg_client
- sfGuardUser: sgu_client
- ============
- error
- Unknown record property / related component "0" on "Organization"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement