ourhome
Tables (4)
cart (장바구니)
- cart_id (장바구니ID) — int — Primary key — NOT NULL
- user_id (사용자ID) — varchar(20) — Foreign key → user.user_id — NOT NULL
- goods_id (상품ID) — int — Foreign key → goods.goods_id — NOT NULL
- goods_name (상품명) — varchar(200)
- goods_quantity (수량) — int
- goods_price (판매가) — int
- goods_discount_per (할인율) — int
- goods_discounted_price (할인가) — int
goods (상품)
- goods_id (상품ID) — int — Primary key — NOT NULL
- goods_name (상품명) — varchar(200)
- goods_explanation (상품 설명) — varchar(500)
- goods_price (판매가) — int
- goods_storage (보관법) — varchar(50)
- goods_discount_per (할인율) — int
- goods_discounted_price (할인가) — int
goods_image (상품 이미지)
- goods_image_id (상품이미지 ID) — int — Primary key — NOT NULL
- goods_id (상품ID) — int — Foreign key → goods.goods_id — NOT NULL
- goods_filename (이미지 파일명)
user (사용자)
- user_id (사용자ID) — varchar(20) — Primary key — NOT NULL