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