1
Tables (5)
buy_table (Untitled3)
- buy_no (구매번호) — Primary key — NOT NULL
- product_no (상품번호) — Foreign key → product_table.product_no — NOT NULL
- member_no (회원번호) — Foreign key → user_table.member_no — NOT NULL
- date (구매날짜)
- quantity (구매수량)
- seal_service (각인여부)
- total_price (총구매)
- method (구매방식)
category_table (Untitled4)
- category_no (카테고리번호) — Primary key — NOT NULL
- name (이름)
- delete (삭제)
image_table (Untitled5)
- image_no (이미지번호) — Primary key — NOT NULL
- product_no (상품번호) — Foreign key → product_table.product_no — NOT NULL
- origin_path (원본이미지)
- save_path (암호화 이름)
- save_date (저장날짜)
- update_date (수정날짜)
- delete (삭제)
product_table (Untitled2)
- product_no (상품번호) — Primary key — NOT NULL
- category_no (카테고리번호) — Foreign key → category_table.category_no — NOT NULL
- name (상품이름)
- company (회사명)
- in_price (입고가)
- out_price (판매가)
- sell_count (판매량)
- quantity (재고)
- visit (조회수)
- seal_service (각인서비스)
- delete (삭제)
user_table (Untitled)
- member_no (회원번호) — Primary key — NOT NULL
- id (아이디)
- password (비밀번호)
- name (이름)
- dob (생년월일)
- gender (성별)
- address (주소)
- email (이메일)
- phone (전화번호)
- admin (관리자 여부)
- joinDate (회원가입일)
- delete (삭제)