LONUA-FINAL
Tables (20)
Answer (답변)
- answerIdx (답변IDX) — INTEGER — Primary key — NOT NULL
- Question_idx (질문IDX) — INTEGER — Foreign key → Question.questionIdx
- Seller_idx (판매자IDX) — INTEGER — Foreign key → Seller.sellerIdx
- answerContent (답변내용) — VARCHAR(500) — NOT NULL
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
Branch (지점)
- branchIdx (지점IDX) — INTEGER — Primary key — NOT NULL
- Brand_idx (브랜드IDX) — INTEGER — Foreign key → Brand.brandIdx
- branchName (지점명) — VARCHAR(30)
- branchAddress (지점주소) — VARCHAR(100)
Brand (브랜드)
- brandIdx (브랜드IDX) — INTEGER — Primary key — NOT NULL
- brandName (브랜드명) — VARCHAR(45) — NOT NULL
- brandImage (브랜드이미지) — VARCHAR(200) — NOT NULL
- brandIntroduction (브랜드소개) — VARCHAR(500) — NOT NULL
- brandStyle (브랜드스타일) — VARCHAR(10) — NOT NULL
- phoneNumber (전화번호) — VARCHAR(20) — NOT NULL
- bankAccountNumber (계좌번호) — VARCHAR(45) — NOT NULL
- businessAddress (사업자주소) — VARCHAR(200) — NOT NULL
- businessRegistration (사업자등록번호) — VARCHAR(10) — NOT NULL
- returnAddress (반품주소) — VARCHAR(200) — NOT NULL
- returnCost (반품비용) — INTEGER — NOT NULL
- returnCourier (반품택배사) — VARCHAR(45) — NOT NULL
- brandUniqueKey (브랜드고유키) — VARCHAR(45) — NOT NULL
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
- status (상태) — BOOLEAN — NOT NULL
Cart (장바구니)
- cartIdx (장바구니IDX) — INTEGER — Primary key — NOT NULL
- User_idx (회원IDX) — INTEGER — Foreign key → User.userIdx
- Product_idx (상품IDX) — INTEGER — Foreign key → Product.productIdx
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
- status (상태) — BOOLEAN — NOT NULL
Category (카테고리)
- categoryIdx (카테고리IDX) — INTEGER — Primary key — NOT NULL
- categoryName (카테고리명) — VARCHAR(45) — NOT NULL
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
- status (상태) — BOOLEAN — NOT NULL
Coupon (쿠폰)
- couponIdx (쿠폰IDX) — INTEGER — Primary key — NOT NULL
- User_idx (회원IDX) — INTEGER — Foreign key → User.userIdx
- couponName (쿠폰명) — VARCHAR(45) — NOT NULL
- couponDiscountRate (할인율) — INTEGER — NOT NULL
- receivedDate (받은날짜) — VARCHAR(255) — NOT NULL
- couponExpirationDate (만료기한) — VARCHAR(255) — NOT NULL
- status (상태) — BOOLEAN — NOT NULL
EmailVerify (이메일인증)
- idx (IDX) — INTEGER — Primary key — NOT NULL
- email (이메일) — VARCHAR(255)
- uuid (UUID) — VARCHAR(255)
Grade (회원등급)
- gradeIdx (등급IDX) — INTEGER — Primary key — NOT NULL
- gradeType (등급유형) — VARCHAR(45) — NOT NULL
- discountRate (할인율) — INTEGER — NOT NULL
Likes (찜하기)
- likesIdx (찜하기IDX) — INTEGER — Primary key — NOT NULL
- User_idx (회원IDX) — INTEGER — Foreign key → User.userIdx
- Product_idx (상품IDX) — INTEGER — Foreign key → Product.productIdx
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
- status (상태) — BOOLEAN — NOT NULL
Orders (주문)
- ordersIdx (주문IDX) — INTEGER — Primary key — NOT NULL
- User_idx (회원IDX) — INTEGER — Foreign key → User.userIdx
- impUid (주문번호) — VARCHAR(50) — NOT NULL
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
- status (상태) — VARCHAR(10) — NOT NULL
OrdersProduct (주문상품)
- ordersProductIdx (주문상품IDX) — INTEGER — Primary key — NOT NULL
- Orders_idx (주문IDX) — INTEGER — Foreign key → Orders.ordersIdx
- Product_idx (상품IDX) — INTEGER — Foreign key → Product.productIdx
Product (상품)
- productIdx (상품IDX) — INTEGER — Primary key — NOT NULL
- Brand_idx (브랜드IDX) — INTEGER — Foreign key → Brand.brandIdx
- Category_idx (카테고리IDX) — INTEGER — Foreign key → Category.categoryIdx
- Style_idx (스타일IDX) — INTEGER — Foreign key → Style.styleIdx
- productName (상품명) — VARCHAR(100) — NOT NULL
- quantity (수량) — INTEGER — NOT NULL
- price (가격) — INTEGER — NOT NULL
- salePrice (할인가격) — INTEGER — NOT NULL
- shoulderWidth (어깨너비) — FLOAT
- chestSize (가슴둘레) — FLOAT
- armLength (팔길이) — FLOAT
- topLength (상의총길이) — FLOAT
- waistline (허리둘레) — FLOAT
- hipCircumference (엉덩이둘레) — FLOAT
- thighCircumference (허벅지둘레) — FLOAT
- crotchLength (밑위길이) — FLOAT
- hemLength (밑단길이) — FLOAT
- totalBottomLength (하의총길이) — FLOAT
- createdAt (생성날짜) — VARCHAR(255)
- updatedAt (수정날짜) — VARCHAR(255)
- status (상태) — BOOLEAN — NOT NULL
ProductCount (상품관련수)
- productCountIdx (상품관련수IDX) — INTEGER — Primary key — NOT NULL
- Product_idx (상품IDX) — INTEGER — Foreign key → Product.productIdx
- likeCount (찜하기수) — INTEGER
- lowerType1Count (하체유형1수) — INTEGER
- lowerType2Count (하체유형2수) — INTEGER
- lowerType3Count (하체유형3수) — INTEGER
- upperType1Count (상체유형1수) — INTEGER
- upperType2Count (상체유형2수) — INTEGER
- upperType3Count (상체유형3수) — INTEGER
ProductImage (상품이미지)
- productImageIdx (상품이지미IDX) — INTEGER — Primary key — NOT NULL
- Product_idx (상품IDX) — INTEGER — Foreign key → Product.productIdx
- productImage (상품이미지) — VARCHAR(500) — NOT NULL
ProductIntrodImage (상품소개이미지)
- productIntrodImageIdx (상품소개이미지IDX) — INTEGER — Primary key — NOT NULL
- Product_idx (상품IDX) — INTEGER — Foreign key → Product.productIdx
- productIntrodImage (상품소개이미지) — VARCHAR(500) — NOT NULL
Question (질문)
- questionIdx (질문IDX) — INTEGER — Primary key — NOT NULL
- User_idx (회원IDX) — INTEGER — Foreign key → User.userIdx
- Product_idx (상품IDX) — INTEGER — Foreign key → Product.productIdx
- questionType (질문유형) — VARCHAR(7) — NOT NULL
- questionTitle (질문제목) — VARCHAR(45) — NOT NULL
- questionContent (질문내용) — VARCHAR(500) — NOT NULL
- isSecret (비밀글여부) — BOOLEAN — NOT NULL
- hasAnswer (답변여부) — BOOLEAN — NOT NULL
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
Review (후기)
- reviewIdx (후기IDX) — INTEGER — Primary key — NOT NULL
- User_idx (회원IDX) — INTEGER — Foreign key → User.userIdx
- Product_idx (상품IDX) — INTEGER — Foreign key → Product.productIdx
- reviewContent (후기내용) — VARCHAR(500) — NOT NULL
- reviewPhoto (후기사진) — VARCHAR(500)
- evaluation (별점) — INTEGER — NOT NULL
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
- status (상태) — BOOLEAN — NOT NULL
Seller (판매자)
- sellerIdx (판매자IDX) — INTEGER — Primary key — NOT NULL
- Brand_idx (브랜드IDX) — INTEGER — Foreign key → Brand.brandIdx
- sellerEmail (이메일) — VARCHAR(45) — NOT NULL
- sellerPassword (비밀번호) — VARCHAR(200) — NOT NULL
- sellerName (이름) — VARCHAR(45) — NOT NULL
- authority (권한) — VARCHAR(255) — NOT NULL
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
- status (상태) — BOOLEAN — NOT NULL
Style (스타일)
- styleIdx (스타일IDX) — INTEGER — Primary key — NOT NULL
- styleType (스타일유형) — VARCHAR(15) — NOT NULL
User (회원)
- userIdx (회원IDX) — INTEGER — Primary key — NOT NULL
- Grade_idx (등급IDX) — INTEGER — Foreign key → Grade.gradeIdx
- userEmail (이메일) — VARCHAR(45) — NOT NULL
- userPassword (패스워드) — VARCHAR(200) — NOT NULL
- name (이름) — VARCHAR(45) — NOT NULL
- userBirth (생년월일) — VARCHAR(10) — NOT NULL
- userAddr (주소) — VARCHAR(45) — NOT NULL
- userGender (성별) — VARCHAR(1) — NOT NULL
- userPhoneNumber (휴대전화번호) — VARCHAR(13) — NOT NULL
- userMileage (마일리지) — INTEGER — NOT NULL
- preferStyle (선호스타일) — VARCHAR(7)
- authority (권한) — VARCHAR(255) — NOT NULL
- upperType (상체유형) — INTEGER — NOT NULL
- lowerType (하체유형) — INTEGER — NOT NULL
- createdAt (생성날짜) — VARCHAR(255) — NOT NULL
- updatedAt (수정날짜) — VARCHAR(255) — NOT NULL
- status (상태) — BOOLEAN — NOT NULL