capstone

Tables (6)

Order

  • OrderId — LONG — Primary key — NOT NULL
  • USERID — Long — Foreign key → User.USERID — NOT NULL
  • currency — varchar
  • quantity — int
  • createdAt — DATE
  • request — varchar
  • OrderStatus — varchar
  • paymentMethod — String
  • productId — long
  • Field

OrderDetail

  • OrderDetailId — Long — Primary key — NOT NULL
  • OrderId — LONG — Foreign key → Order.OrderId — NOT NULL
  • USERID — Long — Foreign key → Order.USERID — NOT NULL
  • productId — varchar — Foreign key → Product.productId — NOT NULL
  • storeId (StoreId) — LONG — Foreign key → Product.storeId — NOT NULL
  • productName — varchar
  • ImageURL — String
  • price — int
  • address — varchar
  • userName — String
  • reciverName — varchar
  • createAt — DATE
  • storeName — String
  • quantity — int

Product

  • productId — varchar — Primary key — NOT NULL
  • storeId (StoreId) — LONG — Foreign key → store.storeId — NOT NULL
  • name — varchar
  • imageURL — varchar
  • price — int
  • createdAt — DATE
  • isSoldOut — boolean
  • amount — int
  • description — varchar
  • discount — int

Shopping address DB

  • addressId — Long — Primary key — NOT NULL
  • USERID — Long — Foreign key → User.USERID — NOT NULL
  • receiverName — varchar
  • phoneNumber — varchar
  • address — varchar
  • postalCode — varchar
  • country — varchar
  • createdAt — DATE

User

  • USERID — Long — Primary key — NOT NULL
  • email — varchar
  • createdAt — DATE
  • name — varchar
  • phoneNumber

store

  • storeId (StoreId) — LONG — Primary key — NOT NULL
  • name — String
  • number — LONG