desksetup
Tables (20)
Answer (상품문의 답변)
- answer_id (답변아이디) — Primary key — NOT NULL
- quesetion_id (게시판아이디) — Foreign key → Question.question_id — NOT NULL
- answer_content (댓글내용) — VARCHAR(100)
- answer_date (작성일) — date
Aunswer (상품문의답변)
- answer (상품문의답변아이디) — Primary key — NOT NULL
- customer_question (고객상품문의아이디) — Foreign key → Customer_Question.customer_question — NOT NULL
- store_question (판매자상품문의아이디) — Foreign key → Store_Question.store_question — NOT NULL
- answer_content (답변본문) — text
- answer_date (작성일) — text
Cart (장바구니)
- cart_id (장바구니아이디) — Primary key — NOT NULL
- created_at (생성일)
- updated_at (수정일)
- user_id (유저아이디) — Foreign key → User.user_id — NOT NULL
CartItem (장바구니 상품)
- Key — Primary key — NOT NULL
- cart_id (장바구니아이디) — Foreign key → Cart.cart_id — NOT NULL
- item (상품아이디) — Foreign key → Product.product_id — NOT NULL
- quantity (수량) — integer
Category (카테고리)
- category_id (카테고리아이디) — Primary key — NOT NULL
- category_name (카테고리이름) — VARCHAR(50)
Community (커뮤니티)
- community_id (커뮤니티아이디) — Primary key — NOT NULL
- customer_id (고객아이디) — Foreign key → Customer.customer_id — NOT NULL
- product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
- selected_products (상품링크)
- Community_cat_id (카테고리아이디) — Foreign key → CommunityCategory.Community_cat_id — NOT NULL
- community_title (커뮤니티제목) — VARCHAR(30)
- community_content (커뮤니티본문) — text
- community_img (커뮤니티이미지) — image
- community_like (좋아요)
- like_by (좋아요 누른 회원)
- community_shotform (숏폼)
- community_date (작성일) — date
CommunityCategory (커뮤니티 카테고리)
- Community_cat_id (카테고리아이디) — Primary key — NOT NULL
- community_cat_name (카테고리이름) — VARCHAR(50)
CommunityComment (커뮤니티댓글)
- CommunityComment_id (커뮤니티댓글아이디) — Primary key — NOT NULL
- community_id (커뮤니티아이디) — Foreign key → Community.community_id — NOT NULL
- customer_id (고객아이디) — Foreign key → Customer.customer_id — NOT NULL
- CommunityComment_content (댓글내용) — VARCHAR(100)
- CommunityComment_like (좋아요)
- like_by (좋아요 누른 회원)
- CommunityComment_date (작성일) — date
Customer (구매자)
- customer_id (고객아이디) — Primary key — NOT NULL
- user_id (유저아이디) — Foreign key → User.user_id — NOT NULL
- follow_id (팔로우아이디) — Foreign key → Follow.follow_id — NOT NULL
- cus_nickname (닉네임) — VARCHAR(20)
- cus_name (이름) — VARCHAR(20)
- cus_img (프로필이미지) — image
- cus_height (키) — integer
- cus_weight (몸무게) — integer
- cus_job (직업) — VARCHAR(20)
- cus_address (주소) — VARCHAR(20)
- cus_zipcode (우편번호) — VARCHAR(20)
- cus_birth (생일) — date
- cus_telnum (전화번호) — VARCHAR(20)
- cus_regdate (가입일) — date
Customer_Question (고객_고객센터)
- customer_question (고객상품문의아이디) — Primary key — NOT NULL
- customer_id (고객아이디) — Foreign key → Customer.customer_id — NOT NULL
- question_title (상품문의제목) — VARCHAR(30)
- question_content (상품문의본문) — text
- question_date (작성일) — date
Follow (팔로우)
- follow_id (팔로우아이디) — Primary key — NOT NULL
Order (주문)
- order_id (주문아이디) — Primary key — NOT NULL
- customer_id (고객아이디) — Foreign key → Customer.customer_id — NOT NULL
- product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
- amount (수량) — integer
- price (가격) — integer
- address (주소) — VARCHAR(100)
Payment (결제)
- payment (결제아이디) — Primary key — NOT NULL
- order_id (주문아이디) — Foreign key → Order.order_id — NOT NULL
- name (이름) — VARCHAR(255)
- amount (주문수량) — integer
- status (주문상태) — VARCHAR(100)
- is_paid (Field) — boolean
- created_at (주문일자) — date
Product (상품)
- product_id (상품아이디) — Primary key — NOT NULL
- category_id (카테고리아이디) — Foreign key → Category.category_id — NOT NULL
- store_id (판매자아이디) — Foreign key → Store.store_id — NOT NULL
- product_name (상품이름) — VARCHAR(30)
- product_description (상품설명) — text
- product_price (상품가격) — integer
- product_date (등록일) — date
- product_inventory (재고) — integer
- product_img (상품이미지) — image
- product_sale (할인율) — integer
- is_active (활성화상태)
Question (상품문의)
- question_id (게시판아이디) — Primary key — NOT NULL
- customer_id (고객아이디) — Foreign key → Customer.customer_id — NOT NULL
- product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
- question_title (게시글제목) — VARCHAR(30)
- question_content (게시글본문) — text
- question_date (작성일) — date
Review (상품후기)
- review_id (리뷰아이디) — Primary key — NOT NULL
- product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
- customer_id (고객아이디) — Foreign key → Customer.customer_id — NOT NULL
- image (이미지)
- rate (별점)
- content (본문) — VARCHAR(500)
- review_date (작성일) — date
Store (판매자)
- store_id (판매자아이디) — Primary key — NOT NULL
- user_id (유저아이디) — Foreign key → User.user_id — NOT NULL
- store_name (스토어이름) — VARCHAR(20)
- store_img (로고이미지) — image
- store_num (사업자번호) — VARCHAR(20)
- store_address (주소) — VARCHAR(200)
- store_zipcode (우편번호) — VARCHAR(10)
- store_telnum (전화번호) — VARCHAR(20)
- store_regdate (가입일) — date
Store_Question (판매자_고객센터)
- store_question (판매자상품문의아이디) — Primary key — NOT NULL
- store_id (판매자아이디) — Foreign key → Store.store_id — NOT NULL
- question_title (상품문의제목) — VARCHAR(30)
- question_content (상품문의본문) — text
- question_date (작성일) — date
User
- user_id (유저아이디) — Primary key — NOT NULL
- email (이메일)
- is_customer (구매자 계정인지)
- is_store (판매자 계정인지)
- deactivetime (비활성화한 시간) — integer
UserFavoriteStore (스토어찜)
- userfavoritestore_id (스토어찜아이디) — Primary key — NOT NULL
- store_id (판매자아이디) — Foreign key → Store.store_id — NOT NULL
- customer_id (고객아이디) — Foreign key → Customer.customer_id — NOT NULL
- created_at (작성일) — date