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