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