SneakersMall

Tables (6)

Brand (브랜드)

  • ID (_id) — String — Primary key — NOT NULL
  • BrandName (name) — String not null

Cart (장바구니(로컬스토리지))

  • Id — String not null — Primary key — NOT NULL
  • UserId (userId) — String not null — Foreign key → User.Id — NOT NULL
  • RegDate (cartRegDate) — Date
  • ProductCode (productCode) — String not null — Foreign key → Product.Code — NOT NULL
  • ProductContent (productContent) — String not null

OrderDetails (주문 상세)

  • Id (_id) — String not null — Primary key — NOT NULL
  • Id (orderId) — String not null — Foreign key → Orders.Id — NOT NULL
  • ProductCode (productCode) — String not null
  • Quantity (quantity) — Number

Orders (주문)

  • Id (_id) — Number — Primary key — NOT NULL
  • Id (userId) — String not null — Foreign key → User.Id — NOT NULL
  • Name (name) — String not null
  • Address (address) — String not null
  • Tel (phoneNumber) — String not null
  • Account (account) — String not null
  • Field (orderList) — Object not null
  • State (orderState) — String not null
  • RegDate (regDate) — String not null

Product (상품)

  • Code (code) — String not null — Primary key — NOT NULL
  • BrandCode (brand) — String not null — Foreign key → Brand.ID — NOT NULL
  • Name (name) — String not null
  • Image (imageUrl) — String not null — 이미지 URL
  • Content (content) — String not null
  • category — String not null — male / female / kids
  • Size (size) — Number not null
  • Price (price) — Number not null
  • Stock (stock) — Number not null
  • RegDate (regDate) — Date

User (고객)

  • Id (userId) — String not null — Primary key — NOT NULL
  • Email (email) — String not null
  • Password (password) — String not null
  • Nickname (name) — String not null
  • Address (address) — Object
  • Tel (phoneNumber) — String not null
  • Role (role) — String not null