shoppingmall
Tables (8)
Address (주소)
- addressId (주소ID) — bitint — Primary key — NOT NULL
- userId (회원iD) — varchar(50) — Foreign key → Users.userId — NOT NULL
- addressName (주소명) — varchar(255)
- createdAt (등록일자) — datetime
Category (카테고리)
- categoryId (카테고리ID) — bitint — Primary key — NOT NULL
- productId (상품ID) — bigint — Foreign key → Product.productId — NOT NULL
- categoryInfoId (카테고리정보ID) — bigint — Foreign key → CategoryInfo.categoryInfoId — NOT NULL
- createdAt (생성일자) — datetime
CategoryInfo (카테고리정보)
- categoryInfoId (카테고리정보ID) — bitint — Primary key — NOT NULL
- categoryName (카테고리명) — varchar(255)
OrderItem (주문항목)
- orderItemId (주문항목ID) — bitint — Primary key — NOT NULL
- orderId (주문ID) — bigint — Foreign key → Orders.orderId — NOT NULL
- productId (상품ID) — bigint — Foreign key → Product.productId — NOT NULL
- price (상품가격) — int
- quantity (수량) — int
- totalPrice (총결제금액) — int
Orders (주문)
- orderId (주문ID) — bitint — Primary key — NOT NULL
- userId (회원ID) — varchar(50) — Foreign key → Users.userId — NOT NULL
- orderStatus (주문상태) — varchar(20)
- totalPrice (총결제금액) — int
- address (배송주소) — varchar(255)
- orderDate (주문일) — datetime
Point (포인트내역)
- pointId (포인트ID) — bitint — Primary key — NOT NULL
- userId (회원ID) — bigint — Foreign key → Users.userId — NOT NULL
- price (값) — int
- state (상태) — varchar(10)
- createdAt (생성일자) — datetime
Product (상품)
- productId (상품ID) — bitint — Primary key — NOT NULL
- productName (상품명) — varchar(255)
- prodcutThumbnailImg (썸네일이미지) — varchar(255)
- productImg (상품이미지) — varchar(255)
- price (가격) — int
- quantity (재고) — int
- createdAt (생성일자) — datetime
Users (회원)
- userId (회원ID) — varchar(50) — Primary key — NOT NULL
- userName (이름) — varchar(50)
- userPassword (비밀번호) — varchar(200)
- userBirth (생일) — varchar(8)
- userAuth (권한) — varchar(10)
- userPoint (총포인트) — int
- createdAt (생성일자) — datetime
- latestLoginAt (최근로그인일자) — datetime