Last active
August 29, 2015 14:00
-
-
Save cvengros/a85874dd8f8da034c70d to your computer and use it in GitHub Desktop.
Data model for salesapp
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "title": "salesapp", | |
| "datasets": [ | |
| { | |
| "name":"account", | |
| "columns":[ | |
| { | |
| "name":"id", | |
| "type":"anchor" | |
| }, | |
| { | |
| "name":"name", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"url", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"region", | |
| "type":"attribute" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"activity", | |
| "columns":[ | |
| { | |
| "name":"id", | |
| "type":"anchor" | |
| }, | |
| { | |
| "name":"subject", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"type", | |
| "type":"attribute" | |
| }, | |
| { | |
| "name":"status", | |
| "type":"attribute" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"activity_owner", | |
| "columns":[ | |
| { | |
| "name":"id", | |
| "type":"anchor" | |
| }, | |
| { | |
| "name":"name", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"url", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"department", | |
| "type":"attribute" | |
| }, | |
| { | |
| "name":"region", | |
| "type":"attribute" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"forecast", | |
| "columns":[ | |
| { | |
| "name":"id", | |
| "type":"anchor" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"opportunity", | |
| "columns":[ | |
| { | |
| "name":"id", | |
| "type":"anchor" | |
| }, | |
| { | |
| "name":"name", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"url", | |
| "type":"label", | |
| "reference":"id" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"opp_owner", | |
| "columns":[ | |
| { | |
| "name":"id", | |
| "type":"anchor" | |
| }, | |
| { | |
| "name":"name", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"url", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"department", | |
| "type":"attribute" | |
| }, | |
| { | |
| "name":"region", | |
| "type":"attribute" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"product", | |
| "columns":[ | |
| { | |
| "name":"id", | |
| "type":"anchor" | |
| }, | |
| { | |
| "name":"name", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"product_type", | |
| "type":"attribute" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"stage", | |
| "columns":[ | |
| { | |
| "name":"is_closed", | |
| "type":"attribute" | |
| }, | |
| { | |
| "name":"is_won", | |
| "type":"attribute" | |
| }, | |
| { | |
| "name":"status", | |
| "type":"attribute" | |
| }, | |
| { | |
| "name":"id", | |
| "type":"anchor" | |
| }, | |
| { | |
| "name":"order", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"name", | |
| "type":"label", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"is_active", | |
| "type":"attribute" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"activity_monitoring", | |
| "columns":[ | |
| { | |
| "name": "dummy", | |
| "type": "fact" | |
| }, | |
| { | |
| "name":"activity_date", | |
| "type":"date", | |
| "dataset":"activity" | |
| }, | |
| { | |
| "name":"opp_created_date", | |
| "type":"date", | |
| "dataset":"oppcreated" | |
| }, | |
| { | |
| "name":"opp_close_date", | |
| "type":"date", | |
| "dataset":"oppclose" | |
| }, | |
| { | |
| "name":"activity_id_id", | |
| "type":"reference", | |
| "dataset":"activity", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"account_id_id", | |
| "type":"reference", | |
| "dataset":"account", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"opportunity_id_id", | |
| "type":"reference", | |
| "dataset":"opportunity", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"activity_owner_id_id", | |
| "type":"reference", | |
| "dataset":"activity_owner", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"opp_owner_id_id", | |
| "type":"reference", | |
| "dataset":"opp_owner", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"product_id_id", | |
| "type":"reference", | |
| "dataset":"product", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"stage_id_id", | |
| "type":"reference", | |
| "dataset":"stage", | |
| "reference":"id" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"opp_records", | |
| "columns":[ | |
| { | |
| "name":"amount", | |
| "type":"fact" | |
| }, | |
| { | |
| "name":"probability", | |
| "type":"fact" | |
| }, | |
| { | |
| "name":"account_id_id", | |
| "type":"reference", | |
| "dataset":"account", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"opp_owner_id_id", | |
| "type":"reference", | |
| "dataset":"opp_owner", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"opportunity_id_id", | |
| "type":"reference", | |
| "dataset":"opportunity", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"product_id_id", | |
| "type":"reference", | |
| "dataset":"product", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"stage_id_id", | |
| "type":"reference", | |
| "dataset":"stage", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"created_date", | |
| "type":"date", | |
| "dataset":"oppcreated" | |
| }, | |
| { | |
| "name":"close_date", | |
| "type":"date", | |
| "dataset":"oppclose" | |
| }, | |
| { | |
| "name":"forecast_id_id", | |
| "type":"reference", | |
| "dataset":"forecast", | |
| "reference":"id" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"opp_snapshot", | |
| "columns":[ | |
| { | |
| "name":"amount", | |
| "type":"fact" | |
| }, | |
| { | |
| "name":"probability", | |
| "type":"fact" | |
| }, | |
| { | |
| "name":"account_id_id", | |
| "type":"reference", | |
| "dataset":"account", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"opp_owner_id_id", | |
| "type":"reference", | |
| "dataset":"opp_owner", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"opportunity_id_id", | |
| "type":"reference", | |
| "dataset":"opportunity", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"product_id_id", | |
| "type":"reference", | |
| "dataset":"product", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"stage_id_id", | |
| "type":"reference", | |
| "dataset":"stage", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"snapshot_date", | |
| "type":"date", | |
| "dataset":"snapshot" | |
| }, | |
| { | |
| "name":"created_date", | |
| "type":"date", | |
| "dataset":"oppcreated" | |
| }, | |
| { | |
| "name":"close_date", | |
| "type":"date", | |
| "dataset":"oppclose" | |
| }, | |
| { | |
| "name":"forecast_id_id", | |
| "type":"reference", | |
| "dataset":"forecast", | |
| "reference":"id" | |
| } | |
| ] | |
| }, | |
| { | |
| "name":"stage_history", | |
| "columns":[ | |
| { | |
| "name":"stage_duration", | |
| "type":"fact" | |
| }, | |
| { | |
| "name":"stage_velocity", | |
| "type":"fact" | |
| }, | |
| { | |
| "name":"account_id_id", | |
| "type":"reference", | |
| "dataset":"account", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"opp_owner_id_id", | |
| "type":"reference", | |
| "dataset":"opp_owner", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"opportunity_id_id", | |
| "type":"reference", | |
| "dataset":"opportunity", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"product_id_id", | |
| "type":"reference", | |
| "dataset":"product", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"stage_id_id", | |
| "type":"reference", | |
| "dataset":"stage", | |
| "reference":"id" | |
| }, | |
| { | |
| "name":"created_date", | |
| "type":"date", | |
| "dataset":"oppcreated" | |
| }, | |
| { | |
| "name":"close_date", | |
| "type":"date", | |
| "dataset":"oppclose" | |
| } | |
| ] | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment