# 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"