commerce
Version 1.0
Online shop: customers, products, orders.
Subject areas
| Name | Description | Entities |
|---|---|---|
| Catalog | Products and categories. | 2 |
| Sales | Ordering flow. | 6 |
Entities
| Name | Description | Attributes | Subject areas |
|---|---|---|---|
| address | A postal address of a customer. | 7 | Sales |
| category | A product category; categories form a tree. | 3 | Catalog |
| coupon | 4 | Sales | |
| customer | A registered buyer. | 4 | Sales |
| order | A placed order. | 6 | Sales |
| order_line | 5 | Sales | |
| payment | 5 | Sales | |
| product | Something for sale. | 7 | Catalog |
Domains
| Name | Type | Null | Default | Check | Description |
|---|---|---|---|---|---|
| text(320) | no | value ~ '^[^@]+@[^@]+$' | RFC 5321 address, case preserved. | ||
| money | decimal(12, 2) | no | 0 |
Enums
| Name | Values | Description |
|---|---|---|
| order_status | pending, paid, shipped, cancelled |
Targets
| Name | Dialect | Schemas | Tables |
|---|---|---|---|
| lite | sqlite | 1 | 8 |
| pg | postgresql | 1 | 8 |