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