mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-10 08:05:14 +02:00
22 lines
403 B
YAML
22 lines
403 B
YAML
|
name: order_items
|
||
|
|
table: public.order_items
|
||
|
|
grain: [id]
|
||
|
|
columns:
|
||
|
|
- name: id
|
||
|
|
type: number
|
||
|
|
- name: order_id
|
||
|
|
type: number
|
||
|
|
- name: product_id
|
||
|
|
type: number
|
||
|
|
- name: quantity
|
||
|
|
type: number
|
||
|
|
- name: price
|
||
|
|
type: number
|
||
|
|
joins:
|
||
|
|
- to: orders
|
||
|
|
"on": order_id = orders.id
|
||
|
|
relationship: many_to_one
|
||
|
|
- to: products
|
||
|
|
"on": product_id = products.id
|
||
|
|
relationship: many_to_one
|