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)