← 类型画廊GitHub ↗

数据库 schema · 图表设计

电商数据库 · 订单子系统

电商数据库订单子系统：五表物理模型，删除订单级联到订单项 物理 schema：public 四表加 billing.invoices，列级外键、SQL 类型、约束芯片与索引区；订单删除时订单项级联删除，其余外键 RESTRICT BILLING ON DELETE RESTRICT ON DELETE CASCADE ON DELETE RESTRICT ON DELETE RESTRICT public.customers TABLE id PK uuid email UQ NN text created_at NN timestamptz public.orders TABLE id PK uuid customer_id FK NN uuid status NN text total NN numeric(12,2) placed_at NN timestamptz INDEXES idx_orders_customer_id idx_orders_status public.order_items TABLE id PK uuid order_id FK NN uuid product_id FK NN uuid qty NN integer unit_price NN numeric(12,2) public.products TABLE id PK uuid sku UQ NN text name NN text price NN numeric(12,2) 另有 3 列未显示 INDEXES uq_products_sku billing.invoices TABLE id PK uuid order_id FK NN uuid issued_at NN timestamptz 图例 表 schema 分组 约束芯片 外键 · RESTRICT 级联删除 · CASCADE