商品设计

erDiagram PMS_PRODUCT { bigint id PK bigint brand_id FK bigint product_category_id FK bigint feight_template_id FK varchar name varchar pic varchar product_sn int delete_status int publish_status decimal original_price int stock int version "乐观锁" }

PMS_BRAND {
    bigint id PK
    varchar name
    varchar first_letter
    int show_status
    varchar logo
    int version "乐观锁"
}

PMS_PRODUCT_CATEGORY {
    bigint id PK
    bigint parent_id FK
    varchar name
    int level
    int show_status
    int version "乐观锁"
}

PMS_SKU_STOCK {
    bigint id PK
    bigint product_id FK
    varchar sku_code
    decimal price
    int stock
    int lock_stock "库存锁定"
    varchar sp_data "销售属性JSON"
}

PMS_PRODUCT_ATTRIBUTE {
    bigint id PK
    bigint product_attribute_category_id FK
    varchar name
    int type "0规格1参数"
    int input_type
    int version "乐观锁"
}

PMS_PRODUCT_ATTRIBUTE_VALUE {
    bigint id PK
    bigint product_id FK
    bigint product_attribute_id FK
    varchar value
}

PMS_COMMENT {
    bigint id PK
    bigint product_id FK
    varchar member_nick_name
    int star
    text content
    int version "乐观锁"
}

PMS_FEIGHT_TEMPLATE {
    bigint id PK
    varchar name
    int charge_type
    decimal first_fee
    varchar dest
}

PMS_PRODUCT ||--o{ PMS_SKU_STOCK : "一对多"
PMS_BRAND ||--o{ PMS_PRODUCT : "一对多"
PMS_PRODUCT_CATEGORY ||--o{ PMS_PRODUCT : "一对多"
PMS_PRODUCT_CATEGORY ||--o{ PMS_PRODUCT_CATEGORY : "父子关系"
PMS_FEIGHT_TEMPLATE ||--o{ PMS_PRODUCT : "一对多"
PMS_PRODUCT ||--o{ PMS_PRODUCT_ATTRIBUTE_VALUE : "一对多"
PMS_PRODUCT_ATTRIBUTE ||--o{ PMS_PRODUCT_ATTRIBUTE_VALUE : "一对多"
PMS_PRODUCT ||--o{ PMS_COMMENT : "一对多"