database_test

Tables (6)

Customer (Untitled)

  • customerId (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • email (Field2) — varchar(255)
  • phoneNumber (Field3) — varchar(20)

Orders (Untitled3)

  • orderId (Key) — int — Primary key — NOT NULL
  • customerId (Key2) — int — Foreign key → Customer.customerId — NOT NULL
  • orderDate (Field) — datetime
  • deliveryStatus (Field2) — varchar(50)
  • paymentStatus (Field3) — varchar(50)

deliveryAddress (Untitled2)

  • addressId (Key) — int — Primary key — NOT NULL
  • customerId (Key2) — int — Foreign key → Customer.customerId — NOT NULL
  • customerId (Field) — int
  • address (Field2) — varchar(255)

payment (Untitled4)

  • paymentId (Key) — int — Primary key — NOT NULL
  • orderId (Key2) — int — Foreign key → Orders.orderId — NOT NULL
  • amount (Field) — decimal(10,2)
  • paymentMethod (Field2) — varchar(50)
  • paymentStatus (Field3) — varchar(50)

product (Untitled5)

  • productId (Key) — int — Primary key — NOT NULL
  • productCode (Field) — varchar(100)
  • category (Field2) — varchar(50)
  • stockQuantity (Field3) — int
  • price (Field4) — decimal(10,2)

review (Untitled6)

  • reviewId (Key) — int — Primary key — NOT NULL
  • customerId (Key2) — int — Foreign key → Customer.customerId — NOT NULL
  • productId (Key3) — int — Foreign key → product.productId — NOT NULL
  • content (Field) — text
  • raiting (Field2) — int
  • reviewDate (Field3) — date