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

Untitled7