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