판다마켓
테이블 (4)
comments
- id — SERIAL
- user_id — INTEGER — NOT NULL
- product_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
likes
- id — SERIAL
- user_id — INTEGER — NOT NULL
- product_id — INTEGER — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(user_id, — product_id)
products
- id — SERIAL
- user_id — INTEGER — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(19, 2) — NOT NULL
- created_at — TIMESTAMP
users
- id — SERIAL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP