mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-10 08:05:14 +02:00
24 lines
373 B
YAML
24 lines
373 B
YAML
|
name: contacts
|
||
|
|
table: contacts
|
||
|
|
grain:
|
||
|
|
- contact_id
|
||
|
|
columns:
|
||
|
|
- name: contact_id
|
||
|
|
type: number
|
||
|
|
- name: account_id
|
||
|
|
type: number
|
||
|
|
- name: email
|
||
|
|
type: string
|
||
|
|
- name: first_name
|
||
|
|
type: string
|
||
|
|
- name: last_name
|
||
|
|
type: string
|
||
|
|
- name: phone
|
||
|
|
type: string
|
||
|
|
- name: title
|
||
|
|
type: string
|
||
|
|
joins:
|
||
|
|
- to: accounts
|
||
|
|
'on': account_id = accounts.account_id
|
||
|
|
relationship: many_to_one
|