autoblog
Tables (6)
draft_reviews
- id — BIGINT
- keyword_id — BIGINT
- product_id — BIGINT
- user_id — BIGINT
- title — VARCHAR(255)
- created_at — DATETIME
keywords
- id — BIGINT
- keyword — VARCHAR(255) — NOT NULL
- score — INT
- is_valid — BOOLEAN
- user_id — BIGINT
- created_at — DATETIME
product_images
- id — BIGINT
- product_id — BIGINT
- image_url — TEXT
- is_main — BOOLEAN
- created_at — DATETIME
products
- id — BIGINT
- keyword_id — BIGINT
- product_name — VARCHAR(255)
- price — DECIMAL(10, 2)
- description — TEXT
- product_url — TEXT
- created_at — DATETIME
review_sections
- id — BIGINT
- draft_review_id — BIGINT
- section_order — INT
- heading — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
users
- id — BIGINT
- username — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('ADMIN', 'USER')
- created_at — DATETIME