---
templates:
- name: tpl_minimal
columns:
- name: id
type: integer
notnull: 1
primarykey: 1
default: autoincrement
- name: active
type: bool
default: 1
- name: tpl_std
template: 'tpl_minimal'
columns:
- name: name
type: varchar
notnull: 1
default: current
- name: flag
type: timestamp
default: current
notnull: 1
- name: tpl_std_client_ref
template: 'tpl_std'
columns:
- name: client
type: integer
notnull: 1
foreignkey:
reftable: 'client'
refcolumn: 'id'
- name: tpl_minimal_client_ref
template: 'tpl_minimal'
columns:
- name: client
type: integer
notnull: 1
foreignkey:
reftable: 'client'
refcolumn: 'id'
- name: tpl_std_company_ref
template: 'tpl_std_client_ref'
columns:
- name: company
type: integer
notnull: 1
foreignkey:
reftable: 'company'
refcolumn: 'id'
changelogs:
- "01"
- "02"
- "03"