team2

Tables (8)

favorites (찜목록)

  • fav_idx (찜목록_번호) — INT — Primary key — NOT NULL
  • user_idx (유저_번호) — INT — Foreign key → user_info.user_idx — NOT NULL
  • id (와인_아이디) — INT — Foreign key → wine_info.id — NOT NULL

files (Untitled)

  • file_idx (파일_번호) — INT — Primary key — NOT NULL
  • rev_idx (리뷰_번호) — INT — Foreign key → reviews.rev_idx — NOT NULL
  • inq_idx (문의_번호) — INT — Foreign key → inquiries.inq_idx — NOT NULL
  • ofile (원본파일명) — VARCHAR(255)
  • sfile (저장파일명) — VARCHAR(255)

inquiries (문의사항)

  • inq_idx (문의_번호) — INT — Primary key — NOT NULL
  • user_id (유저_아이디) — VARCHAR(50)
  • inq_title (문의_문의제목) — VARCHAR(100)
  • inq_content (문의_문의내용) — TEXT
  • inq_comments (문의_문의답변) — VARCHAR(255)
  • inq_createDate (문의_등록날짜) — DATETIME

order_history (구매_내역)

  • his_idx (주문내역_번호) — INT — Primary key — NOT NULL
  • user_idx (유저_번호) — INT — Foreign key → user_info.user_idx — NOT NULL
  • id (와인_아이디) — INT — Foreign key → wine_info.id — NOT NULL

reviews (와인_리뷰)

  • rev_idx (리뷰_번호) — INT — Primary key — NOT NULL
  • id (와인_아이디) — INT — Foreign key → wine_info.id — NOT NULL
  • user_idx (유저_번호) — INT — Foreign key → user_info.user_idx — NOT NULL
  • rev_title (리뷰_제목) — VARCHAR(100)
  • rev_content (리뷰_내용) — TEXT
  • rev_cnt (리뷰_조회수) — INT
  • rev_rating (리뷰_별점) — INT

shopping_cart (장바구니)

  • cart_idx (장바구니_번호) — INT — Primary key — NOT NULL
  • user_idx (유저_번호) — INT — Foreign key → user_info.user_idx — NOT NULL
  • id (와인_아이디) — INT — Foreign key → wine_info.id — NOT NULL
  • cart_quantity (장바구니_와인수량) — INT

user_info (회원_정보)

  • user_idx (유저_번호) — INT — Primary key — NOT NULL
  • user_id (유저_아이디) — VARCHAR(50)
  • user_password (유저_비밀번호) — VARCHAR(50)
  • user_name (유저_이름) — VARCHAR(50)
  • user_email (유저_이메일) — VARCHAR(100)
  • user_call (유저_전화번호) — VARCHAR(20)
  • preferred_wine1 (유저_선호와인1) — ENUM('RED', 'White', 'Sparkling', 'Rose', 'Fortified')
  • preferred_wine2 (유저_선호와인2) — ENUM('RED', 'White', 'Sparkling', 'Rose', 'Fortified')
  • preferred_wine3 (유저_선호와인3) — ENUM('RED', 'White', 'Sparkling', 'Rose', 'Fortified')
  • user_level (유저_구독등급) — ENUM('Admin', 'Regular', 'Bronze', 'Silver', 'Gold', 'VIP') — Admin: 관리자 Regular: 일반등급 Bronze: 브론즈등급(3% 할인, 와인 2병 배송) Silver: 실버등급(5% 할인, 와인 2병 배송) Gold: 골드등급(7% 할인, 와인 2병 배송) VIP:…
  • user_address (유저_주소) — VARCHAR(255)
  • user_deleted_yn (유저_탈퇴여부) — ENUM('Y', 'N')

wine_info (와인정보)

  • id (와인_아이디) — INT — Primary key — NOT NULL
  • name (와인_와인명) — VARCHAR(255)
  • producer (와인_생산자) — VARCHAR(255)
  • nation (와인_나라) — VARCHAR(255)
  • local1 (와인_지역1) — VARCHAR(255)
  • local2 (와인_지역2) — VARCHAR(255)
  • varieties1 (와인_품종1) — VARCHAR(255)
  • varieties2 (와인_품종2) — VARCHAR(255)
  • varieties3 (와인_품종3) — VARCHAR(255)
  • wine_type (와인_타입) — VARCHAR(50)
  • wine_use (와인_용도) — VARCHAR(50)
  • abv (와인_도수) — DECIMAL(4,2)
  • degree (와인_음용온도) — VARCHAR(50)
  • sweet (와인_당도) — VARCHAR(50)
  • acidity (와인_산도) — VARCHAR(50)
  • body (와인_바디) — VARCHAR(50)
  • tannin (와인_탄닌) — VARCHAR(50)
  • price (와인_가격) — INT
  • year (와인_년도) — INT
  • ml (와인_용량) — INT
  • img (와인_이미지) — VARCHAR(350)
  • sales_rate (와인_판매량) — INT