database-schema-examples

database-schema-examples copied to clipboard

Add schemas from Crunchy Demo Data repository

1

https://github.com/CrunchyData/crunchy-demo-data

janpio

Hackolade

1

https://hackolade.com/samplemodels.html > Models: Hackolade data models available for download:

janpio

https://www.kaggle.com/yelp-dataset/yelp-dataset/ https://www.yelp.com/dataset

janpio

replaces https://github.com/prisma/database-schema-examples/pull/87 TODO: - display width? precision? max length? - digits? - fractional seconds precision? - aliases?

janpio

``` SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE VIEW `inventory_stock_1` AS SELECT 1 AS `product_id`, 1 AS `website_id`, 1 AS `stock_id`, 1 AS `quantity`, 1 AS `is_salable`,...

gmai2006

via https://github.com/cockroachdb/movr/tree/master/sql

janpio

https://github.com/edent/Open-Source-Shakespeare https://github.com/catherinedevlin/opensourceshakespeare

janpio

so you can actually add data to `parm_periode`

janpio

To make them work properly, we need to re-export the SQL with the right DB selection from the tool (project links see README)

janpio

This will be needed to create databases with testdata available. Tracking: notion.so/prismaio/Data-Generation-DB-a4c8a9de39a244a89e5d8bc3bf397214

janpio