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