Marketplace

Tables (16)

Benefit

  • id — Primary key — NOT NULL

Cart

  • id — Primary key — NOT NULL
  • member_id — Foreign key → Member.id — NOT NULL

CartItem

  • id — Primary key — NOT NULL
  • cart_id — Foreign key → Cart.id — NOT NULL
  • product_id — Foreign key → Product.id — NOT NULL

Contract

  • id — Primary key — NOT NULL
  • vendor_group_id — Foreign key → VendorGroup.id — NOT NULL
  • owner_id — Foreign key → Owner.id — NOT NULL
  • dhproduct_id — Foreign key → DHProduct.id — NOT NULL

DHProduct

  • id — Primary key — NOT NULL

DeliveryArea

  • id — Primary key — NOT NULL
  • vendorKey (Key) — Foreign key → Vendor.vendorKey — NOT NULL

Member

  • id — Primary key — NOT NULL

Membership

  • id — Primary key — NOT NULL
  • subscription_schema_id — Foreign key → SubscriptionScheme.id — NOT NULL
  • member_id — Foreign key → Member.id — NOT NULL

Order

  • id — Primary key — NOT NULL
  • cart_id — Foreign key → Cart.id — NOT NULL
  • benefit_id — Foreign key → Benefit.id — NOT NULL
  • promotion_id — Foreign key → Promotion.id — NOT NULL

Owner

  • id — Primary key — NOT NULL

Payment

  • id — Primary key — NOT NULL
  • order_id — Foreign key → Order.id — NOT NULL

Product

  • id — Primary key — NOT NULL
  • vendor_id — Foreign key → Vendor.vendorKey — NOT NULL

Promotion

  • id — Primary key — NOT NULL
  • vendor_id — Foreign key → Vendor.vendorKey — NOT NULL

SubscriptionScheme

  • id — Primary key — NOT NULL
  • benefit_id — Foreign key → Benefit.id — NOT NULL

Vendor

  • vendorKey (Key) — Primary key — NOT NULL
  • vendorGroupKey (Key2) — Foreign key → VendorGroup.id — NOT NULL

VendorGroup

  • id — Primary key — NOT NULL
  • parent_id — Foreign key → VendorGroup.id — NOT NULL