# Pharmacy
## List of Schema

* Client

| Attribute | Type | Key |
| --------- | ------ | --- |
| Client_id | Int | PK |
| Phone | String | |
| Name | String | |
| Password | String | |
| Email | String | |

* Store

| Attribute | Type | Key |
| ------------ | ------ | --- |
| Store_id | Int | PK |
| Client_id | Int | FK |
| Name | String | |
| Location | String | |
| Product rate | Float | |
| Respond rate | Float | |
| image | Byte? | |

* Client
* Client_id
* Name (Nickname)
* Account
* Password
* Address
* Phone_num
* Owner
* Owner_id
* Owner_name
* Account
* Password
* Pharmacy store
* Store_id
* Store_name
* Store_address
* Advertisement
* Ad_id
* Store_id
* Ad_content
* Storage system
* Item_id
* Item_name
* Store_id
* Item_count
* Item_price
* Item_photo
* Transaction
* Transaction_id
* Store_id
* Client_id
* Item_id
* Item_price
* Sold_item_count
* Time
* Chat History
* Client_id
* Store_id
* Chat_history

OAuth2
FastAPI
Kubernetes
bcrypt
cookie (json-cookie)
JWT token