mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-10 08:05:14 +02:00
23 lines
374 B
YAML
23 lines
374 B
YAML
|
name: card_transactions
|
||
|
|
table: card_transactions
|
||
|
|
grain:
|
||
|
|
- amount
|
||
|
|
columns:
|
||
|
|
- name: amount
|
||
|
|
type: number
|
||
|
|
- name: card_txn_id
|
||
|
|
type: number
|
||
|
|
- name: department
|
||
|
|
type: string
|
||
|
|
- name: employee_email
|
||
|
|
type: string
|
||
|
|
- name: txn_date
|
||
|
|
type: time
|
||
|
|
role: time
|
||
|
|
- name: vendor_id
|
||
|
|
type: number
|
||
|
|
joins:
|
||
|
|
- to: vendors
|
||
|
|
'on': vendor_id = vendors.vendor_id
|
||
|
|
relationship: many_to_one
|