ERD-1

테이블 (3)

데이터 (data)

  • id (PK) — INT — 기본 키 — NOT NULL
  • image_url (Field) — VARCHAR(100)
  • ai_predict (Field2) — VARCHAR(100)
  • is_correct (Field6) — TINYINT(1)
  • feadback_text (Field7) — VARCHAR(255)
  • create_at (Field3) — TIMESTAMP
  • update_at (Field4) — TIMESTAMP
  • delete_at (Field5) — TIMESTAMP

상품 (Product)

  • id (PK) — INT — 기본 키 — NOT NULL
  • product_name (Field2) — VARCHAR(100)
  • prodcut_price (Field3) — INT
  • product_stock (Field6) — INT
  • prduct_buy (Field8) — INT
  • image_url (Field7) — VARCHAR(100)
  • create_at (Field4) — TIMESTAMP
  • update_at (Field5) — TIMESTAMP
  • delete_at (Field) — TIMESTAMP

상품상세정보 (ProductDetail)

  • product_name (Field) — VARCHAR(100)
  • prodcut_price (Field2) — INT
  • product_image (Field4) — VARCHAR(100)
  • product_stock (Field3) — INT