erd
Tables (7)
CATEGORY_MST (Untitled6)
- category_mst_id (PK) — Primary key — NOT NULL
- Field
DISPLAY_INFO (Untitled5)
- display_info_id (PK) — Primary key — NOT NULL
- product_id (FK) — String — Foreign key → PRODUCT_MST.product_id — NOT NULL
- is_display (Field) — Enum
- Field2
PRICE_INFO (Untitled4)
- Key (PK) — Primary key — NOT NULL
- product_id (FK) — String — Foreign key → PRODUCT_MST.product_id — NOT NULL
- supply_price (Field) — decimal
- discount_price1 (Field2) — decimal
- discount_price2 (Field3) — decimal
- display_price (Field4) — decimal
- is_free_Delivery (Field6) — boolean
- consumer_price (Field5) — decimal
- supply_special_price (Field7) — decimal
PRODUCT_ATTACHMENT (Untitled3)
- Key — Primary key — NOT NULL
- product_id (FK) — String — Foreign key → PRODUCT_MST.product_id — NOT NULL
- file_name (Field) — String
- file_path (Field2) — String
- file_extension (Field3) — String
- file_size (Field4) — int
- is_active (Field5) — boolean
- position (Field6) — int, NOT NULL CHECK (position BETWEEN 1 AND 3)
PRODUCT_INFO (Untitled2)
- product_info_id (PK) — Primary key — NOT NULL
- product_id (FK) — String — Foreign key → PRODUCT_MST.product_id — NOT NULL
- Field
PRODUCT_MST (Untitled)
- product_id (PK) — String — Primary key — NOT NULL
- product_code (Field) — String
- product_name (Field2)
- Field3