Dataset and Schema
RadixTrade is a deterministic synthetic commerce database. The public profile contains exactly 5,000,000 rows in 32 tables connected by 48 declared foreign-key relationships. Those relationships are also available as RadixDB navigable references.
Dataset Profile
Section titled “Dataset Profile”| Property | Public profile |
|---|---|
| Dataset ID | radixtrade-online-5m |
| Schema version | 1 |
| RadixDB version | 1.2.25 |
| Rows | 5,000,000 |
| Tables | 32 |
| Relationships | 48 |
| Query examples | 20 |
| Generator seed | 2026091501 |
The generated population is stable for the same schema, scale and seed. IDs, nullable relationships, dates, statuses and numeric distributions are derived deterministically rather than copied from a production system.
Relationship Diagram
Section titled “Relationship Diagram”
The image is a full-schema view. The live schema tool can focus a table, show its columns and types, highlight immediate relationships and open the same entity in the schema explorer.
Table Cardinalities
Section titled “Table Cardinalities”| Table | Rows | Table | Rows |
|---|---|---|---|
countries |
28 | regions |
258 |
cities |
2,522 | branches |
54 |
warehouses |
104 | employees |
5,000 |
customer_groups |
8 | customers |
199,732 |
customer_addresses |
249,643 | suppliers |
9,991 |
brands |
508 | product_categories |
2,522 |
products |
100,091 | product_attributes |
199,913 |
price_lists |
8 | price_list_items |
199,913 |
stock_balances |
299,914 | purchase_orders |
150,002 |
purchase_order_lines |
449,916 | sales_channels |
4 |
campaigns |
504 | sales_orders |
700,099 |
sales_order_lines |
1,200,556 | payments |
350,095 |
shipments |
300,094 | shipment_lines |
200,003 |
sales_returns |
50,001 | sales_return_lines |
100,001 |
reviews |
50,001 | support_tickets |
50,001 |
loyalty_accounts |
99,911 | audit_events |
28,603 |
The row counts sum to 5,000,000. They are also returned by the live metadata API used to build the schema explorer.
Reproducibility
Section titled “Reproducibility”The generator manifest records the seed, schema and loader hashes, every CSV cardinality, byte size and SHA-256 digest, and checksummed aggregate totals. Generation publishes an artifact only after those values and all foreign-key ranges pass verification.
The manifest identifies the build used to create and qualify the dataset. The server running the same immutable dataset may receive later compatible engine fixes without changing its generated rows or manifest.
Scale Boundary
Section titled “Scale Boundary”The website serves the 5-million-row profile because it provides useful joins, aggregates and navigable-reference examples within the resource boundary of the shared website host. A 50-million-row form of the same schema is used for offline qualification. It is not the database behind the public Playground and its results must not be attributed to this live service.