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