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