온라인 스토어
테이블 (11)
Untitled (user)
- Key (id) — 기본 키 — NOT NULL
- Field (loginId)
- Field2 (password)
- Field (name)
- Field (phoneNumber)
- Field (email)
- Field (createdAt)
- Field (updatedAt)
Untitled (address)
- Key (id) — 기본 키 — NOT NULL
- Key (userId) — 외래 키 → Untitled.Key — NOT NULL
- Field (recipient)
- Field (shippingAddress)
- Field (zipcode)
- Field (adadress1)
- Field (address2)
- Field (phoneNumber)
- Field (createdAt)
- Field (updatedAt)
Untitled (product)
- Key (id) — 기본 키 — NOT NULL
- Field (productName)
- Field (price)
- Field (category)
- Field (content)
- Field (imagePath)
- Field (exposure)
- Field (createdAt)
- Field (updatedAt)
Untitled (stock)
- Key (id) — 기본 키 — NOT NULL
- Key (productId) — 외래 키 → Untitled.Key — NOT NULL
- Field (size)
- Field (quantity)
- Field (createdAt)
- Field (updatedAt)
Untitled (product_image)
- Key (id) — 기본 키 — NOT NULL
- Key (productId) — 외래 키 → Untitled.Key — NOT NULL
- Field (imagePath)
- Field (createdAt)
Untitled (order)
- Key (id) — 기본 키 — NOT NULL
- Key (userId) — 외래 키 → Untitled.Key — NOT NULL
- Field (orderNumber)
- Field (recipient)
- Field (zipcode)
- Field (address1)
- Field (address2)
- Field (phoneNumber)
- Field (createdAt)
- Field (updatedAt)
Untitled (order_item)
- Key (id) — 기본 키 — NOT NULL
- Key (orderId) — 외래 키 → Untitled.Key — NOT NULL
- Key (stockId) — 외래 키 → Untitled.Key — NOT NULL
- Field (productId)
- Field (count)
- Field (totalPrice)
- Field (state)
- Field (createdAt)
- Field (updatedAt)
Untitled (cart)
- Key (id) — 기본 키 — NOT NULL
- Key (userId) — 외래 키 → Untitled.Key — NOT NULL
- Key (stockId) — 외래 키 → Untitled.Key — NOT NULL
- Field (productId)
- Field (count)
- Field (createdAt)
- Field (updatedAt)
Untitled (review)
- Key (orderItemId) — 외래 키 → Untitled.Key — NOT NULL
- Key (userId) — 외래 키 → Untitled.Key — NOT NULL
- Field (userName)
- Field (productId)
- Field (point)
- Field (content)
- Field (createdAt)
- Field (updatedAt)
Untitled (qna)
- Key (id) — 기본 키 — NOT NULL
- Key (userId) — 외래 키 → Untitled.Key — NOT NULL
- Field (userName)
- Field (subject)
- Field (content)
- Field (secret)
- Field (createdAt)
- Field (updatedAt)
- Field (reply)
Untitled (notice)
- Key (id) — 기본 키 — NOT NULL
- Field (subject)
- Field (content)
- Field (createdAt)
- Field (updatedAt)