kt-cloud-team-project1

Tables (9)

Cart (장바구니)

  • cartId (Key) — number — Primary key — NOT NULL
  • memberId (Key2) — number — Foreign key → Member.memberId — NOT NULL
  • categoryId (Field) — number
  • categoryName (Field2) — String
  • productId (Field3) — number
  • productName (Field4) — String
  • price (Field5) — number
  • quantity (Field6) — number
  • optionCheck (Field7) — String
  • optionId (Field8) — number
  • optionName (Field9) — String
  • optionPrice (Field10) — number
  • totalPrice (Field11) — number
  • createdAt (Field13) — DateTime
  • modifiedAt (Field14) — DateTime

Category (카테고리)

  • categoryId (Key) — number — Primary key — NOT NULL
  • categoryName (Field) — Sring
  • createdAt (Field2) — DateTime
  • modifiedAt (Field3) — DateTime

Media (미디어 정보)

  • mediaId (Key) — number — Primary key — NOT NULL
  • mediaUrl (Field) — String
  • mediaUploadUrl (Field2) — String
  • mediaTitle (Field3) — String
  • mediaUuidTitle (Field4) — String
  • contentType (Field5) — String
  • contentMappingId (Field6) — number
  • createdAt (Field7) — DateTime
  • modifiedAt (Field8) — DateTime

Member (회원)

  • memberId (Key) — number — Primary key — NOT NULL
  • email (Field) — String
  • password (Field2) — String
  • phone (Field3) — String
  • createdAt (Field4) — DateTime
  • modifiedAt (Field5) — DateTime

Order (주문 이력)

  • orderId (Key) — number — Primary key — NOT NULL
  • memberId (Key2) — number — Foreign key → Member.memberId — NOT NULL
  • orderNumber (Field) — String
  • name (Field2) — String
  • cartOrderCheck (Field3) — String
  • cartId (Field4) — number
  • categoryId (Field5) — number
  • productId (Field6) — number
  • productName (Field7) — String
  • price (Field8) — number
  • quantity (Field9) — number
  • optionCheck (Field10) — String
  • optionId (Field11) — number
  • optionName (Field12) — String
  • optionPrice (Field13) — number
  • totalPrice (Field14) — number
  • deliveryAddress (Field15) — String
  • paymentId (Field17) — number
  • createdAt (Field18) — DateTime
  • modifiedAt (Field19) — DateTime

Payment (결제 수단)

  • paymentId (Key) — number — Primary key — NOT NULL
  • memberId (Key2) — number — Foreign key → Member.memberId — NOT NULL
  • cardHolderName (Field) — String
  • cardNumber (Field2) — String
  • expiry (Field3) — String
  • cvv (Field4) — String
  • bank (Field5) — String
  • createdAt (Field7) — DateTime
  • modifiedAt (Field8) — DateTime

Product (제품)

  • productId (Key) — number — Primary key — NOT NULL
  • categoryId (Key2) — number — Foreign key → Category.categoryId — NOT NULL
  • productName (Field) — String
  • price (Field2) — number
  • thumbImage (Field3) — String
  • description (Field4) — String
  • discountPrice (Field5) — number
  • discountStartDate (Field6) — DateTime
  • discountEndDate (Field7) — DateTime
  • optionExistCheck (Field8) — String
  • createdAt (Field10) — DateTime
  • modifiedAt (Field11) — DateTime

ProductOption (제품 옵션)

  • productOptionId (Key) — number — Primary key — NOT NULL
  • productId (Key2) — number — Foreign key → Product.productId — NOT NULL
  • categoryId (Key22) — number — Foreign key → Product.categoryId — NOT NULL
  • optionName (Field) — String
  • price (Field2) — number
  • createdAt (Field4) — DateTime
  • modifiedAt (Field5) — DateTime

Review (리뷰)

  • reviewId (Key) — number — Primary key — NOT NULL
  • productId (Key2) — number — Foreign key → Product.productId — NOT NULL
  • categoryId (Key22) — number — Foreign key → Product.categoryId — NOT NULL
  • name (Field) — String
  • reviewTitle (Field2) — String
  • reviceContent (Field3) — String
  • memberId (Field4) — number