togeteat

Tables (8)

Cart (장바구니)

  • cart_id — VARCHAR(20) — Primary key — NOT NULL
  • shop_id — VARCHAR(200) — Foreign key → Shop.shop_id — NOT NULL
  • user_id — INT UNSIGNED — Foreign key → User.userid — NOT NULL
  • product_id — VARCHAR(50) — Foreign key → Shop.product_id — NOT NULL
  • price (가격) — INT UNSIGNED — NOT NULL
  • total_price (총 주문금액) — INT UNSIGNED — NOT NULL
  • photo (사진) — VARCHAR(100)

Order (주문기록)

  • id (order_id) — VARCHAR(100) — Primary key — NOT NULL
  • userid (user_id) — VARCHAR(20) — Foreign key → User.userid — NOT NULL
  • shop_id — VARCHAR(20) — Foreign key → Shop.shop_id — NOT NULL
  • product_id — VARCHAR(50) — Foreign key → Shop.product_id — NOT NULL
  • receive_name (받는 고객) — VARCHAR(30) — NOT NULL
  • receive_address (받는 고객주소) — VARCHAR(100) — NOT NULL
  • receive_tel (받는 고객전화번호) — VARCHAR(11) — NOT NULL
  • order_state (주문상태) — ENUM — NOT NULL
  • delivered_time (배송 완료시간(예상)) — VARCHAR(20) — NOT NULL
  • delivered_state (배송 상태) — ENUM — NOT NULL
  • order_count (주문 횟수) — VARCHAR(100) — NOT NULL

Pay (결제기록)

  • pay_id — VARCHAR(100) — Primary key — NOT NULL
  • userid (user_id) — VARCHAR(20) — Foreign key → User.userid — NOT NULL
  • Field (결제 수단) — ENUM — NOT NULL
  • pay_time (결제 시간) — DATETIME — NOT NULL
  • total_price (총 주문 금액) — INT UNSIGNED — NOT NULL
  • delivered_price (배송비) — INT UNSIGNED — NOT NULL
  • discount_price (할인 금액) — INT UNSIGNED — NOT NULL
  • final_price (최종 금액) — INT UNSIGNED — NOT NULL
  • point (포인트) — INT UNSIGNED — NOT NULL
  • save_point (포인트 적립 내역) — INT UNSIGNED — NOT NULL
  • use_point (포인트 사용 내역) — INT — NOT NULL

Product (상품)

  • product_id — VARCHAR(50) — Primary key — NOT NULL
  • product_name (상품 이름) — VARCHAR(50) — NOT NULL
  • product_content (상품 정보) — VARCHAR(200) — NOT NULL
  • photo (사진) — VARCHAR(100)
  • stock (재고) — SMALLINT UNSIGNED — NOT NULL

Recommend (추천)

  • recommend_id — VARCHAR(100) — Primary key — NOT NULL
  • userid (user_id) — VARCHAR(20) — Foreign key → User.userid — NOT NULL
  • shop_id — VARCHAR(20) — Foreign key → Shop.shop_id — NOT NULL
  • product_id — VARCHAR(50) — Foreign key → Shop.product_id — NOT NULL
  • date (주문날짜) — DATE
  • area (지역) — VARCHAR(50)
  • city (도시) — VARCHAR(50)
  • age (나이) — INT UNSIGNED
  • gender (성별) — ENUM
  • category (카테고리) — ENUM
  • order_count (주문횟수) — VARCHAR(100)

Review (리뷰)

  • review_id — VARCHAR(100) — Primary key — NOT NULL
  • userid (user_id) — VARCHAR(20) — Foreign key → User.userid — NOT NULL
  • title (제목) — VARCHAR(20) — NOT NULL
  • content (내용) — VARCHAR(500) — NOT NULL
  • grade (별점) — ENUM
  • date (날짜) — DATE — NOT NULL
  • photo (사진) — VARCHAR(100)
  • nickname (닉네임) — VARCHAR(20)

Shop (가게)

  • shop_id — VARCHAR(20) — Primary key — NOT NULL
  • product_id — VARCHAR(50) — Foreign key → Product.product_id — NOT NULL
  • password (비밀번호) — CHAR(60) — NOT NULL
  • name (가게 이름) — VARCHAR(30) — NOT NULL
  • address (주소) — VARCHAR()(100) — NOT NULL
  • businessnumber (사업자번호) — VARCHAR(12) — NOT NULL
  • shoptel (가게전화번호) — VARCHAR(13) — NOT NULL
  • category (카테고리) — ENUM — NOT NULL

User (유저)

  • userid (user_id) — VARCHAR(20) — Primary key — NOT NULL
  • name (이름) — VARCHAR(10) — NOT NULL
  • password (비밀번호) — VARCHAR(20) — NOT NULL
  • nickname (닉네임) — VARCHAR(20) — NOT NULL
  • email (이메일) — VARCHAR(30)
  • tel (전화번호) — VARCHAR(11) — NOT NULL
  • address (주소) — VARCHAR(100) — NOT NULL
  • birth (셩년월일) — DATE — NOT NULL
  • gender (성별) — ENUM — NOT NULL
  • category (카테고리) — ENUM