I am trying to create the following schema with the following requirements.
* One to one Organization to sfGuardUser
* Each organization, may have multiple campaigns.
* Each campaign may have multiple addressbooks.
* MessageQueue holds general information for all
organizations/campaigns/addressbooks
Please let me know what should I do to make it correct... thank you.
# 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
owningSide: true
type: one
foreignType: one
Campaign:
actAs: { Timestampable: ~ }
columns:
organization_id: { type: integer, notnull: true }
name: { type: string(255), notnull: true, unique: false }
keyword: { type: string(8), notnull: true, unique: true }
relations:
Organization:
local: organization_id
foreign: id
foreignType: many
AddressBook:
actAs: { Timestampable: ~ }
columns:
organization_id: { type: integer, notnull: true }
campaign_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:
local: organization_id
foreign: id
foreignType: many
CampaignAddressBook:
columns:
campaign_id: { type: integer, primary: true }
address_book_id: { type: integer, primary: true }
relations:
Campaign: { onDelete: CASCADE, local: campaign_id, foreign: id }
AddressBook: { onDelete: CASCADE, local: address_book_id, foreign: id }
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 }
--
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en.
