Online-mall
Tables (7)
Copy Of Untitled (주문상세 OrderDetail)
- Key (id) — Primary key — NOT NULL
- Field2 (quantity)
- Field6 — (Order과 매핑되서 중간테이블 생성)
- Key (id_ORDERS) — Foreign key → Untitled.Key — NOT NULL
- product_id (id_PRODUCT) — Foreign key → product.product_id — NOT NULL
Untitled (loginHistory)
- Key (id) — Primary key — NOT NULL
- Field (userId)
- Field2 (lastLoginTime)
- Field3 (ClientIp)
- Field4 (userAgent)
Untitled (주문 Orders)
- Key (id) — Primary key — NOT NULL
- Key (id_CART) — Long — Foreign key → Untitled2.Key — 없어도 주문 가능
- Field3 (totalPrice) — 총 주문 금액
- Field4 (orderDate) — 주문일
- Field5 (recipientName)
- Field6 (recipientPhone)
- Field3 (recipientZipcode) — 수령인
- Field7 (recipientAddress)
- Field4 (recipientAddeDetail)
- Field
- Field (id_MEMBER) — Foreign key → member.Field — NOT NULL
Untitled2 (장바구니 Cart)
- Key (id) — Long — Primary key — NOT NULL
- Field (product)
- Field2 (member)
- Field (quantity)
coupon (쿠폰 Coupon)
- Key (id) — Primary key — NOT NULL
- Field (member)
- Field2 (couponType)
- Field (couponRegDt) — 등록일
- Field2 (couponExpirationDt)
member (회원 Member)
- Field (id) — Primary key — NOT NULL
- Field3 (userId)
- Field (userName)
- Field2 (phone) — varchar(25) — NOT NULL
- Field (password) — NOT NULL
- Field (point) — INT
- Field (zipcode)
- Field (addr) — NOT NULL
- Field10 (addrDetail)
- Field2 (user_grade) — NOT NULL — lv1, 2, 3, 4, 5 - 누적 구매액
- Field2 (user_register_date) — NOT NULL
- Field5 (reg_dt)
- Field6 (adminYN)
- Field7 (userStatus)
- Field (lastLoginTime)
- Field3 (emailAuthYn)
- Field5 (emailAuthDt)
- Field6 (emailAuthKey)
- Field7 (resetPasswordKey)
- Field9 (resetPasswordLimitDt)
- Field
- Field2
- Key (couponId) — Foreign key → coupon.Key — NOT NULL
- Key (id2) — Long — Foreign key → Untitled2.Key — NOT NULL
product (Product 상품)
- product_id (id) — Primary key — NOT NULL
- Field2 (productName) — 상품명
- Field (price) — 상품 가격
- Field3 (soldOutYN) — BOOLEAN — NOT NULL — 품절 여부
- Field4 (productImg) — 상품 사진
- Field5 (category)
- Field (productQuantity)
- Field2 (stockedDt)
- Field
- Key (id2) — Long — Foreign key → Untitled2.Key — NOT NULL