gamza_shop

Tables (9)

address (주소)

  • adrdess_id (주소 ID) — BIGINT — Primary key — NOT NULL
  • default_address (기본 주소) — VARCHER(255)
  • detail_address (상세주소) — TEXT
  • postal_code (우편 번호) — VARCHER(5)
  • user_id (사용자 ID) — BIGINT — Foreign key → user.user_id — NOT NULL

category (카테고리)

  • category_id (카테고리 ID) — BIGINT — Primary key — NOT NULL
  • name (카테고리 이름) — VARCHER(20)

image (이미지)

  • image_id (이미지 ID) — BIGINT — Primary key — NOT NULL
  • upload_file_name (업로드 파일명) — VARCHER(255)
  • store_file_name (저장된 파일명) — VARCHER(255)

order (주문)

  • order_id (주문 ID) — BIGINT — Primary key — NOT NULL
  • user_id (주문자 ID) — BIGINT — Foreign key → user.user_id — NOT NULL
  • adrdess_id (주소 ID) — BIGINT — Foreign key → address.adrdess_id — NOT NULL
  • order_status (주문 상태) — VARCHER(20)
  • total_price (총 가격) — INT

order_item (주문 상품)

  • order_item_id (주문 상품 ID) — BIGINT — Primary key — NOT NULL
  • product_id (상품 ID2) — BIGINT — Foreign key → product.product_id — NOT NULL
  • order_id (주문 ID) — BIGINT — Foreign key → order.order_id — NOT NULL
  • quantity (수량) — INT

product (상품)

  • product_id (상품 ID) — BIGINT — Primary key — NOT NULL
  • name (상품명) — VARCHAR(20)
  • price (상품가격) — INT
  • description (상품 설명) — TEXT
  • selling_type (상품 판매 타입) — VARCHER(20)
  • stock (재고량) — INT
  • category_id (카테고리 ID) — BIGINT — Foreign key → category.category_id — NOT NULL
  • cover_image_id (대표 이미지 ID) — BIGINT — Foreign key → image.image_id — NOT NULL

product_image (상품 이미지)

  • product_image_id (상품 이미지 ID) — BIGINT — Primary key — NOT NULL
  • product_id (상품 ID) — BIGINT — Foreign key → product.product_id — NOT NULL
  • image_id (이미지 ID) — BIGINT — Foreign key → image.image_id — NOT NULL

stock (재고)

  • stock_id (재고 ID) — BIGINT — Primary key — NOT NULL
  • stock (재고) — INT

user (사용자)

  • user_id (사용자 ID) — BIGINT — Primary key — NOT NULL
  • login_id (아이디) — VARCHER(20)
  • password (비밀번호) — VARCHER(20)
  • name (이름) — VARCHER(20)
  • phone_number (전화번호) — INTEGER(11)
  • type (유저 타입) — VARCHER(10)