142 lines
2.9 KiB
YAML
142 lines
2.9 KiB
YAML
---
|
|
propel:
|
|
_attributes:
|
|
defaultIdMethod: native
|
|
package: plugins.stBlogPlugin.lib.model
|
|
st_blog:
|
|
_attributes:
|
|
phpName: Blog
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
sf_asset_id:
|
|
type: INTEGER
|
|
foreignTable: sf_asset
|
|
foreignReference: id
|
|
onDelete: setnull
|
|
active:
|
|
type: BOOLEAN
|
|
opt_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_short_description:
|
|
type: MEDIUMTEXT
|
|
opt_long_description:
|
|
type: MEDIUMTEXT
|
|
opt_head_description:
|
|
type: MEDIUMTEXT
|
|
opt_cta_description_head:
|
|
type: MEDIUMTEXT
|
|
opt_cta_description_foot:
|
|
type: MEDIUMTEXT
|
|
opt_cta_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_cta_url:
|
|
type: VARCHAR
|
|
size: 255
|
|
cta_position:
|
|
type: VARCHAR
|
|
size: 255
|
|
image_main_page:
|
|
type: VARCHAR
|
|
size: 255
|
|
image:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_url:
|
|
type: VARCHAR
|
|
size: 255
|
|
alternative_url:
|
|
type: VARCHAR
|
|
size: 255
|
|
gallery:
|
|
type: VARCHAR
|
|
size: 4096
|
|
phpType: array
|
|
recommend:
|
|
type: VARCHAR
|
|
size: 4096
|
|
st_blog_category:
|
|
_attributes:
|
|
phpName: BlogCategory
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
active:
|
|
type: BOOLEAN
|
|
opt_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_url:
|
|
type: VARCHAR
|
|
size: 255
|
|
banner_group:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_description:
|
|
type: LONGVARCHAR
|
|
st_blog_has_blog_category:
|
|
_attributes:
|
|
phpName: BlogHasBlogCategory
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
blog_id:
|
|
type: INTEGER
|
|
required: true
|
|
foreignTable: st_blog
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
blog_category_id:
|
|
type: INTEGER
|
|
required: true
|
|
foreignTable: st_blog_category
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
blog_category_main:
|
|
type: BOOLEAN
|
|
st_blog_has_product:
|
|
_attributes:
|
|
phpName: BlogHasProduct
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
blog_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_blog
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
product_id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
foreignTable: st_product
|
|
foreignReference: id
|
|
onDelete: cascade |