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)