KarcherMake:
  actAs: { Timestampable: ~ }
  columns:
    name:        { type: string(255), notnull: true}
    description: { type: string(255), notnull: false }
    status:      { type: integer, notnull:false, default: 0 }
    thumb_img:   { type: string(255), notnull: false }
    header_img:  { type: string(255), notnull: false}
    image:       { type: string(255), notnull: false }

KarcherSuperCategory:
  actAs: { Timestampable: ~ }
  columns:
    make_id:     { type: integer, notnull: false }
    name:        { type: string(255), notnull: true}
    description: { type: string(255), notnull: false}
    status:      { type: integer, notnull:false, default: 0 }
    thumb_img:   { type: string(255), notnull: false}
    header_img:  { type: string(255), notnull: false }
    image:       { type: string(255), notnull: false }

KarcherCategory:
  actAs: { Timestampable: ~ }
  columns:
    supercategory_id: { type: integer, notnull: true }
    name:             { type: string(255), notnull: true }
    description:      { type: string(255), notnull: false }
    status:           { type: integer, notnull:false, default: 0 }
    thumb_img:        { type: string(255), notnull: false }
    header_img:       { type: string(255), notnull: false }
    image:            { type: string(255), notnull: false }
  relations:
    KarcherSuperCategory: { local: supercategory_id, foreign: id, foreignAlias: KarcherCategories, onDelete: CASCADE }

KarcherContent:
  actAs: { Timestampable: ~ }
  columns:
    category_id:  { type: integer, notnull: true }
    kind:         { type: string(255) }
    header:       { type: string(255) }
    intro:        { type: string(255) }
    copy:         { type: clob, notnull: false }
    image:        { type: string(255) }
    additional1:  { type: clob, notnull: false }
    additional2:  { type: clob, notnull: false }
    additional3:  { type: clob, notnull: false }
    additional4:  { type: clob, notnull: false }
    additional5:  { type: clob, notnull: false }
    additional5:  { type: clob, notnull: false }
    additional6:  { type: clob, notnull: false }
    additional7:  { type: clob, notnull: false }
    additional8:  { type: clob, notnull: false }
    additional9:  { type: clob, notnull: false }
    additional10:  { type: clob, notnull: false }
    additional11:  { type: clob, notnull: false }
    additional12:  { type: clob, notnull: false }
    additional13:  { type: clob, notnull: false }
    additional14:  { type: clob, notnull: false }
    additional15:  { type: clob, notnull: false }
    position:   {  type: integer, notnull:false, default: 10}
    link:         { type: string(255) }
    status:       { type: integer, notnull:false, default: 0 }
    focus:        { type: integer, notnull:false, default: 0 }
    created_at:
    updated_at:
  relations:
    KarcherCategory: { local: category_id, foreign: id, foreignAlias: KarcherContents, onDelete: CASCADE }

KarcherSpecLeft:
  actAs: { Timestampable: ~ }
  columns:
    category_id:  { type: integer, notnull: true }
    header1:      { type: string(255) }
    header2:      { type: string(255) }
    header3:      { type: string(255) }
    header4:      { type: string(255) }
    header5:      { type: string(255) }
    header6:      { type: string(255) }
    header7:      { type: string(255) }
    header8:      { type: string(255) }
    header9:      { type: string(255) }
    header10:      { type: string(255) }
    header11:      { type: string(255) }
    header12:      { type: string(255) }
    header13:      { type: string(255) }
    header14:      { type: string(255) }
    header15:      { type: string(255) }
    created_at:
    updated_at:
  relations:
    KarcherCategory: { local: category_id, foreign: id, foreignAlias: KarcherSpecLefts }

KarcherStatic:
  actAs: { Timestampable: ~ }
  columns:
    kind:         { type: string(255) }
    header:       { type: string(255) }
    intro:        { type: string(255) }
    copy:         { type: clob, notnull: false }
    image:        { type: string(255) }
    additional1:  { type: clob, notnull: false }
    additional2:  { type: clob, notnull: false }
    additional3:  { type: clob, notnull: false }
    additional4:  { type: clob, notnull: false }
    additional5:  { type: clob, notnull: false }
    link:         { type: string(255) }
    status:       { type: integer, notnull:false, default: 0 }
    focus:        { type: integer, notnull:false, default: 0 }
    created_at:
    updated_at:

KarcherNews:
  actAs: {Timestampable: ~ }
  columns:
    header:       { type: string(255) }
    intro:        { type: string(255) }
    copy:         { type: string(255) }
    link:         { type: string(255) }
    status:       { type: integer, notnull:false, default: 0 }
    focus:        { type: integer, notnull:false, default: 0 }
    image:        { type: string(255) }
    created_at:
    updated_at:

KarcherUser:
  actAs: { Timestampable: ~ }
  columns:
    username:     { type: string(255), notnull: true }
    password:     { type: string(255), notnull: true }
    email:        { type: string(255), notnull: true, unique: true }
    status:       { type: integer, notnull: true, default: 0 }