Skip to content

Instantly share code, notes, and snippets.

@cvengros

cvengros/salesapp_model.json

Last active August 29, 2015 14:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cvengros/a85874dd8f8da034c70d to your computer and use it in GitHub Desktop.
Save cvengros/a85874dd8f8da034c70d to your computer and use it in GitHub Desktop.
Download ZIP
Data model for salesapp
Raw
salesapp_model.json
{
"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