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