LONUA
Tables (20)
Answer
- answerIdx — INT — Primary key — NOT NULL
- answerContent — VARCHAR(500) — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- updatedAt — VARCHAR(255) — NOT NULL
- Question_idx — INT — Foreign key → Question.questionIdx
- Seller_idx — INT — Foreign key → Seller.sellerIdx
- INDEX — `FKkeo3tp3sj4qqhuro13cnwv11x`
- INDEX — `FKg1uqeprmkumiocoqfljo2q2j5`
Branch
- branchIdx — INT — Primary key — NOT NULL
- branchAddress — VARCHAR(100)
- branchName — VARCHAR(30)
- Brand_idx — INT — Foreign key → Brand.brandIdx
- INDEX — `FKtnn3wlycc2cy5j4rxa7gv74bi`
Brand
- brandIdx — INT — Primary key — NOT NULL
- bankAccountNumber — VARCHAR(45) — NOT NULL
- brandImage — VARCHAR(200) — NOT NULL
- brandIntroduction — VARCHAR(500) — NOT NULL
- brandName — VARCHAR(45) — NOT NULL
- brandStyle — VARCHAR(10) — NOT NULL
- brandUniqueKey — VARCHAR(45) — NOT NULL
- businessAddress — VARCHAR(200) — NOT NULL
- businessRegistration — VARCHAR(10) — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- phoneNumber — VARCHAR(20) — NOT NULL
- returnAddress — VARCHAR(200) — NOT NULL
- returnCost — INT — NOT NULL
- returnCourier — VARCHAR(45) — NOT NULL
- status — BIT(1) — NOT NULL
- updatedAt — VARCHAR(255) — NOT NULL
Cart
- cartIdx — INT — Primary key — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- status — BIT(1) — NOT NULL
- updatedAt — VARCHAR(255) — NOT NULL
- Product_idx — INT — Foreign key → Product.productIdx
- User_idx — INT — Foreign key → User.회원IDX
- INDEX — `FKpogyyegw24ppobcvs41xrk714`
- INDEX — `FKgx3aftoes5r8y032qkhvd44v4`
Category
- categoryIdx — INT — Primary key — NOT NULL
- categoryName — VARCHAR(45) — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- status — BIT(1) — NOT NULL
- updatedAt — VARCHAR(255) — NOT NULL
Coupon
- couponIdx — INT — Primary key — NOT NULL
- couponDiscountRate — INT — NOT NULL
- couponExpirationDate — VARCHAR(255) — NOT NULL
- couponName — VARCHAR(45) — NOT NULL
- receivedDate — VARCHAR(255) — NOT NULL
- status — BIT(1) — NOT NULL
- User_idx — INT — Foreign key → User.회원IDX
- INDEX — `FK7n6fbi4m3usjrranpj40n2wyn`
EmailVerify
- idx — INT — Primary key — NOT NULL
- email — VARCHAR(255)
- uuid — VARCHAR(255)
Grade (회원 등급)
- gradeIdx (회원등급IDX) — INTEGER — Primary key — NOT NULL
- discountRate (할인율) — INTEGER — NOT NULL
- gradeType (회원등급) — INTEGER — NOT NULL
Likes
- likesIdx — INT — Primary key — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- status — BIT(1) — NOT NULL
- updatedAt — VARCHAR(255) — NOT NULL
- Product_idx — INT — Foreign key → Product.productIdx
- User_idx — INT — Foreign key → User.회원IDX
- INDEX — `FKd7e1kkddsiowj9l0gdsaj3qhf`
- INDEX — `FK48ek67bsjmammw269pt81vhp`
Orders
- ordersIdx — INT — Primary key — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- impUid — VARCHAR(50) — NOT NULL
- status — VARCHAR(10) — NOT NULL
- updatedAt — VARCHAR(255) — NOT NULL
- User_idx — INT — Foreign key → User.회원IDX
- INDEX — `FKswravrrbol9o5svqrknrjgi39`
OrdersProduct
- ordersProductIdx — INT — Primary key — NOT NULL
- Orders_idx — INT — Foreign key → Orders.ordersIdx
- Product_idx — INT — Foreign key → Product.productIdx
- INDEX — `FKlc4i0ukpdu5o25es38uqdkqq1`
- INDEX — `FKddudsrn810gbgtncua3yqy9ts`
Product
- productIdx — INT — Primary key — NOT NULL
- armLength — FLOAT
- chestSize — FLOAT
- createdAt — VARCHAR(255)
- crotchLength — FLOAT
- hemLength — FLOAT
- hipCircumference — FLOAT
- price — INT — NOT NULL
- productName — VARCHAR(100) — NOT NULL
- quantity — INT — NOT NULL
- salePrice — INT — NOT NULL
- shoulderWidth — FLOAT
- status — BIT(1) — NOT NULL
- thighCircumference — FLOAT
- topLength — FLOAT
- totalBottomLength — FLOAT
- updatedAt — VARCHAR(255)
- waistline — FLOAT
- Brand_idx — INT — Foreign key → Brand.brandIdx
- Category_idx — INT — Foreign key → Category.categoryIdx
- Style_idx — INT — Foreign key → Style.styleIdx
- INDEX — `FKc35kwbw1g59uprwv7apsfr467`
- INDEX — `FK6lu1xiirujef0jaxucohbodep`
- INDEX — `FK2gcseeak976q0bjh12esttjv9`
ProductCount
- productCountIdx — INT — Primary key — NOT NULL
- likeCount — INT
- lowerType1Count — INT
- lowerType2Count — INT
- lowerType3Count — INT
- upperType1Count — INT
- upperType2Count — INT
- upperType3Count — INT
- Product_idx — INT — Foreign key → Product.productIdx
- INDEX — `FKiyb17y46gt6xsbji4jd2ypfaf`
ProductImage
- productImageIdx — INT — Primary key — NOT NULL
- productImage — VARCHAR(500) — NOT NULL
- Product_idx — INT — Foreign key → Product.productIdx
- INDEX — `FKasbyt50gvfsa1bmp2w8yvbo08`
ProductIntrodImage
- productIntrodImageIdx — INT — Primary key — NOT NULL
- productIntrodImage — VARCHAR(500) — NOT NULL
- Product_idx — INT — Foreign key → Product.productIdx
- INDEX — `FKni9jdyw9t0mndaqnwbwn8q6m6`
Question
- questionIdx — INT — Primary key — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- hasAnswer — BIT(1) — NOT NULL
- isSecret — BIT(1) — NOT NULL
- questionContent — VARCHAR(500) — NOT NULL
- questionTitle — VARCHAR(45) — NOT NULL
- questionType — VARCHAR(7) — NOT NULL
- updatedAt — VARCHAR(255) — NOT NULL
- Product_idx — INT — Foreign key → Product.productIdx
- User_idx — INT — Foreign key → User.회원IDX
- INDEX — `FKq1yfhi42hplq2d6nm2tpolr3i`
- INDEX — `FKmjj3h4bnquqmbksahh7i91l5b`
Review
- reviewIdx — INT — Primary key — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- evaluation — INT — NOT NULL
- reviewContent — VARCHAR(500) — NOT NULL
- reviewPhoto — VARCHAR(500)
- status — BIT(1) — NOT NULL
- updatedAt — VARCHAR(255) — NOT NULL
- Product_idx — INT — Foreign key → Product.productIdx
- User_idx — INT — Foreign key → User.회원IDX
- INDEX — `FKb3v0l0ht05xawx44906n1bfoc`
- INDEX — `FKe6yyryvkxbubi3s45q9y5dnph`
Seller (판매자)
- sellerIdx (판매자IDX) — INTEGER — Primary key — NOT NULL
- Brand_idx (브랜드IDX) — INTEGER — Foreign key → Brand.brandIdx
- authority (권한) — VARCHAR(20)
- sellerEmail (이메일) — VARCHAR(45) — NOT NULL
- sellerName (이름) — VARCHAR — NOT NULL
- sellerPassword (비밀번호) — INTEGER — NOT NULL
- status (상태) — INTEGER — NOT NULL
- createdAt (생성날짜) — INTEGER — NOT NULL
- updatedAt (수정날짜) — INTEGER
Style
- styleIdx — INT — Primary key — NOT NULL
- styleType — VARCHAR(15) — NOT NULL
User (회원)
- 회원IDX (userIdx) — INTEGER — Primary key — NOT NULL
- 회원등급IDX (Grade_idx) — INTEGER — Foreign key → Grade.gradeIdx — NOT NULL
- 권한 (authority) — INTEGER — NOT NULL
- userEmail (이메일) — INTEGER — NOT NULL
- name (이름) — INTEGER — NOT NULL
- userPassword (비밀번호) — INTEGER — NOT NULL
- userGender (성별) — INTEGER — NOT NULL
- userBirth (생년월일) — INTEGER — NOT NULL
- userAddr (주소) — INTEGER — NOT NULL
- userPhoneNumber (휴대전화번호) — INTEGER — NOT NULL
- userMileage (마일리지) — VARCHAR(7) — NOT NULL
- preferStyle (선호 스타일) — VARCHAR(7)
- upperType (상체 유형) — INTEGER — NOT NULL
- lowerType (하체 유형) — INTEGER — NOT NULL
- status (상태) — INTEGER
- createdAt (생성날짜) — INTEGER — NOT NULL
- updatedAt (수정날짜) — INTEGER — NOT NULL