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