pickdam
Tables (12)
Ad
- id — BIGINT
- title — VARCHAR(255)
- link_url — VARCHAR(255)
- admin_id — BIGINT
Banner
- id — BIGINT
- image_url — VARCHAR(255)
- admin_id — BIGINT
Cart
- id — BIGINT
- user_id — BIGINT
- product_id — BIGINT
- quantity — INT
Category
- id — BIGINT
- name — VARCHAR(100)
Event
- id — BIGINT
- title — VARCHAR(255)
- description — TEXT
- admin_id — BIGINT
Notice
- id — BIGINT
- title — VARCHAR(255)
- content — TEXT
- admin_id — BIGINT
Order
- id — BIGINT
- user_id — BIGINT
- product_id — BIGINT
- status — VARCHAR(50)
- created_at — DATETIME
Payment
- id — BIGINT
- order_id — BIGINT
- amount — DECIMAL(10,2)
- method — VARCHAR(50)
Product
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10,2)
- brand — VARCHAR(100)
- category_id — BIGINT
Review
- id — BIGINT
- user_id — BIGINT
- product_id — BIGINT
- content — TEXT
- rating — INT
SearchLog
- id — BIGINT
- user_id — BIGINT
- keyword — VARCHAR(255)
- searched_at — DATETIME
User
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)