mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-10 08:05:14 +02:00
23 lines
428 B
YAML
23 lines
428 B
YAML
name: forecast_snapshots
|
|
table: forecast_snapshots
|
|
grain:
|
|
- snapshot_id
|
|
columns:
|
|
- name: snapshot_id
|
|
type: number
|
|
- name: category
|
|
type: string
|
|
- name: rep_id
|
|
type: number
|
|
- name: snapshot_date
|
|
type: time
|
|
role: time
|
|
- name: team_id
|
|
type: number
|
|
joins:
|
|
- to: sales_teams
|
|
'on': team_id = sales_teams.team_id
|
|
relationship: many_to_one
|
|
- to: sales_reps
|
|
'on': rep_id = sales_reps.rep_id
|
|
relationship: many_to_one
|