crony
Tables (7)
Comments
- id — BIGINT
- review_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Product_Images
- id — BIGINT
- product_id — BIGINT — NOT NULL
- storage_path — TEXT — NOT NULL
- image_url — TEXT
- is_thumbnail — BOOLEAN
- created_at — TIMESTAMP
Products
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- average_rating — DECIMAL(3, 1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Replies
- id — BIGINT
- comment_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Reviews
- id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- content — TEXT — NOT NULL
- rating — INT — NOT NULL
- created_at — TIMESTAMP
- id (id2) — BIGINT — Foreign key → Users.id
- updated_at — TIMESTAMP
Reviews_Products
- id — BIGINT
- review_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
Users
- id — BIGINT — Primary key
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP