phone_store
Tables (4)
customers
- customer_id — INT
- name — VARCHAR(100)
- phone_number — VARCHAR(20)
phones
- phone_id — INT
- model — VARCHAR(100)
- brand — VARCHAR(100)
- price — DECIMAL(15,2)
- stock — INT
sales
- sale_id — INT
- phone_model — VARCHAR(100)
- price — DECIMAL(15,2)
- customer_id — INT
- sale_date — DATE
- seller_id — INT
sellers
- seller_id — INT
- name — VARCHAR(100)
- department — VARCHAR(100)