pangtok

Tables (5)

Like (좋아요 테이블)

  • id (PK) — Integer — Primary key — NOT NULL
  • product_id (Product id FK) — Integer — Foreign key → Product.id — NOT NULL
  • user_id (User id FK) — Integer — Foreign key → User.id — NOT NULL
  • is_like (Like or Dislike) — Integer
  • created_at (Like created_at) — Datetime
  • updated_at (Like updated_at) — Datetime

Product (상품 테이블)

  • id (PK) — Integer — Primary key — NOT NULL
  • name (Product name) — Varchar(255)
  • image_path (Product image url) — Varchar(512)
  • price (Product price) — Integer
  • summary (Product summary) — Text
  • created_at (Product created_at) — Datetime
  • updated_at (Product updated_at) — Datetime

Review (댓글 테이블)

  • id (PK) — Integer — Primary key — NOT NULL
  • product_id (Product id FK) — Integer — Foreign key → Product.id — NOT NULL
  • comment (Product comment) — Text
  • created_at (Review created_at) — Datetime
  • updated_at (Review updated_at) — Datetime

ShoppingCart (장바구니)

  • id (PK) — Integer — Primary key — NOT NULL
  • product_id (Product id FK) — Integer — Foreign key → Product.id — NOT NULL
  • user_id (User id FK) — Integer — Foreign key → User.id — NOT NULL

User (유저 테이블)

  • id (PK) — Integer — Primary key — NOT NULL
  • email (User email) — Varchar(255)
  • password (User password) — Varchar(255)
  • created_at (User created_at) — Datetime
  • updated_at (User updated_at) — Datetime