When you first log in to Pecan, there’s a demo data connection that is already configured in your account called “demodata”.
This connection allows you to test the platform, and it is set to the default dataset for all of Pecan’s templates.
In this article, you can see the demo data schema and table samples.
You can also view the tables in this link.
Tables overview
Table name | Description |
data related to the customer | |
customer purchases | |
customer became VIP (tier) | |
promotions sent to the customer | |
customer calls received by the call center | |
customer subscription plans history |
customers table sample
transactions table sample
operating_department - The department that works on the order
service_id - Where the customer received service
quantity - Quantity purchased in the order
vip_members table sample
status_change_date - the date a customer converted to become a VIP
sales_channel - the channel the customer upgraded through
campaigns table sample
support_calls table sample