mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-10 08:05:14 +02:00
23 lines
417 B
YAML
23 lines
417 B
YAML
|
name: supplier
|
||
|
|
table: public.supplier
|
||
|
|
grain: [s_suppkey]
|
||
|
|
columns:
|
||
|
|
- name: s_suppkey
|
||
|
|
type: number
|
||
|
|
- name: s_name
|
||
|
|
type: string
|
||
|
|
- name: s_address
|
||
|
|
type: string
|
||
|
|
- name: s_nationkey
|
||
|
|
type: number
|
||
|
|
- name: s_phone
|
||
|
|
type: string
|
||
|
|
- name: s_acctbal
|
||
|
|
type: number
|
||
|
|
- name: s_comment
|
||
|
|
type: string
|
||
|
|
joins:
|
||
|
|
- to: nation
|
||
|
|
"on": s_nationkey = nation.n_nationkey
|
||
|
|
relationship: many_to_one
|