326 lines
7.2 KiB
YAML
326 lines
7.2 KiB
YAML
---
|
|
propel:
|
|
_attributes:
|
|
defaultIdMethod: native
|
|
package: plugins.stNewsletterPlugin.lib.model
|
|
st_newsletter_user:
|
|
_attributes:
|
|
phpName: NewsletterUser
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
sf_guard_user_id:
|
|
type: INTEGER
|
|
required: false
|
|
foreignTable: sf_guard_user
|
|
foreignReference: id
|
|
onDelete: setnull
|
|
email:
|
|
type: VARCHAR
|
|
size: 255
|
|
active:
|
|
type: BOOLEAN
|
|
default: true
|
|
confirm:
|
|
type: BOOLEAN
|
|
default: false
|
|
hash:
|
|
type: VARCHAR
|
|
size: 255
|
|
language:
|
|
type: VARCHAR
|
|
size: 255
|
|
st_newsletter_group:
|
|
_attributes:
|
|
phpName: NewsletterGroup
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
opt_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_description:
|
|
type: LONGVARCHAR
|
|
shortcut:
|
|
type: VARCHAR
|
|
size: 255
|
|
is_public:
|
|
type: BOOLEAN
|
|
is_default:
|
|
type: BOOLEAN
|
|
st_newsletter_message:
|
|
_attributes:
|
|
phpName: NewsletterMessage
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
newsletter_draft_message_id:
|
|
type: INTEGER
|
|
required: false
|
|
foreignTable: st_newsletter_draft_message
|
|
foreignReference: id
|
|
onDelete: setnull
|
|
opt_subject:
|
|
type: VARCHAR
|
|
size: 255
|
|
required: true
|
|
opt_content:
|
|
type: LONGTEXT
|
|
main_image:
|
|
type: VARCHAR
|
|
size: 255
|
|
main_image_url:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_cta_button_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
cta_button_url:
|
|
type: VARCHAR
|
|
size: 255
|
|
cta_button_position:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_cta_description_head:
|
|
type: LONGTEXT
|
|
opt_cta_description_foot:
|
|
type: LONGTEXT
|
|
opt_products_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_recommends_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
sent_at:
|
|
type: TIMESTAMP
|
|
number_sent:
|
|
type: INTEGER
|
|
number_sent_gmail:
|
|
type: INTEGER
|
|
number_received:
|
|
type: INTEGER
|
|
number_read:
|
|
type: INTEGER
|
|
template_version:
|
|
type: INTEGER
|
|
hash:
|
|
type: VARCHAR
|
|
size: 255
|
|
required: true
|
|
st_newsletter_draft_message:
|
|
_attributes:
|
|
phpName: NewsletterDraftMessage
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
opt_subject:
|
|
type: VARCHAR
|
|
size: 255
|
|
required: true
|
|
opt_content:
|
|
type: LONGTEXT
|
|
main_image:
|
|
type: VARCHAR
|
|
size: 255
|
|
main_image_url:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_cta_button_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
cta_button_url:
|
|
type: VARCHAR
|
|
size: 255
|
|
cta_button_position:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_cta_description_head:
|
|
type: LONGTEXT
|
|
opt_cta_description_foot:
|
|
type: LONGTEXT
|
|
opt_products_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_recommends_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
test_emails:
|
|
type: VARCHAR
|
|
size: 255
|
|
hash:
|
|
type: VARCHAR
|
|
size: 255
|
|
required: true
|
|
st_newsletter_user_has_newsletter_group:
|
|
_attributes:
|
|
phpName: NewsletterUserHasNewsletterGroup
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
newsletter_group_id:
|
|
type: INTEGER
|
|
required: true
|
|
foreignTable: st_newsletter_group
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
newsletter_user_id:
|
|
type: INTEGER
|
|
required: true
|
|
foreignTable: st_newsletter_user
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
st_newsletter_message_has_newsletter_group:
|
|
_attributes:
|
|
phpName: NewsletterMessageHasNewsletterGroup
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
newsletter_message_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_newsletter_message
|
|
foreignReference: id
|
|
onDelete: restrict
|
|
newsletter_group_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_newsletter_group
|
|
foreignReference: id
|
|
onDelete: restrict
|
|
st_newsletter_message_has_product:
|
|
_attributes:
|
|
phpName: NewsletterMessageHasProduct
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
newsletter_message_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_newsletter_message
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
product_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_product
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
st_newsletter_draft_message_has_product:
|
|
_attributes:
|
|
phpName: NewsletterDraftMessageHasProduct
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
newsletter_draft_message_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_newsletter_draft_message
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
product_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_product
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
st_newsletter_message_has_blog:
|
|
_attributes:
|
|
phpName: NewsletterMessageHasBlog
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
newsletter_message_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_newsletter_message
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
blog_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_blog
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
st_newsletter_draft_message_has_blog:
|
|
_attributes:
|
|
phpName: NewsletterDraftMessageHasBlog
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
newsletter_draft_message_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_newsletter_draft_message
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
blog_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_blog
|
|
foreignReference: id
|
|
onDelete: cascade |