Giao diện
catalog / bảng đơn lẻ (3)
Trang sinh tự động
Sinh từ ad83b0aea — chạy 820 migration lên PostgreSQL 17 rồi đọc pg_catalog. Mô tả bảng và cột lấy từ COMMENT ON. Không sửa tay: lần chạy docgen sau sẽ ghi đè.
3 bảng. Quay lại catalog.
categories
P2-01. Product category tree (<= 5 levels, products on leaves only). Soft delete, version, code/name keys (trim + NFC + lower) unique among live rows only (U6-P2-20, X-02 / Rule #11). PERM_GATED catalog.read/write (matrix CAT-01/02).
public.categories · 16 cột · 6 check · 0 unique · 4 index · 3 policy · 4 trigger · RLS bật
| Cột | Kiểu | Khoá | Mô tả | |
|---|---|---|---|---|
id | uuid | NOT NULL | PK | |
code | text | NOT NULL | ||
code_key | text | |||
name | text | NOT NULL | ||
name_key | text | |||
parent_id | uuid | FK → categories | ||
description | text | |||
image_media_id | uuid | FK → media | U6-P2-20: optional category image (NH-US-02/03). FK public.media(id); attach rules = be:media assertAttachable CATEGORY_IMAGE (PRODUCT_IMAGE purpose, JPG/PNG, <= 5 MiB) + media_uses category_image. | |
status | text | NOT NULL | ||
created_by | uuid | NOT NULL | FK → accounts | |
updated_by | uuid | NOT NULL | FK → accounts | |
deleted_at | timestamptz | |||
deleted_by | uuid | FK → accounts | ||
created_at | timestamptz | NOT NULL | ||
updated_at | timestamptz | NOT NULL | ||
version | integer | NOT NULL |
Khoá chính: id
Trỏ ra (5):
created_by→accounts·ON DELETE RESTRICTdeleted_by→accounts·ON DELETE RESTRICTimage_media_id→media·ON DELETE RESTRICTparent_id→categories·ON DELETE RESTRICTupdated_by→accounts·ON DELETE RESTRICT
Được trỏ tới (3): categories, product_attributes, products
brands
P2-01. Flat brand list. Soft delete, version, code/name keys (trim + NFC + lower) unique among live rows only (U6-P2-21, X-02 / Rule #11). PERM_GATED catalog.read/write (matrix CAT-01/02).
public.brands · 14 cột · 4 check · 0 unique · 3 index · 3 policy · 4 trigger · RLS bật
| Cột | Kiểu | Khoá | Mô tả | |
|---|---|---|---|---|
id | uuid | NOT NULL | PK | |
code | text | NOT NULL | ||
code_key | text | |||
name | text | NOT NULL | ||
name_key | text | |||
description | text | |||
logo_media_id | uuid | FK → media | U6-P2-21: optional brand logo (TH-US-02/03). FK public.media(id); attach rules = be:media assertAttachable BRAND_LOGO (PRODUCT_IMAGE purpose, JPG/PNG, <= 5 MiB) + media_uses brand_logo. | |
created_by | uuid | NOT NULL | FK → accounts | |
updated_by | uuid | NOT NULL | FK → accounts | |
deleted_at | timestamptz | |||
deleted_by | uuid | FK → accounts | ||
created_at | timestamptz | NOT NULL | ||
updated_at | timestamptz | NOT NULL | ||
version | integer | NOT NULL |
Khoá chính: id
Trỏ ra (4):
created_by→accounts·ON DELETE RESTRICTdeleted_by→accounts·ON DELETE RESTRICTlogo_media_id→media·ON DELETE RESTRICTupdated_by→accounts·ON DELETE RESTRICT
Được trỏ tới (1): products
combo_components
P2-02. Standard products inside a combo with quantities. Written with the combo, immutable afterwards.
public.combo_components · 6 cột · 2 check · 1 unique · 3 index · 2 policy · 3 trigger · RLS bật
| Cột | Kiểu | Khoá | Mô tả | |
|---|---|---|---|---|
id | uuid | NOT NULL | PK | |
combo_id | uuid | NOT NULL | FK → products | |
component_id | uuid | NOT NULL | FK → products | |
quantity | integer | NOT NULL | ||
created_by | uuid | NOT NULL | FK → accounts | |
created_at | timestamptz | NOT NULL |
Khoá chính: id
Trỏ ra (3):
combo_id→products·ON DELETE RESTRICTcomponent_id→products·ON DELETE RESTRICTcreated_by→accounts·ON DELETE RESTRICT
Được trỏ tới: không có