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