써밋 프로젝트
테이블 (5)
Product_Categories
- product_id — INT
- category_id — INT
Products
- product_id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- lower_price — DECIMAL(10, 2) — NOT NULL
- upper_price — DECIMAL(10, 2) — NOT NULL
- stock — INT — NOT NULL
- created_at — TIMESTAMP
Transactions
- transaction_id — INT
- product_id — INT — NOT NULL
- user_id — INT — NOT NULL
- purchase_price — DECIMAL(10, 2) — NOT NULL
- quantity — INT — NOT NULL
- status — ENUM('PENDING', 'COMPLETED', 'CANCELLED')
- created_at — TIMESTAMP
관심사 (Interests)
- interest_id — INT
- 이름 (name) — VARCHAR(100) — NOT NULL
- Field
유저 (Users)
- user_id — INT
- 이름 (name) — VARCHAR(100) — NOT NULL
- 이메일 (email) — VARCHAR(150)
- 전화번호 (phone_number) — VARCHAR(15)
- 예산 (budget) — DECIMAL(10, 2)
- created_at — TIMESTAMP
- 닉네임 (nickname) — VARCHAR(100)