mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-07 07:55:13 +02:00
24 lines
453 B
YAML
24 lines
453 B
YAML
name: invoice_lines
|
|
table: invoice_lines
|
|
grain:
|
|
- invoice_line_id
|
|
columns:
|
|
- name: invoice_line_id
|
|
type: number
|
|
- name: amount
|
|
type: number
|
|
- name: invoice_id
|
|
type: number
|
|
- name: product_id
|
|
type: number
|
|
- name: quantity
|
|
type: string
|
|
- name: unit_price
|
|
type: number
|
|
joins:
|
|
- to: products
|
|
'on': product_id = products.product_id
|
|
relationship: many_to_one
|
|
- to: invoices
|
|
'on': invoice_id = invoices.invoice_id
|
|
relationship: many_to_one
|