mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-10 08:05:14 +02:00
29 lines
546 B
YAML
29 lines
546 B
YAML
|
name: quotes
|
||
|
|
table: quotes
|
||
|
|
grain:
|
||
|
|
- quote_id
|
||
|
|
columns:
|
||
|
|
- name: quote_id
|
||
|
|
type: number
|
||
|
|
- name: created_at
|
||
|
|
type: time
|
||
|
|
role: time
|
||
|
|
- name: opportunity_id
|
||
|
|
type: number
|
||
|
|
- name: pricebook_id
|
||
|
|
type: number
|
||
|
|
- name: rep_id
|
||
|
|
type: number
|
||
|
|
- name: status
|
||
|
|
type: string
|
||
|
|
joins:
|
||
|
|
- to: sales_reps
|
||
|
|
'on': rep_id = sales_reps.rep_id
|
||
|
|
relationship: many_to_one
|
||
|
|
- to: pricebooks
|
||
|
|
'on': pricebook_id = pricebooks.pricebook_id
|
||
|
|
relationship: many_to_one
|
||
|
|
- to: opportunities
|
||
|
|
'on': opportunity_id = opportunities.opportunity_id
|
||
|
|
relationship: many_to_one
|