home
Tables (3)
Product (Untitled)
- product_number (상품번호) — INT — Primary key — NOT NULL
- category_code (카테고리) — VARCHAR(30)
- product_name (상품명) — VARCHAR(50)
- product_price (가격) — INT
- product_stock (수량(재고)) — INT
- product_desc (설명) — TEXT
- product_date (등록날짜) — DATETIME
- product_hits (조회수) — INT
Product_imageFile (Untitled3)
- file_number (상품이미지파일번호) — INT — Primary key — NOT NULL
- product_number (상품번호) — INT
- orgin_file_name (원본파일이름) — VARCHAR(300)
- stored_file_name (Field)
Product_reply (Untitled2)
- reply_number (댓글번호) — INT — Primary key — NOT NULL
- product_number (상품번호) — INT — Foreign key → Product.product_number — NOT NULL
- content (내용) — TEXT
- writer_nickname (작성자닉네임) — VARCHAR(50)
- reporting_date (작성날짜) — DATETIME
- reply_origin_number (부모댓글번호) — INT
- reply_order (답글순서) — INT
- reply_depth (답글깊이) — INT