Relationships between products and fulfillment categories
Data model
Fields
| Field | Type | Description |
|---|---|---|
| category_id* | INT | Category identifier |
| product_id* | INT | Product Identifier |
Primary Key
| PK_AES_PRODUCT_CATEGORY |
|---|
| product_id, category_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| category_id* | dbo.AES_CATEGORY | id | FK02_AES_PRODUCT_CATEGORY |
| product_id* | dbo.AES_PRODUCT | id | FK01_AES_PRODUCT_CATEGORY |