NHS
Tables (4)
IMAGE (상품이미지)
- product_id (Key) — Foreign key → PRODUCT.product_id — NOT NULL
- image_id (Field)
- origin_name (Field2)
- name (Field3)
- path (Field4)
- ext (Field5)
- thumbnail_yn (Field6)
PRODUCT (상품)
- product_id (Key) — Primary key — NOT NULL
- detail (Field)
- price (Field2)
- stock (Field3)
- title (Field4)
- writer (Field5)
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
PRODUCT_OPTION (상품 옵션)
- option_id (Key) — Primary key — NOT NULL
- product_id (Key2) — Foreign key → PRODUCT.product_id — NOT NULL
- name (Field)
- content (Field2)
USER (사용자)
- user_id (Key) — Primary key — NOT NULL
- login_id (Field)
- login_password (Field2)
- info (Field3)