P-Project
Tables (8)
ai_stylings
- styling_id — BIGINT
- user_id — BIGINT
- pet_id — BIGINT
- product_id — BIGINT — NOT NULL
- input_image_url — VARCHAR(255) — NOT NULL
- result_image_url — VARCHAR(255)
- status — VARCHAR(20)
- created_at — DATETIME
categories
- category_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- display_order — INT
pets
- pet_id — BIGINT
- user_id — BIGINT — NOT NULL
- name — VARCHAR(100)
- breed — VARCHAR(100)
- age — INT
- weight — FLOAT
- neck — FLOAT
- chest — FLOAT
- back_length — FLOAT
- profile_image_url — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
product_images
- image_id — BIGINT
- product_id — BIGINT — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- is_main — BOOLEAN
products
- product_id — BIGINT
- category_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- description — TEXT
- thumbnail_url — VARCHAR(255)
- is_new — BOOLEAN
- is_hot — BOOLEAN
- is_sale — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
reviews
- review_id — BIGINT
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- rating — INT — NOT NULL
- content — TEXT
- created_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
wishlists
- wishlist_id — BIGINT
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- created_at — DATETIME
- UNIQUE(user_id, — product_id)