---
# System prepended metadata

title: Pharmacy

---

# 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
