ShopProejct

Tables (4)

customer

  • pk — INT — Primary key
  • account_code (계정 코드) — VARCHAR(255) — NOT NULL
  • customer_id (아이디) — VARCHAR(255) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • user_name (이름) — VARCHAR(255) — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • phone_number (전화번호) — VARCHAR(255)
  • address (주소) — VARCHAR(255)
  • city (도시) — VARCHAR(255)
  • state (주/도) — VARCHAR(255)
  • country (국가) — VARCHAR(255)
  • zip_code (우편번호) — VARCHAR(10)
  • status (상태) — VARCHAR(50)
  • remarks (메모) — TEXT
  • signup_date (가입일시) — DATETIME
  • last_login_date (최종로그인일시) — DATETIME
  • status_changed_date (상태변경일시) — DATETIME

order

  • pk — INT — Primary key
  • customer_pk (사용자 pk) — INT — Foreign key → customer.pk
  • product_id (상품ID) — INT
  • order_number (주문 번호) — VARCHAR(50) — NOT NULL
  • order_date (주문 일자) — DATETIME — NOT NULL
  • status (주문 상태) — VARCHAR(50)
  • payment_method (결제 수단) — VARCHAR(50)
  • name (수령인) — VARCHAR(255)
  • zip_code (우편번호) — VARCHAR(255)
  • address (주소) — VARCHAR(255)
  • phone (전화번호) — VARCHAR(20)
  • quantity (수량) — INT
  • total_price (총가격) — DECIMAL(10,2)
  • remarks (메모) — TEXT

product

  • pk — INT — Primary key
  • name (상품명) — VARCHAR(255) — NOT NULL
  • image_url (이미지 URL) — VARCHAR(255)
  • stock_quantity (상품개수) — INT
  • category (카테고리) — VARCHAR(255)
  • price (가격) — DECIMAL(10,2)
  • shipping (배송비) — DECIMAL(10,2)

product_detail

  • pk — INT — Primary key
  • product_pk (상품 pk) — INT — Foreign key → product.pk
  • description (설명) — TEXT
  • registered_date (등록일) — DATETIME
  • soldout (품절여부) — TINYINT(1)
  • view_count (조회수) — INT