kb

Tables (14)

CartItem (Untitled13)

  • id — BIGINT — Primary key — NOT NULL
  • productId — BIGINT — Foreign key → Product.id — NOT NULL
  • quantity — BIGINT

Order (Untitled6)

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Foreign key → app_user.id — NOT NULL
  • orderDate — TIMESTAMP
  • totalAmount — DOUBLE
  • street (Field) — VARCHAR
  • city — VARCHAR
  • state — VARCHAR
  • zipCode — VARCHAR
  • country — VARCHAR
  • status — VARCHAR

Payment (Untitled12)

  • id — BIGINT — Primary key — NOT NULL
  • orderId — BIGINT — Foreign key → Order.id — NOT NULL
  • paymentMethod — VARCHAR
  • amount — DOUBLE
  • paymentDate — TIMESTAMP
  • transactionId — VARCHAR
  • status — VARCHAR
  • provider — VARCHAR
  • externalTransactionId — VARCHAR

Product (Untitled5)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • description — VARCHAR
  • price — DOUBLE
  • imageUrl — VARCHAR
  • qty — BIGINT
  • productCategory — VARCHAR
  • vendorCode — VARCHAR
  • Field

ShippingInfo (Untitled14)

  • id — BIGINT — Primary key — NOT NULL
  • orderId — BIGINT — Foreign key → Order.id — NOT NULL
  • shippingStatus — VARCHAR

Stocks (Untitled4)

  • id — BIGINT — Primary key — NOT NULL
  • warehouseId — BIGINT — Foreign key → Warehouse.id — NOT NULL
  • productId — BIGINT — Foreign key → Product.id — NOT NULL
  • quantity — BIGINT

Warehouse (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • location — VARCHAR

app_user (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR
  • password — VARCHAR
  • role — VARCHAR

fulfillments (Untitled7)

  • id — BIGINT — Primary key — NOT NULL
  • orderId — BIGINT — Foreign key → Order.id — NOT NULL
  • warehouseId — BIGINT — Foreign key → Warehouse.id — NOT NULL
  • productId — BIGINT — Foreign key → Product.id — NOT NULL
  • type — VARCHAR
  • status — VARCHAR
  • fulfillmentDate (fulfillmentStatus) — TIMESTAMP
  • quantity — VARCHAR

memberships (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Foreign key → app_user.id — NOT NULL
  • type — VARCHAR
  • startDate — TIMESTAMP
  • endDate — TIMESTAMP
  • durationInMonths — BIGINT
  • benefits — VARCHAR

order_items (Untitled10)

  • id — BIGINT — Primary key — NOT NULL
  • orderId — BIGINT — Foreign key → Order.id — NOT NULL
  • productId — BIGINT — Foreign key → Product.id — NOT NULL
  • sellerId — BIGINT — Foreign key → seller.id — NOT NULL
  • quantity — BIGINT
  • price — DOUBLE

order_status_2 (Untitled9)

  • idi (id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR

promotion (Untitled11)

  • id — BIGINT — Primary key — NOT NULL
  • promotionName — VARCHAR
  • promotionDescription — VARCHAR
  • promotionStartDt — TIMESTAMP
  • promotionEndDt — TIMESTAMP
  • promotionType — VARCHAR
  • affectRange — VARCHAR
  • discountRate — DOUBLE

seller (Untitled8)

  • id — BIGINT — Primary key — NOT NULL
  • sellerName — VARCHAR
  • sellerGrade — VARCHAR
  • margin — DOUBLE
  • policy — VARCHAR
  • category — VARCHAR