```update Enh

``update Add Docker build and deployment workflow for CMS and Ionic Mobile, update docker-compose.yml with new service images, and enhance documentation with strategy diagram and endpoint table``
``update Update service address table formatting and placeholders for REQ0021``
2025-05-24 08:51:32 +08:00 · 2025-05-24 08:21:33 +08:00 · 2025-05-24 08:15:44 +08:00 · 2025-05-24 06:11:33 +08:00 · 2025-05-24 06:02:46 +08:00 · 2025-05-24 06:02:35 +08:00
726 changed files with 18854 additions and 37932 deletions
--- a/.crossnote/config.js
+++ b/.crossnote/config.js
@@ -0,0 +1,15 @@
+({
+  katexConfig: {
+  "macros": {}
+},
+  
+  mathjaxConfig: {
+  "tex": {},
+  "options": {},
+  "loader": {}
+},
+  
+  mermaidConfig: {
+  "startOnLoad": false
+},
+})
--- a/.crossnote/head.html
+++ b/.crossnote/head.html
@@ -0,0 +1,19 @@
+<!-- The content below will be included at the end of the <head> element. -->
+<script type="text/javascript">
+  const configureMermaidIconPacks = () => {
+    window['mermaid'].registerIconPacks([
+      {
+        name: 'logos',
+        loader: () => fetch('https://unpkg.com/@iconify-json/logos/icons.json').then((res) => res.json()),
+      },
+    ]);
+  };
+
+  if (document.readyState !== 'loading') {
+    configureMermaidIconPacks();
+  } else {
+    document.addEventListener('DOMContentLoaded', () => {
+      configureMermaidIconPacks();
+    });
+  }
+</script>
--- a/.crossnote/parser.js
+++ b/.crossnote/parser.js
@@ -0,0 +1,12 @@
+({
+  // Please visit the URL below for more information:
+  // https://shd101wyy.github.io/markdown-preview-enhanced/#/extend-parser
+
+  onWillParseMarkdown: async function(markdown) {
+    return markdown;
+  },
+
+  onDidParseMarkdown: async function(html) {
+    return html;
+  },
+})
--- a/.crossnote/style.less
+++ b/.crossnote/style.less
@@ -0,0 +1,8 @@
+
+/* Please visit the URL below for more information: */
+/*   https://shd101wyy.github.io/markdown-preview-enhanced/#/customize-css */
+
+.markdown-preview.markdown-preview {
+  // modify your style here
+  // eg: background-color: blue;
+}
--- a/.editorconfig
+++ b/.editorconfig
@@ -0,0 +1,9 @@
+root = true
+
+[*]
+charset = utf-8
+end_of_line = lf
+indent_size = 2
+indent_style = space
+insert_final_newline = true
+trim_trailing_whitespace = true
--- a/.gitattributes
+++ b/.gitattributes
@@ -0,0 +1 @@
+* text=lf
--- a/.gitignore
+++ b/.gitignore
@@ -1,9 +1,18 @@
+# api_ts
+dist
+
 .next
 node_modules
 005_references/
 _archive/
+
 _del
 *.bak
 *.log
 *.del
-**/_del
+**/*del
+**/*old
+
+**/volumes/**
+006_lab
+**/*.draft
--- a/.prettierrc
+++ b/.prettierrc
@@ -0,0 +1,10 @@
+{
+  "endOfLine": "lf",
+  "printWidth": 120,
+  "quoteProps": "consistent",
+  "semi": true,
+  "singleQuote": true,
+  "tabWidth": 2,
+  "trailingComma": "es5",
+  "plugins": []
+}
--- a/.vscode/extensions.json
+++ b/.vscode/extensions.json
@@ -0,0 +1,15 @@
+{
+  "recommendations": [
+    "christian-kohler.path-intellisense",
+    "esbenp.prettier-vscode",
+    "humao.rest-client",
+    //
+    "matt-meyers.vscode-dbml",
+    "aflalo.dbml-formatter",
+    "nicolas-liger.dbml-viewer",
+    //
+    "bierner.markdown-mermaid",
+    "yzhang.markdown-all-in-one",
+    "shd101wyy.markdown-preview-enhanced"
+  ]
+}
--- a/.vscode/settings.json
+++ b/.vscode/settings.json
@@ -0,0 +1,23 @@
+{
+  "[javascript]": {
+    "editor.defaultFormatter": "esbenp.prettier-vscode"
+  },
+  "[javascriptreact]": {
+    "editor.defaultFormatter": "esbenp.prettier-vscode"
+  },
+  "[jsonc]": {
+    "editor.defaultFormatter": "esbenp.prettier-vscode"
+  },
+  "[typescript]": {
+    "editor.defaultFormatter": "esbenp.prettier-vscode"
+  },
+  "[typescriptreact]": {
+    "editor.defaultFormatter": "esbenp.prettier-vscode"
+  },
+  "workbench.iconTheme": "material-icon-theme",
+  "workbench.colorTheme": "Mermaid Dark",
+  "editor.formatOnSave": true,
+  "git.ignoreLimitWarning": true,
+  //
+  "markdown.styles": ["https://use.fontawesome.com/releases/v5.7.1/css/all.css"]
+}
--- a/000_AI_WORKSPACE/software-engineer/_examples/001_clone.md
+++ b/000_AI_WORKSPACE/software-engineer/_examples/001_clone.md
@@ -0,0 +1,25 @@
+this `tsx` file is clone from elsewhere, please understand, modify and update the content of `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/002_source/cms/src/app/dashboard/teachers/view/[id]/page.tsx.draft` to handle `Teacher` record thanks, modify comments/variables/paths/functions name please
+
+---
+
+please review and update all tsx files in folder `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/002_source/cms/src/db/Users` to make it handle `user` record thanks
+
+---
+
+<!-- read and understand @/_AI_WORKSPACE/greetings/001_greetings.md  -->
+## clone source code from one type to another
+
+please understand, modify and update the content of `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/002_source/cms/src/components/dashboard/teacher/_GUIDELINES.md` to handle `Teacher` record thanks,
+modify comments/variables/paths/functions name please
+
+---
+
+please help to update the tsx files inside folder `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/002_source/cms/src/components/dashboard/student` to handle the `student` record
+
+## steps
+
+- list all `tsx` files inside directory, remember the list
+- clone the original `<original>.tsx` files to `<original>.tsx.draft`
+- do all your modification within `<original>.tsx.draft` files, leave `original.tsx` unchange
+
+---
--- a/000_AI_WORKSPACE/software-engineer/_examples/003_update_dbml_from_schema.md
+++ b/000_AI_WORKSPACE/software-engineer/_examples/003_update_dbml_from_schema.md
@@ -0,0 +1,33 @@
+Hi, i need your help.
+
+## task
+
+i am working on a `dbml` file
+i got a `schema.json` which is exported from pocketbase
+and i want to update it to my current `dbml` file (one way process for documentation usage)
+
+## Rules
+
+- the collection from `json` file started with `_` can be ignored. they are system collection and should not appear in `dbml`
+- one collection from `json` file mapped with one table in `dbml` file
+- the `presentable` field from `json` file should be ignored.
+- the `id` of collection in `json` file should be jod down in the comment of `dbml` file as an reference.
+- you can find the comments in `schema.dbml` contains `pb_xxx` and that is the reference to the table in `schema.json` file.
+
+## steps
+
+- list the collection
+
+## information
+
+json file: `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/001_documentation/Requirements/REQ0006/schema.json`
+dbml file: `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/001_documentation/Requirements/REQ0006/schema.dbml`
+
+## FAQ
+
+1. 对于json中有但dbml中没有的表，应该如何处理？ 添加为新表
+1. 是否需要保留dbml文件中现有的注释和关系定义？ 完全保留
+1. 字段类型映射是否有特殊规则？ 沒有
+1. please keep the existing comment
+
+thanks
--- a/000_AI_WORKSPACE/software-engineer/greetings/001_greetings.md
+++ b/000_AI_WORKSPACE/software-engineer/greetings/001_greetings.md
@@ -0,0 +1,14 @@
+```markdown
+# Greetings
+
+Hi,
+
+Imagine you are a software engineer and i will send you the guideline.
+plesae read it, prepare yourself and i will tell you the task afterwards
+
+please read and understand the markdown files in directory
+`/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/000_AI_WORKSPACE/software-engineer/greetings`,
+it provides background information of project i want you to help.
+
+thanks
+```
--- a/000_AI_WORKSPACE/software-engineer/greetings/002_guideline.md
+++ b/000_AI_WORKSPACE/software-engineer/greetings/002_guideline.md
@@ -0,0 +1,37 @@
+# guideline
+
+## principles
+
+- at any time, please keep your answer, solution, explaination simple and short (K.I.S.S. or 大道至簡)
+- please divide the problem into small parts
+- if you found youself cannot understand the problem, please stop and ask how to do
+- if you found youself cannot solve the problem, plesae stop and ask how to do
+- review the whole solution before you reply to user
+- if code syntax is already there, do follow (e.g. naming convention, syntax) the existing code
+- no need to explain the reason until you are told to do so
+- no need to show me the code change, at the end just simple summary in point form is ok
+
+## highlighted project directories and their meanings
+
+- `_ignore_this_directory` please ignore this directory and any files inside it
+
+- `001_documentation` documentation of this project
+- `002_source` source code of this project
+- `002_source/cms` home of Context management system of this project
+  - use singular form for `src/components/dashboard` (e.g. `src/components/dashboard/student`)
+  - use plural form for `src/app/dashboard` (e.g. `src/app/dashboard/students`)
+- `002_source/ionic_mobile` home of mobile client of this project
+- `002_source/pocketbase` home of pocketbase home directory this project
+- `003_test` e2e test of this project (not yet implemented)
+- `004_marketing` marketing page of this project (not yet implemented)
+- `005_references` opensource refence of this project
+- `006_lab` my test (POC) of this project
+- `README.md` Readme of this project
+- `TODO.md` todo list of this project
+- `001_documentation/Requirements/REQ0019/index.md` describes updated system architecture
+
+- if the directory contains `_GUIDELINES.md`, please read it before operation
+
+## Abbreviations
+
+T.B.A.
--- a/000_AI_WORKSPACE/software-engineer/greetings/003_knowledgebase.md
+++ b/000_AI_WORKSPACE/software-engineer/greetings/003_knowledgebase.md
@@ -0,0 +1,12 @@
+# Knowledgebase
+
+you can answer the question with below knowledge:
+
+## frameworks and stacks
+
+- if code syntax is already there, do follow (e.g. naming convention, syntax) the existing code
+- make use of MCP `Context7` when you troubleshoot the problem with below topics:
+  - [pocketbase javascript SDK](https://context7.com/pocketbase/js-sdk/llms.txt)
+  - [DBML](https://context7.com/holistics/dbml/llms.txt)
+  - [ionic framework](https://context7.com/ionic-team/ionic-framework/llms.txt)
+  - [nextjs 14 app router](https://context7.com/nextjsargentina/next.js-docs/llms.txt)
--- a/000_AI_WORKSPACE/software-engineer/greetings/010_FAQ.md
+++ b/000_AI_WORKSPACE/software-engineer/greetings/010_FAQ.md
@@ -0,0 +1,22 @@
+# FAQ
+
+Q: where is `dbml` file ?
+A: dbml file located in `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/001_documentation/Requirements/REQ0006/schema.dbml`
+
+Q: when file not found, do i need to search it in `_ignore_this_directory` ?
+A: No, you just stop there and voice out.
+
+Q: Shall I assume the component is already exist ?
+A: yes, you can assume that
+
+Q: Is `COL_USER_METAS` the collection for User related (e.g. `Teacher`, `Student`) collections?
+A: yes
+
+Q: Shall I verify `import` or `types` when do modification job ?
+A: No, you just replace the name of the function, variables etc is ok. no need to check for dependencies thanks.
+
+Q: how to list files with `.tsx.draft` extensions in `src/db/UserMetas` folder?
+A: using command like `find src/db/UserMetas -name "*.tsx.draft" -type f -ls` to list the files with `.tsx.draft` extendions only exist in `src/db/UserMetas`
+
+Q: when user want to modify `.tsx.draft` file, do i need to take care the `.tsx` file as well?
+A: No, no don't need to, user will handle the remaining modifications. please restrict your modification in the mentioned file or directory only.
--- a/000_AI_WORKSPACE/software-engineer/greetings/013_DB.md
+++ b/000_AI_WORKSPACE/software-engineer/greetings/013_DB.md
@@ -0,0 +1,39 @@
+# database and schemas
+
+## getting started
+
+Imagine there is a:
+
+1. developer (provide the modification)
+2. QA engineer (provide the feedback, and testing)
+3. software engineer
+4. technical writer
+
+they will:
+
+- conclude and integrate the ideas from developer and QA engineer
+- make decision to modify the code accordingly.
+
+## project background and initial setup
+
+- **IMPORTANT**: No need to reply me what you are going on and your digest in this phase.
+  No need to show me your code plan
+  Just reply me "OK" when done
+
+- base_dir=`/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project`
+
+- `schema.dbml`
+  - read `<base_dir>/001_documentation/Requirements/REQ0006/schema.dbml`
+    this is file in `dbml` format stating the main database structure
+
+- `schema.json`
+  - read `<base_dir>/002_source/cms/src/db/schema.json`
+    this is the file of current pocketbase schema
+
+- look into the md files in folder `<base_dir>/002_source/ionic_mobile/_AI_WORKSPACE/001_guideline`
+
+- if the directory user provided contins `_GUIDELINES.md`, please read the file
+
+- read the files, remember and link up the ideas in file stated above,  i will tell them the task afterwards
+
+- please review at least 3 times after you modified the code
--- a/000_AI_WORKSPACE/testing-engineer/_examples/001_clone.md
+++ b/000_AI_WORKSPACE/testing-engineer/_examples/001_clone.md
@@ -0,0 +1,21 @@
+please review and update all tsx files in folder `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/002_source/cms/src/db/Users` to make it handle `user` record thanks
+
+---
+
+<!-- read and understand @/_AI_WORKSPACE/greetings/001_greetings.md  -->
+## clone source code from one type to another
+
+please understand, modify and update the content of `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/002_source/cms/src/components/dashboard/teacher/_GUIDELINES.md` to handle `Teacher` record thanks,
+modify comments/variables/paths/functions name please
+
+---
+
+please help to update the tsx files inside folder `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/002_source/cms/src/components/dashboard/student` to handle the `student` record
+
+## steps
+
+- list all `tsx` files inside directory, remember the list
+- clone the original `<original>.tsx` files to `<original>.tsx.draft`
+- do all your modification within `<original>.tsx.draft` files, leave `original.tsx` unchange
+
+---
--- a/000_AI_WORKSPACE/testing-engineer/_examples/003_update_dbml_from_schema.md
+++ b/000_AI_WORKSPACE/testing-engineer/_examples/003_update_dbml_from_schema.md
@@ -0,0 +1,33 @@
+Hi, i need your help.
+
+## task
+
+i am working on a `dbml` file
+i got a `schema.json` which is exported from pocketbase
+and i want to update it to my current `dbml` file (one way process for documentation usage)
+
+## Rules
+
+- the collection from `json` file started with `_` can be ignored. they are system collection and should not appear in `dbml`
+- one collection from `json` file mapped with one table in `dbml` file
+- the `presentable` field from `json` file should be ignored.
+- the `id` of collection in `json` file should be jod down in the comment of `dbml` file as an reference.
+- you can find the comments in `schema.dbml` contains `pb_xxx` and that is the reference to the table in `schema.json` file.
+
+## steps
+
+- list the collection
+
+## information
+
+json file: `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/001_documentation/Requirements/REQ0006/schema.json`
+dbml file: `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/001_documentation/Requirements/REQ0006/schema.dbml`
+
+## FAQ
+
+1. 对于json中有但dbml中没有的表，应该如何处理？ 添加为新表
+1. 是否需要保留dbml文件中现有的注释和关系定义？ 完全保留
+1. 字段类型映射是否有特殊规则？ 沒有
+1. please keep the existing comment
+
+thanks
--- a/000_AI_WORKSPACE/testing-engineer/greetings/001_greetings.md
+++ b/000_AI_WORKSPACE/testing-engineer/greetings/001_greetings.md
@@ -0,0 +1,8 @@
+Hi, i will send you the guideline,
+plesae read it, prepare yourself and i will tell you the task afterwards
+
+please read and understand the markdown files in directory
+`/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/000_AI_WORKSPACE/_AI_WORKSPACE/greetings`,
+it provides background information of project i want you to help.
+
+thanks
--- a/000_AI_WORKSPACE/testing-engineer/greetings/002_guideline.md
+++ b/000_AI_WORKSPACE/testing-engineer/greetings/002_guideline.md
@@ -0,0 +1,28 @@
+# guideline
+
+## principles
+
+- at any time, please keep your answer, solution, explaination simple and short (K.I.S.S. or 大道至簡)
+- please divide the problem into small parts
+- if you found youself cannot understand the problem, please stop and ask how to do
+- if you found youself cannot solve the problem, plesae stop and ask how to do
+- review the whole solution before you reply to user
+- if code syntax is already there, do follow (e.g. naming convention, syntax) the existing code
+- no need to explain the reason until you are told to do so
+- no need to show me the code change, at the end just simple summary in point form is ok
+
+## highlighted project directories and their meanings
+
+- `_ignore_this_directory` please ignore this directory and any files inside it
+
+- `001_documentation` documentation of this project
+- `002_source` source code of this project
+- `002_source/cms` home of Context management system of this project
+- `002_source/ionic_mobile` home of mobile client of this project
+- `002_source/pocketbase` home of pocketbase home directory this project
+- `003_test` e2e test of this project (not yet implemented)
+- `004_marketing` marketing page of this project (not yet implemented)
+- `005_references` opensource refence of this project
+- `006_lab` my test (POC) of this project
+- `README.md` Readme of this project
+- `TODO.md` todo list of this project
--- a/000_AI_WORKSPACE/testing-engineer/greetings/003_knowledgebase.md
+++ b/000_AI_WORKSPACE/testing-engineer/greetings/003_knowledgebase.md
@@ -0,0 +1,12 @@
+# Knowledgebase
+
+you can answer the question with below knowledge:
+
+## frameworks and stacks
+
+- if code syntax is already there, do follow (e.g. naming convention, syntax) the existing code
+- make use of MCP `Context7` when you troubleshoot the problem with below topics:
+  - [pocketbase javascript SDK](https://context7.com/pocketbase/js-sdk/llms.txt)
+  - [DBML](https://context7.com/holistics/dbml/llms.txt)
+  - [ionic framework](https://context7.com/ionic-team/ionic-framework/llms.txt)
+  - [nextjs 14 app router](https://context7.com/nextjsargentina/next.js-docs/llms.txt)
--- a/000_AI_WORKSPACE/testing-engineer/greetings/010_FAQ.md
+++ b/000_AI_WORKSPACE/testing-engineer/greetings/010_FAQ.md
@@ -0,0 +1,7 @@
+# FAQ
+
+Q: where is `dbml` file ?
+A: dbml file located in `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/001_documentation/Requirements/REQ0006/schema.dbml`
+
+Q: when file not found, do i need to search it in `_ignore_this_directory` ?
+A: No, you just stop there and voice out.
--- a/000_AI_WORKSPACE/testing-engineer/greetings/013_DB.md
+++ b/000_AI_WORKSPACE/testing-engineer/greetings/013_DB.md
@@ -0,0 +1,48 @@
+# database and schemas
+
+## getting started
+
+Imagine there is a:
+
+1. developer (provide the modification)
+2. QA engineer (provide the feedback, and testing)
+3. software engineer
+4. technical writer
+
+they will:
+
+- conclude and integrate the ideas from developer and QA engineer
+- make decision to modify the code accordingly.
+
+## project background and initial setup
+
+- **IMPORTANT**: No need to reply me what you are going on and your digest in this phase.
+  No need to show me your code plan
+  Just reply me "OK" when done
+
+- base_dir=`/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project`
+
+- `schema.dbml`
+  - read `<base_dir>/001_documentation/Requirements/REQ0006/schema.dbml`
+    this is file in `dbml` format stating the main database structure
+
+- `schema.json`
+  - read `<base_dir>/002_source/cms/src/db/schema.json`
+    this is the file of current pocketbase schema
+
+- look into the md files in folder `<base_dir>/002_source/ionic_mobile/_AI_WORKSPACE/001_guideline`
+
+- if the directory user provided contins `_GUIDELINES.md`, please read the file
+
+- read the files, remember and link up the ideas in file stated above,  i will tell them the task afterwards
+
+- please review at least 3 times after you modified the code
+
+## frameworks documentation and samples
+
+- react
+- ionic and capacitor
+- pocketbase
+- tanstack/react-query
+- vite
+- typescript
--- a/001_documentation/.vscode/extensions.json
+++ b/001_documentation/.vscode/extensions.json
@@ -1,6 +1,5 @@
 {
  "recommendations": [
-    "redhat.vscode-yaml",
    "yzhang.markdown-all-in-one",
    "esbenp.prettier-vscode",
    "ms-python.python",
@@ -8,7 +7,6 @@
    "ms-python.debugpy",
    "ms-python.black-formatter",
    "ms-python.isort",
-    "ms-python.pylint",
    "bierner.markdown-mermaid",
    "shd101wyy.markdown-preview-enhanced",
    "yzhang.markdown-all-in-one",
--- a/001_documentation/Requirements/REQ0001/index.md
+++ b/001_documentation/Requirements/REQ0001/index.md
@@ -24,5 +24,4 @@ mindmap
    Tools
      Pen and paper
      Mermaid
-
 ```
--- a/001_documentation/Requirements/REQ0002/index.md
+++ b/001_documentation/Requirements/REQ0002/index.md
@@ -1,9 +1,27 @@
 ---
-tags: mobile, lesson
+tags: time
 ---

-# lesson page documentation
+# time tracking

-it should have a lesson page
+T.B.A.

-![alt text](image.png)
+```mermaid
+gantt
+    title A Gantt Diagram
+    dateFormat YYYY-MM-DD
+    section Section
+        A task          :a1, 2014-01-01, 30d
+        Another task    :after a1, 20d
+    section Another
+        Task in Another :2014-01-12, 12d
+        another task    :24d
+```
+
+---
+
+## TODOs of the project
+
+- [cms TODO](../../../002_source/cms/TODO.md)
+- [ionic TODO](../../../002_source/ionic_mobile/TODO.md)
+- [pocketbase TODO](../../../002_source/pocketbase/TODO.md)
--- a/001_documentation/Requirements/REQ0006/008_update_dbml_from_json.md
+++ b/001_documentation/Requirements/REQ0006/008_update_dbml_from_json.md
@@ -0,0 +1,20 @@
+# task
+
+update `dbml` from `schema.json`, for collection `billingAddress`
+
+## Background information
+
+1. please ignore `presentable` properties from `schema.json`, this is for pocketbase internal usage
+1. please ignore collections with `_` as its first character, this is for pocketbase internal usage
+1. just return the collection with `billingAddress` is ok, please ignore other collections
+
+## steps
+
+1. read file `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/002_source/cms/src/db/schema.json`. this is the export from `pocketbase`.
+1. read file `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/001_documentation/Requirements/REQ0006/schema.dbml`. this is file written in dbml format.
+1. currently the collection in `schama.json` is mapped to table in `schema.dbml`
+1. compare the `schema.json` and `schema.dbml`, remember the differences
+1. you may found some comment already exist in `schema.dbml`, please keep them
+1. while keeping `schema.json` content unchanged. write file to `/home/logic/_wsl_workspace/001_github_ws/lettersoup-online-ws/lettersoup-online/project/001_documentation/Requirements/REQ0006/schema_ai_draft.dbml` content based on `schema.json`.
+
+thanks.
--- a/001_documentation/Requirements/REQ0006/PROMPT_LessonCategories.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_LessonCategories.MD
@@ -1,20 +0,0 @@
-
-# LessonCategories / LessonCategory
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listLessonCategories.ts to cover `LessonCategories`,
-draft `ts` code
-
- `CRUD`
- `getFulllistLessonCategories,`
- `getListByFilterLessonCategories,`
- `getFirstListItemLessonCategories,`
- `getOneLessonCategory,`
- `getListLessonCategoryById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_LessonTypes.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_LessonTypes.MD
@@ -1,20 +0,0 @@
-
-# LessonTypes / LessonType
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listLessonTypes.ts to cover `LessonTypes`,
-draft `ts` code
-
- `CRUD`
- `getFulllistLessonTypes,`
- `getListByFilterLessonTypes,`
- `getFirstListItemLessonTypes,`
- `getOneLessonType,`
- `getListLessonTypeById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_QuizCategories.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_QuizCategories.MD
@@ -1,20 +0,0 @@
-
-# QuizCategories / QuizCategory
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listQuizCategories.ts to cover `QuizCategories`,
-draft `ts` code
-
- `CRUD`
- `getFulllistQuizCategories,`
- `getListByFilterQuizCategories,`
- `getFirstListItemQuizCategories,`
- `getOneQuizCategory,`
- `getListQuizCategoryById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_QuizConnectives.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_QuizConnectives.MD
@@ -1,20 +0,0 @@
-
-# QuizConnectives / QuizConnective
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listQuizConnectives.ts to cover `QuizConnectives`,
-draft `ts` code
-
- `CRUD`
- `getFulllistQuizConnectives,`
- `getListByFilterQuizConnectives,`
- `getFirstListItemQuizConnectives,`
- `getOneQuizConnective,`
- `getListQuizConnectiveById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_QuizConnectivesCategories.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_QuizConnectivesCategories.MD
@@ -1,20 +0,0 @@
-
-# QuizConnectivesCategories / QuizConnectivesCategory
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listQuizConnectivesCategories.ts to cover `QuizConnectivesCategories`,
-draft `ts` code
-
- `CRUD`
- `getFulllistQuizConnectivesCategories,`
- `getListByFilterQuizConnectivesCategories,`
- `getFirstListItemQuizConnectivesCategories,`
- `getOneQuizConnectivesCategory,`
- `getListQuizConnectivesCategoryById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_QuizListenings.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_QuizListenings.MD
@@ -1,20 +0,0 @@
-
-# QuizListenings / QuizListening
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listQuizListenings.ts to cover `QuizListenings`,
-draft `ts` code
-
- `CRUD`
- `getFulllistQuizListenings,`
- `getListByFilterQuizListenings,`
- `getFirstListItemQuizListenings,`
- `getOneQuizListening,`
- `getListQuizListeningById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_QuizMatchings.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_QuizMatchings.MD
@@ -1,20 +0,0 @@
-
-# QuizMatchings / QuizMatching
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listQuizMatchings.ts to cover `QuizMatchings`,
-draft `ts` code
-
- `CRUD`
- `getFulllistQuizMatchings,`
- `getListByFilterQuizMatchings,`
- `getFirstListItemQuizMatchings,`
- `getOneQuizMatching,`
- `getListQuizMatchingById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_UserMetas.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_UserMetas.MD
@@ -1,20 +0,0 @@
-
-# UserMetas / UserMeta
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listUserMetas.ts to cover `UserMetas`,
-draft `ts` code
-
- `CRUD`
- `getFulllistUserMetas,`
- `getListByFilterUserMetas,`
- `getFirstListItemUserMetas,`
- `getOneUserMeta,`
- `getListUserMetaById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_Users.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_Users.MD
@@ -1,20 +0,0 @@
-
-# Users / User
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listUsers.ts to cover `Users`,
-draft `ts` code
-
- `CRUD`
- `getFulllistUsers,`
- `getListByFilterUsers,`
- `getFirstListItemUsers,`
- `getOneUser,`
- `getListUserById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/PROMPT_Vocabularies.MD
+++ b/001_documentation/Requirements/REQ0006/PROMPT_Vocabularies.MD
@@ -1,20 +0,0 @@
-
-# Vocabularies / Vocabulary
-
-Hi, using information from
-
- @schema.dbml for schemas, fields and table names,
- @listHelloworld.ts for skeleton for ts script
- @listVocabularies.ts, @listUserMetas.ts, @listQuizListening.ts, @listQuisMatching.ts, @listQuizConnectivesCategories for reference
-
-extend @listVocabularies.ts to cover `Vocabularies`,
-draft `ts` code
-
- `CRUD`
- `getFulllistVocabularies,`
- `getListByFilterVocabularies,`
- `getFirstListItemVocabularies,`
- `getOneVocabulary,`
- `getListVocabularyById`
-
-thanks
--- a/001_documentation/Requirements/REQ0006/_GUIDELINE.md
+++ b/001_documentation/Requirements/REQ0006/_GUIDELINE.md
@@ -0,0 +1,6 @@
+# GUIDELINES
+
+- `schema.dbml` means DB schema in `dbml` format
+- `schema.json` contains the exported DB schema from pocketbase
+- the `Collection ID: xxx` in `dbml` file contains the collection `id` mapping from `schema.json`
+- the `presentable` field from `json` file should be ignored.
--- a/001_documentation/Requirements/REQ0006/convert.js
+++ b/001_documentation/Requirements/REQ0006/convert.js
@@ -0,0 +1,86 @@
+//
+// # REQ0015:
+// ## PURPOSE:
+//
+// This is a script to convert `schema.json` exported from pocketbase to dbml formatted file `schema.dbml`
+//
+//
+
+const fs = require("fs");
+const path = require("path");
+// Load schema.json
+const schemaPath = path.join(process.cwd(), "schema.json");
+const schema = JSON.parse(fs.readFileSync(schemaPath, "utf8"));
+
+// Type mapping from PocketBase to DBML/SQL
+const typeMapping = {
+  text: "text",
+  number: "integer",
+  bool: "boolean",
+  email: "text",
+  url: "varchar",
+  date: "datetime",
+  select: "varchar",
+  json: "text",
+  file: "file",
+  password: "varchar",
+  relation: "integer", // Assuming relations are stored as integer IDs
+  autodate: "datetime",
+};
+
+function convertToDBML(schema) {
+  let dbml = "";
+  dbml = "// Generated at:  " + new Date().toISOString();
+  dbml = dbml + "\n\n\n";
+
+  let collectionIdToTableMapping = {};
+  for (const [idx, tableDef] of Object.entries(schema)) {
+    collectionIdToTableMapping[tableDef.id] = tableDef.name;
+  }
+
+  for (const [idx, tableDef] of Object.entries(schema)) {
+    console.log({ idx });
+    dbml += `// \n`;
+    dbml += `// collection id:   ${tableDef.id} \n`;
+    dbml += `// collection name: ${tableDef.name} \n`;
+    dbml += `// collection type: ${tableDef.type} \n`;
+    dbml += `Table ${tableDef.name} {\n`;
+
+    for (const field of tableDef.fields) {
+      // Get field type
+      let fieldType = typeMapping[field.type] || "text";
+
+      // Handle special cases
+      if (field.type === "number" && field.options?.max === 1) {
+        fieldType = "boolean";
+      }
+
+      // Build field definition
+      let line = `  ${field.name} ${fieldType}`;
+
+      // Add constraints
+      const constraints = [];
+      if (field.name === "id" || field.primary) constraints.push("pk");
+      if (field.required) constraints.push("not null");
+      if (constraints.length > 0) line += ` [${constraints.join(", ")}]`;
+
+      if (field.collectionId) {
+        line += ` [ref: > ${
+          collectionIdToTableMapping[field.collectionId]
+        }.id] // ${field.id}`;
+      }
+
+      dbml += `${line}\n`;
+      console.log({ line });
+    }
+
+    dbml += "}\n\n";
+  }
+
+  return dbml;
+}
+
+// Convert and save
+const dbmlOutput = convertToDBML(schema);
+fs.writeFileSync("schema.dbml", dbmlOutput);
+console.log("DBML file generated successfully!");
--- a/001_documentation/Requirements/REQ0006/gen_customer/gen_customer.mjs
+++ b/001_documentation/Requirements/REQ0006/gen_customer/gen_customer.mjs
@@ -0,0 +1,29 @@
+import { faker } from '@faker-js/faker';
+
+const getId = (id) => id.padStart(15, '0');
+
+const row_array = Array.from({ length: 10 }, (_, i) => [
+  getId(String(i + 1)),
+  faker.person.firstName(),
+  '',
+  faker.internet.email(),
+  faker.phone.number(),
+  faker.company.name(),
+  {
+    country: faker.location.country(),
+    state: faker.location.state(),
+    city: faker.location.city(),
+    zipCode: faker.location.zipCode(),
+    line1: faker.location.streetAddress(),
+    line2: faker.location.secondaryAddress(),
+  },
+  Math.floor(Math.random() * (100 - 0 + 1)) + 0,
+  faker.location.timeZone(),
+  ['en', 'de', 'es', 'fr', 'ja', 'ko', 'zh-CN'].sort(() => Math.random() - 0.5)[0],
+  faker.finance.currencyCode(),
+]);
+
+import fs from 'fs';
+const filePath = 'output.json';
+fs.writeFileSync(filePath, JSON.stringify(row_array, null, 2));
+console.log(`Wrote ${row_array.length} records to ${filePath}`);
--- a/001_documentation/Requirements/REQ0006/gen_customer/output.json
+++ b/001_documentation/Requirements/REQ0006/gen_customer/output.json
@@ -0,0 +1,202 @@
+[
+  [
+    "000000000000001",
+    "May",
+    "",
+    "June_Wintheiser33@hotmail.com",
+    "281-378-5900 x822",
+    "Green, Rempel and Hoeger",
+    {
+      "country": "Central African Republic",
+      "state": "Arizona",
+      "city": "Winfieldburgh",
+      "zipCode": "92017-8004",
+      "line1": "1838 Willa Freeway",
+      "line2": "Suite 307"
+    },
+    98,
+    "Asia/Urumqi",
+    "de",
+    "MUR"
+  ],
+  [
+    "000000000000002",
+    "Marilyne",
+    "",
+    "Carol_Blick@yahoo.com",
+    "(893) 919-2445 x193",
+    "White - Hessel",
+    {
+      "country": "Iraq",
+      "state": "Nevada",
+      "city": "Casa Grande",
+      "zipCode": "83831-3843",
+      "line1": "6984 Alberto Radial",
+      "line2": "Suite 154"
+    },
+    49,
+    "Africa/Tunis",
+    "zh-CN",
+    "CHF"
+  ],
+  [
+    "000000000000003",
+    "Jacklyn",
+    "",
+    "Tamara_Lynch11@yahoo.com",
+    "597-593-0144 x168",
+    "Rolfson LLC",
+    {
+      "country": "Grenada",
+      "state": "Georgia",
+      "city": "New Brodyfort",
+      "zipCode": "18887-7075",
+      "line1": "493 Pfannerstill Meadow",
+      "line2": "Apt. 358"
+    },
+    44,
+    "Asia/Manila",
+    "zh-CN",
+    "CDF"
+  ],
+  [
+    "000000000000004",
+    "Alana",
+    "",
+    "Ahmed_Willms@hotmail.com",
+    "401.212.0386 x31125",
+    "Friesen, Langworth and Thompson",
+    {
+      "country": "Australia",
+      "state": "North Carolina",
+      "city": "Fort Jerrell",
+      "zipCode": "14211",
+      "line1": "1763 West Street",
+      "line2": "Suite 699"
+    },
+    34,
+    "America/Boa_Vista",
+    "ja",
+    "KES"
+  ],
+  [
+    "000000000000005",
+    "Rocky",
+    "",
+    "Angela_Kuhic@gmail.com",
+    "653.964.0412",
+    "Hayes - Morar",
+    {
+      "country": "Reunion",
+      "state": "New York",
+      "city": "Kayton",
+      "zipCode": "82048-0645",
+      "line1": "636 Angel Junction",
+      "line2": "Apt. 361"
+    },
+    70,
+    "America/Grand_Turk",
+    "fr",
+    "PGK"
+  ],
+  [
+    "000000000000006",
+    "Carmela",
+    "",
+    "Larry94@hotmail.com",
+    "1-508-980-1889 x134",
+    "Goodwin - Brown",
+    {
+      "country": "Heard Island and McDonald Islands",
+      "state": "Wisconsin",
+      "city": "Jalenbury",
+      "zipCode": "75732-7013",
+      "line1": "669 Sven Trail",
+      "line2": "Suite 409"
+    },
+    48,
+    "Asia/Karachi",
+    "fr",
+    "AMD"
+  ],
+  [
+    "000000000000007",
+    "Lucious",
+    "",
+    "Lera67@yahoo.com",
+    "(684) 748-3653 x8745",
+    "Harvey - Kilback",
+    {
+      "country": "Israel",
+      "state": "Maryland",
+      "city": "East Allenmouth",
+      "zipCode": "21779",
+      "line1": "6070 W Grand Avenue",
+      "line2": "Suite 448"
+    },
+    83,
+    "America/St_Barthelemy",
+    "en",
+    "SBD"
+  ],
+  [
+    "000000000000008",
+    "Anika",
+    "",
+    "Shane.Moore@gmail.com",
+    "(996) 909-3575 x614",
+    "Donnelly, Larson and Stamm",
+    {
+      "country": "Canada",
+      "state": "Michigan",
+      "city": "Lafayette",
+      "zipCode": "90430-8775",
+      "line1": "430 Orland Place",
+      "line2": "Suite 891"
+    },
+    64,
+    "America/Toronto",
+    "fr",
+    "PKR"
+  ],
+  [
+    "000000000000009",
+    "Otto",
+    "",
+    "Emery_Wisozk@yahoo.com",
+    "1-602-251-7035 x9461",
+    "Kreiger - Boehm",
+    {
+      "country": "South Georgia and the South Sandwich Islands",
+      "state": "Colorado",
+      "city": "Lake Isaias",
+      "zipCode": "26025-5909",
+      "line1": "143 Kautzer Unions",
+      "line2": "Apt. 752"
+    },
+    98,
+    "Africa/Ndjamena",
+    "fr",
+    "JOD"
+  ],
+  [
+    "000000000000010",
+    "Cortez",
+    "",
+    "Jameson13@hotmail.com",
+    "1-660-472-1494",
+    "Parisian LLC",
+    {
+      "country": "Mali",
+      "state": "Illinois",
+      "city": "Stammburgh",
+      "zipCode": "92318",
+      "line1": "7669 Jude Drive",
+      "line2": "Apt. 594"
+    },
+    59,
+    "Africa/Lubumbashi",
+    "en",
+    "VND"
+  ]
+]
--- a/001_documentation/Requirements/REQ0006/gen_customer/package-lock.json
+++ b/001_documentation/Requirements/REQ0006/gen_customer/package-lock.json
@@ -0,0 +1,33 @@
+{
+  "name": "gen_customer",
+  "version": "1.0.0",
+  "lockfileVersion": 3,
+  "requires": true,
+  "packages": {
+    "": {
+      "name": "gen_customer",
+      "version": "1.0.0",
+      "license": "ISC",
+      "devDependencies": {
+        "@faker-js/faker": "^9.7.0"
+      }
+    },
+    "node_modules/@faker-js/faker": {
+      "version": "9.7.0",
+      "resolved": "https://registry.npmjs.org/@faker-js/faker/-/faker-9.7.0.tgz",
+      "integrity": "sha512-aozo5vqjCmDoXLNUJarFZx2IN/GgGaogY4TMJ6so/WLZOWpSV7fvj2dmrV6sEAnUm1O7aCrhTibjpzeDFgNqbg==",
+      "dev": true,
+      "funding": [
+        {
+          "type": "opencollective",
+          "url": "https://opencollective.com/fakerjs"
+        }
+      ],
+      "license": "MIT",
+      "engines": {
+        "node": ">=18.0.0",
+        "npm": ">=9.0.0"
+      }
+    }
+  }
+}
--- a/001_documentation/Requirements/REQ0006/gen_customer/package.json
+++ b/001_documentation/Requirements/REQ0006/gen_customer/package.json
@@ -0,0 +1,15 @@
+{
+  "name": "gen_customer",
+  "version": "1.0.0",
+  "main": "gen_customer.js",
+  "scripts": {
+    "test": "echo \"Error: no test specified\" && exit 1"
+  },
+  "keywords": [],
+  "author": "",
+  "license": "ISC",
+  "description": "",
+  "devDependencies": {
+    "@faker-js/faker": "^9.7.0"
+  }
+}
--- a/001_documentation/Requirements/REQ0006/gen_customer/pnpm-lock.yaml
+++ b/001_documentation/Requirements/REQ0006/gen_customer/pnpm-lock.yaml
@@ -0,0 +1,23 @@
+lockfileVersion: '9.0'
+
+settings:
+  autoInstallPeers: true
+  excludeLinksFromLockfile: false
+
+importers:
+
+  .:
+    devDependencies:
+      '@faker-js/faker':
+        specifier: ^9.7.0
+        version: 9.7.0
+
+packages:
+
+  '@faker-js/faker@9.7.0':
+    resolution: {integrity: sha512-aozo5vqjCmDoXLNUJarFZx2IN/GgGaogY4TMJ6so/WLZOWpSV7fvj2dmrV6sEAnUm1O7aCrhTibjpzeDFgNqbg==}
+    engines: {node: '>=18.0.0', npm: '>=9.0.0'}
+
+snapshots:
+
+  '@faker-js/faker@9.7.0': {}
--- a/001_documentation/Requirements/REQ0006/schema.dbml
+++ b/001_documentation/Requirements/REQ0006/schema.dbml
@@ -1,266 +1,476 @@
-// Users table with auth fields
-Table Users {
-  // system field
-  id text [pk]
-  tokenKey text [not null]
-  created datetime [default: `now()`]
-  updated datetime
-  password text [not null]
+// Generated at:  2025-05-13T05:24:33.962Z

-  // value field
+
+// 
+// collection id:   pbc_3142635823 
+// collection name: _superusers 
+// collection type: auth 
+Table _superusers {
+  id text [pk, not null]
+  password varchar [not null]
+  tokenKey text [not null]
+  email text [not null]
+  emailVisibility boolean
+  verified boolean
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   _pb_users_auth_ 
+// collection name: users 
+// collection type: auth 
+Table users {
+  id text [pk, not null]
+  password varchar [not null]
+  tokenKey text [not null]
  email text [not null]
  emailVisibility boolean
  verified boolean
  name text
  avatar file
+  created datetime
+  updated datetime
+  visible text
+  phone text
 }

-// LessonTypes stores different types of lessons
-// lesson_types, lesson_type
-Table LessonTypes {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`] // timestamp when the lesson type was created
-  updated datetime // timestamp when the lesson type was last updated
-  // value field
-  name text // changed from varchar to text
-  type text // changed from varchar to text
+// 
+// collection id:   pbc_1430376151 
+// collection name: Categories 
+// collection type: base 
+Table Categories {
+  id text [pk, not null]
+  cat_name text
+  cat_image_url text
+  cat_image file
+  pos integer
+  lesson_id integer [ref: > LessonsTypes.id] // relation3455582614
+  remarks text
+  visible text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_108570809 
+// collection name: Customers 
+// collection type: base 
+Table Customers {
+  id text [pk, not null]
+  name text
+  email text
+  phone text
+  quota integer
+  status text
+  avatar_file file
+  user_id integer [ref: > users.id] // relation2809058197
+  billingAddress text
+  timezone text
+  language text
+  currency text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_1196309394 
+// collection name: LessonsCategories 
+// collection type: base 
+Table LessonsCategories {
+  id text [pk, not null]
+  cat_name text
+  cat_image_url text
+  cat_image file
+  pos integer
+  lesson_id integer [ref: > LessonsTypes.id] // relation3455582614
+  description text
+  remarks text
+  visible text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_2328411368 
+// collection name: LessonsTypes 
+// collection type: base 
+Table LessonsTypes {
+  id text [pk, not null]
+  name text
+  type text
  pos integer
  visible text
-  field date
-}
-
-
-// LessonCategories stores categories of lessons
-// lesson_categories, lesson_category
-Table LessonCategories {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`] // timestamp when the category was created
-  updated datetime // timestamp when the category was last updated
-  // value field
-  cat_name text // changed from varchar to text
-  cat_image_url text // new field
-  cat_image file // changed from varchar to file
-  pos integer
-  lesson_id integer [ref: > LessonTypes.id] // foreign key referencing LessonTypes.id
-  description text // new field
-  remarks text // changed from varchar to text
-  visible text // new field
-}
-
-Table Helloworlds {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-  hello text // new field
-}
-
-Table UserMetas {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`]
+  created datetime
  updated datetime
-
-  // value field
-  helloworld text // changed from varchar to text
-  meta json // new field
-  user_id text [ref: > Users.id] // changed type and reference
-  state text // new field
-  avatar file // changed from blob to file
-  role text // new field
+  field datetime
 }

-Table QuizCategories {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`]
+// 
+// collection id:   pbc_977978967 
+// collection name: Notifications 
+// collection type: base 
+Table Notifications {
+  id text [pk, not null]
+  read boolean
+  type text
+  job text
+  description text
+  NOTI_ID text
+  created datetime
  updated datetime
-
-  // value field
-  cat_name text // changed from varchar to text
-  cat_image text // changed from varchar to text
-  init_answer json // new field
+  to_user_id integer [ref: > UserMetas.id] // relation704048736
+  from_user_id integer [ref: > UserMetas.id] // relation556806202
+  author integer [ref: > UserMetas.id] // relation3182418120
+  content text
+  company text
+  link varchar
 }

-
-// stores all questions of matching frenzy
-Table QuizMatchings {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-
-  // value field
-  word text // changed from varchar to text
-  word_c text // changed from varchar to text
-  cat_id text [ref: > QuizCategories.id] // changed type and reference
-}
-
-// QuizListening stores all listening quiz data
-Table QuizListenings {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-
-  // value field
-  sound file // changed from varchar to file
-  word text // changed from varchar to text
-  cat_id text [ref: > QuizCategories.id] // changed type and reference
-}
-
-
-// stores all categories of connectives revision quiz
-Table QuizConnectivesCategories {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-
-  // value field
-  cat_name text // changed from varchar to text
-  cat_image file // changed from varchar to file
-}
-
-// stores all questions of connectives revision quiz
-Table QuizConnectives {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-
-  // value field
-  question_fh text // changed from varchar to text
-  question_sh text // changed from varchar to text
-  modal_ans text // changed from varchar to text
-  cat_id text [ref: > QuizConnectivesCategories.id] // changed type and reference
-}
-
-// Lessons stores all lessons in the database
-Table Vocabularies {
-  // system field
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`] // timestamp when the lesson was created
-  updated datetime // timestamp when the lesson was last updated
-
-  // value field
-  image file // changed from varchar to file
-  sound file // changed from varchar to file
-  word text // changed from varchar to text
-  word_c text // changed from varchar to text
-  sample_e text // changed from varchar to text
-  sample_c text // changed from varchar to text
-  cat_id text [ref: > LessonCategories.id] // changed type and reference
-  category text // changed from varchar to text
-  lesson_type_id text [ref: > LessonTypes.id] // changed type and reference
-}
-
-// Listening Practice Quiz Categories
-// store listening practice category, (LpCategories, LpCategory)
-Table QuizLPCategories {
-  // system fields
-  id text [pk]
-  created datetime [default: `now()`]
-  updated datetime
-
-  // value fields
+// 
+// collection id:   pbc_4061499106 
+// collection name: QuizCRCategories 
+// collection type: base 
+Table QuizCRCategories {
+  id text [pk, not null]
  cat_name text
  cat_image file
-  pos number
-  init_answer json
+  pos integer
+  init_answer text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_3141885671 
+// collection name: QuizCRQuestions 
+// collection type: base 
+Table QuizCRQuestions {
+  id text [pk, not null]
+  question_fh text
+  question_sh text
+  modal_ans text
+  cat_id integer [ref: > QuizCRCategories.id] // relation1827623476
+  options text
+  created datetime
+  updated datetime
+  init_answer text
+}
+
+// 
+// collection id:   pbc_3571292172 
+// collection name: QuizCategories 
+// collection type: base 
+Table QuizCategories {
+  id text [pk, not null]
+  cat_name text
+  cat_image text
+  init_answer text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_96745150 
+// collection name: QuizConnectives 
+// collection type: base 
+Table QuizConnectives {
+  id text [pk, not null]
+  question_fh text
+  question_sh text
+  modal_ans text
+  cat_id integer [ref: > QuizConnectivesCategories.id] // relation3870140739
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_342761728 
+// collection name: QuizConnectivesCategories 
+// collection type: base 
+Table QuizConnectivesCategories {
+  id text [pk, not null]
+  cat_name text
+  cat_image file
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_3639453778 
+// collection name: QuizLPCategories 
+// collection type: base 
+Table QuizLPCategories {
+  id text [pk, not null]
+  cat_name text
+  cat_image file
+  pos integer
+  init_answer text
  visible text
+  created datetime
+  updated datetime
  slug text
  remarks text
  description text
 }

-// Listening Practice Quiz Questions
+// 
+// collection id:   pbc_742947356 
+// collection name: QuizLPQuestions 
+// collection type: base 
 Table QuizLPQuestions {
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`]
-  updated datetime
-  word text // changed from varchar to text
-  sound file // changed from blob to file
-  cat_id text [ref: > QuizLPCategories.id] // changed type and reference
-  cat_name text // new field
-  cat_image file // new field
-  pos number // new field
-  init_answer json // new field
-  visible text // new field
-  slug text // new field
-  remarks text // new field
-  description text // new field
-}
-
-// Matching Frenzy Quiz Categories
-Table QuizMFCategories {
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`]
-  updated datetime
-  cat_name text // changed from varchar to text
-  cat_image file // changed from blob to file
-  pos number // changed from integer to number
-  init_answer json
-  visible text // new field
-}
-
-// Matching Frenzy Quiz Questions
-Table QuizMFQuestions {
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`]
-  updated datetime
-  word text // changed from varchar to text
-  word_c text // changed from varchar to text
-  cat_id text [ref: > QuizMFCategories.id] // changed type and reference
-  visible text // new field
-  sound file // new field
-  cat_image file // new field
-}
-
-// Connectives Revision Quiz Categories
-Table QuizCRCategories {
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`]
-  updated datetime
-  cat_name text // changed from varchar to text
-  cat_image file // changed from blob to file
+  id text [pk, not null]
+  word text
+  sound file
+  cat_id integer [ref: > QuizLPCategories.id] // relation3870140739
+  cat_name text
+  cat_image file
  pos integer
-  init_answer json
+  init_answer text
+  visible text
+  slug text
+  remarks text
+  description text
+  created datetime
+  updated datetime
 }

-// Connectives Revision Quiz Questions
-Table QuizCRQuestions {
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`]
+// 
+// collection id:   pbc_2511066072 
+// collection name: QuizListenings 
+// collection type: base 
+Table QuizListenings {
+  id text [pk, not null]
+  sound file
+  word text
+  cat_id integer [ref: > QuizCategories.id] // relation3870140739
+  created datetime
  updated datetime
-  question_fh text // changed from varchar to text
-  question_sh text // changed from varchar to text
-  modal_ans text // changed from varchar to text
-  cat_id text [ref: > QuizCRCategories.id] // changed type and reference
-  options json // new field
 }

-// Test table
-Table t1 {
-  id text [pk] // changed from int to text
-  created datetime [default: `now()`]
+// 
+// collection id:   pbc_84667061 
+// collection name: QuizMFCategories 
+// collection type: base 
+Table QuizMFCategories {
+  id text [pk, not null]
+  cat_name text
+  cat_image file
+  pos integer
+  init_answer text
+  visible text
+  created datetime
  updated datetime
-  hello text // changed from name to hello
-  test_file file // new field
 }

-// Customers table
-Table Customers {
-  id text [pk] // new table
-  created datetime [default: `now()`]
+// 
+// collection id:   pbc_3346420851 
+// collection name: QuizMFQuestions 
+// collection type: base 
+Table QuizMFQuestions {
+  id text [pk, not null]
+  word text
+  word_c text
+  cat_id integer [ref: > QuizMFCategories.id] // relation3870140739
+  created datetime
  updated datetime
+  visible text
+  sound file
+  cat_image file
+  init_answer text
+}
+
+// 
+// collection id:   pbc_2936646783 
+// collection name: QuizMatchings 
+// collection type: base 
+Table QuizMatchings {
+  id text [pk, not null]
+  word text
+  word_c text
+  cat_id integer [ref: > QuizCategories.id] // relation3870140739
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_491894781 
+// collection name: Students 
+// collection type: base 
+Table Students {
+  id text [pk, not null]
  name text
  email text
  phone text
-  quota number
+  quota integer
  status text
  avatar_file file
-  cat_id text [ref: > QuizMFCategories.id] // refer to a single user in `Users` table
+  user_id integer [ref: > users.id] // relation2809058197
+  billingAddress text
+  timezone text
+  language text
+  currency text
+  created datetime
+  updated datetime
 }
+
+// 
+// collection id:   pbc_1413424569 
+// collection name: Teachers 
+// collection type: base 
+Table Teachers {
+  id text [pk, not null]
+  name text
+  email text
+  phone text
+  quota integer
+  status text
+  avatar_file file
+  user_id integer [ref: > users.id] // relation2809058197
+  billingAddress text
+  timezone text
+  language text
+  currency text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_1305841361 
+// collection name: UserMetas 
+// collection type: base 
+Table UserMetas {
+  id text [pk, not null]
+  address text
+  meta text
+  user_id integer [ref: > users.id] // relation2809058197
+  state text
+  created datetime
+  updated datetime
+  avatar file
+  role text
+  name text
+  email text
+  phone text
+  company text
+  taxId text
+  timezone text
+  language text
+  currency text
+  billingAddress integer [ref: > billingAddress.id] // relation2115670734
+}
+
+// 
+// collection id:   pbc_1638686383 
+// collection name: Vocabularies 
+// collection type: base 
+Table Vocabularies {
+  id text [pk, not null]
+  image file
+  sound file
+  word text
+  word_c text
+  sample_e text
+  sample_c text
+  cat_id integer [ref: > Categories.id] // relation3870140739
+  category text
+  lesson_type_id integer [ref: > LessonsTypes.id] // relation808508980
+  created datetime
+  updated datetime
+  visible text
+  type text
+}
+
+// 
+// collection id:   pbc_4275539003 
+// collection name: _authOrigins 
+// collection type: base 
+Table _authOrigins {
+  id text [pk, not null]
+  collectionRef text [not null]
+  recordRef text [not null]
+  fingerprint text [not null]
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_2281828961 
+// collection name: _externalAuths 
+// collection type: base 
+Table _externalAuths {
+  id text [pk, not null]
+  collectionRef text [not null]
+  recordRef text [not null]
+  provider text [not null]
+  providerId text [not null]
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_2279338944 
+// collection name: _mfas 
+// collection type: base 
+Table _mfas {
+  id text [pk, not null]
+  collectionRef text [not null]
+  recordRef text [not null]
+  method text [not null]
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_1638494021 
+// collection name: _otps 
+// collection type: base 
+Table _otps {
+  id text [pk, not null]
+  collectionRef text [not null]
+  recordRef text [not null]
+  password varchar [not null]
+  sentTo text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_1509025625 
+// collection name: billingAddress 
+// collection type: base 
+Table billingAddress {
+  id text [pk, not null]
+  country text
+  state text
+  city text
+  zipCode text
+  line1 text
+  line2 text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_123408445 
+// collection name: helloworlds 
+// collection type: base 
+Table helloworlds {
+  id text [pk, not null]
+  hello text
+  created datetime
+  updated datetime
+}
+
+// 
+// collection id:   pbc_2109205374 
+// collection name: t1 
+// collection type: base 
+Table t1 {
+  id text [pk, not null]
+  hello text
+  created datetime
+  updated datetime
+  test_file file
+}
+
--- a/001_documentation/Requirements/REQ0006/schema.dbml.ai_draft
+++ b/001_documentation/Requirements/REQ0006/schema.dbml.ai_draft
@@ -1,215 +0,0 @@
-// LessonTypes stores different types of lessons
-// lesson_types, lesson_type
-Table LessonTypes {
-  // system field
-  id int [pk, increment] // unique identifier for the lesson type
-  created datetime [default: `now()`] // timestamp when the lesson type was created
-  updated datetime // timestamp when the lesson type was last updated
-  // value field
-  name varchar // name of the lesson type
-  type varchar // type category
-}
-
-// LessonCategories stores categories of lessons
-// lesson_categories, lesson_category
-Table LessonCategories {
-  // system field
-  id int [pk, increment] // unique identifier for the lesson category
-  created datetime [default: `now()`] // timestamp when the category was created
-  updated datetime // timestamp when the category was last updated
-  // value field
-  cat_name varchar // image file name
-  cat_image varchar // image representing the category
-  lesson_type_id integer [ref: > LessonTypes.id] // foreign key referencing LessonTypes.id
-}
-
-Table Helloworlds {
-  // system field
-  id int [pk, increment] // id field, increment
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-}
-
-Table Users {
-  // system field
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-
-  // value field
-  email varchar
-  emailVisibility boolean
-  verified boolean
-  name varchar
-  avatar blob
-}
-
-Table UserMetas {
-  // system field
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-
-  // value field
-  helloworld varchar
-  app_on_time_s integer
-  user_id integer [ref: > Users.id]
-}
-
-Table QuizCategories {
-  // system field
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-
-  // value field
-  cat_name varchar // category name
-  cat_image varchar // category image
-}
-
-// stores all questions of matching frenzy
-Table QuizMatchings {
-  // system field
-  id int [pk, increment] // id field, increment
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-
-  // value field
-  word varchar // modal answer
-  word_c varchar // question
-  cat_id integer [ref: > QuizCategories.id] // foreign key to QuizCategories.id
-}
-
-// QuizListening stores all listening quiz data
-Table QuizListenings {
-  // system field
-  id int [pk, increment] // id field, increment
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-
-  // value field
-  sound varchar // URL to the sound file
-  word varchar // The word in the quiz
-  cat_id integer [ref: > QuizCategories.id]
-}
-
-// stores all categories of connectives revision quiz
-Table QuizConnectivesCategories {
-  // system field
-  id int [pk, increment] // id field, increment
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-
-  // value field
-  cat_name varchar // category name
-  cat_image varchar // category image
-}
-
-// stores all questions of connectives revision quiz
-Table QuizConnectives {
-  // system field
-  id int [pk, increment] // id field, increment
-  created datetime [default: `now()`] // record create time
-  updated datetime // record update time
-
-  // value field
-  question_fh varchar // first half
-  question_sh varchar // second half
-  modal_ans varchar // modal ans
-  cat_id integer [ref: > QuizConnectivesCategories.id] // foreign key to QuizConnectivesCategories.id
-}
-
-// Lessons stores all lessons in the database
-Table Vocabularies {
-  // system field
-  id int [pk, increment] // unique identifier for the lesson
-  created datetime [default: `now()`] // timestamp when the lesson was created
-  updated datetime // timestamp when the lesson was last updated
-
-  // value field
-  image varchar // URL to the image associated with the lesson
-  sound varchar // URL to the sound file associated with the lesson
-  word varchar // The word in English
-  word_c varchar // The word in Chinese
-  sample_e varchar // Sample sentence in English using the word
-  sample_c varchar // Sample sentence in Chinese using the word
-  cat_id integer [ref: > LessonCategories.id] // foreign key referring to LessonCategories.id
-  category varchar // The category to which the lesson belongs
-  lesson_type_id integer [ref: > LessonTypes.id] // foreign key referring to LessonTypes.id
-}
-
-// Listening Practice Quiz Categories
-// store listening practice category, (LpCategories, LpCategory)
-Table QuizLPCategories {
-  // system fields
-  id text [pk] // changed from int to text to match PocketBase
-  created datetime [default: `now()`]
-  updated datetime
-
-  // value fields
-  cat_name varchar [presentable: true] // added presentable flag
-  cat_image file // changed from blob to file type
-  pos number // changed from integer to number
-  init_answer json
-}
-
-// Listening Practice Quiz Questions
-Table QuizLPQuestions {
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-  word varchar
-  sound blob
-  cat_id integer [ref: > QuizLPCategories.id]
-}
-
-// Matching Frenzy Quiz Categories
-Table QuizMFCategories {
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-  cat_name varchar
-  cat_image blob
-  pos integer
-  init_answer json
-}
-
-// Matching Frenzy Quiz Questions
-Table QuizMFQuestions {
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-  word varchar
-  word_c varchar
-  cat_id integer [ref: > QuizMFCategories.id]
-}
-
-// Connectives Revision Quiz Categories
-Table QuizCRCategories {
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-  cat_name varchar
-  cat_image blob
-  pos integer
-  init_answer json
-}
-
-// Connectives Revision Quiz Questions
-Table QuizCRQuestions {
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-  question_fh varchar
-  question_sh varchar
-  modal_ans varchar
-  cat_id integer [ref: > QuizCRCategories.id]
-}
-
-// Test table
-Table t1 {
-  id int [pk, increment]
-  created datetime [default: `now()`]
-  updated datetime
-  name varchar
-}
--- a/001_documentation/Requirements/REQ0006/schema.json
+++ b/001_documentation/Requirements/REQ0006/schema.json
@@ -304,6 +304,34 @@
        "presentable": false,
        "system": false,
        "type": "autodate"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text2058414169",
+        "max": 0,
+        "min": 0,
+        "name": "visible",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text1146066909",
+        "max": 0,
+        "min": 0,
+        "name": "phone",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
      }
    ],
    "indexes": [
@@ -1029,16 +1057,6 @@
        "system": false,
        "type": "text"
      },
-      {
-        "hidden": false,
-        "id": "json3182418120",
-        "maxSize": 0,
-        "name": "author",
-        "presentable": false,
-        "required": false,
-        "system": false,
-        "type": "json"
-      },
      {
        "hidden": false,
        "id": "json4225294584",
@@ -1096,6 +1114,77 @@
        "presentable": false,
        "system": false,
        "type": "autodate"
+      },
+      {
+        "cascadeDelete": false,
+        "collectionId": "pbc_1305841361",
+        "hidden": false,
+        "id": "relation704048736",
+        "maxSelect": 1,
+        "minSelect": 0,
+        "name": "to_user_id",
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "relation"
+      },
+      {
+        "cascadeDelete": false,
+        "collectionId": "pbc_1305841361",
+        "hidden": false,
+        "id": "relation556806202",
+        "maxSelect": 1,
+        "minSelect": 0,
+        "name": "from_user_id",
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "relation"
+      },
+      {
+        "cascadeDelete": false,
+        "collectionId": "pbc_1305841361",
+        "hidden": false,
+        "id": "relation3182418120",
+        "maxSelect": 1,
+        "minSelect": 0,
+        "name": "author",
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "relation"
+      },
+      {
+        "convertURLs": false,
+        "hidden": false,
+        "id": "editor4274335913",
+        "maxSize": 0,
+        "name": "content",
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "editor"
+      },
+      {
+        "hidden": false,
+        "id": "json1337919823",
+        "maxSize": 0,
+        "name": "company",
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "json"
+      },
+      {
+        "exceptDomains": null,
+        "hidden": false,
+        "id": "url917281265",
+        "name": "link",
+        "onlyDomains": null,
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "url"
      }
    ],
    "indexes": [],
@@ -1307,6 +1396,16 @@
        "presentable": false,
        "system": false,
        "type": "autodate"
+      },
+      {
+        "hidden": false,
+        "id": "json227240121",
+        "maxSize": 0,
+        "name": "init_answer",
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "json"
      }
    ],
    "indexes": [],
@@ -1651,6 +1750,20 @@
        "system": false,
        "type": "json"
      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text2058414169",
+        "max": 0,
+        "min": 0,
+        "name": "visible",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
      {
        "hidden": false,
        "id": "autodate2990389176",
@@ -1671,20 +1784,6 @@
        "system": false,
        "type": "autodate"
      },
-      {
-        "autogeneratePattern": "",
-        "hidden": false,
-        "id": "text2058414169",
-        "max": 0,
-        "min": 0,
-        "name": "visible",
-        "pattern": "",
-        "presentable": false,
-        "primaryKey": false,
-        "required": false,
-        "system": false,
-        "type": "text"
-      },
      {
        "autogeneratePattern": "",
        "hidden": false,
@@ -1793,26 +1892,6 @@
        "system": false,
        "type": "relation"
      },
-      {
-        "hidden": false,
-        "id": "autodate2990389176",
-        "name": "created",
-        "onCreate": true,
-        "onUpdate": false,
-        "presentable": false,
-        "system": false,
-        "type": "autodate"
-      },
-      {
-        "hidden": false,
-        "id": "autodate3332085495",
-        "name": "updated",
-        "onCreate": true,
-        "onUpdate": true,
-        "presentable": false,
-        "system": false,
-        "type": "autodate"
-      },
      {
        "autogeneratePattern": "",
        "hidden": false,
@@ -1915,6 +1994,26 @@
        "required": false,
        "system": false,
        "type": "editor"
+      },
+      {
+        "hidden": false,
+        "id": "autodate2990389176",
+        "name": "created",
+        "onCreate": true,
+        "onUpdate": false,
+        "presentable": false,
+        "system": false,
+        "type": "autodate"
+      },
+      {
+        "hidden": false,
+        "id": "autodate3332085495",
+        "name": "updated",
+        "onCreate": true,
+        "onUpdate": true,
+        "presentable": false,
+        "system": false,
+        "type": "autodate"
      }
    ],
    "indexes": [],
@@ -2083,6 +2182,20 @@
        "system": false,
        "type": "json"
      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text2058414169",
+        "max": 0,
+        "min": 0,
+        "name": "visible",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
      {
        "hidden": false,
        "id": "autodate2990389176",
@@ -2102,20 +2215,6 @@
        "presentable": false,
        "system": false,
        "type": "autodate"
-      },
-      {
-        "autogeneratePattern": "",
-        "hidden": false,
-        "id": "text2058414169",
-        "max": 0,
-        "min": 0,
-        "name": "visible",
-        "pattern": "",
-        "presentable": false,
-        "primaryKey": false,
-        "required": false,
-        "system": false,
-        "type": "text"
      }
    ],
    "indexes": [],
@@ -2247,6 +2346,16 @@
        "system": false,
        "thumbs": [],
        "type": "file"
+      },
+      {
+        "hidden": false,
+        "id": "json3915970527",
+        "maxSize": 0,
+        "name": "init_answer",
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "json"
      }
    ],
    "indexes": [],
@@ -2761,7 +2870,7 @@
        "id": "text4192936109",
        "max": 0,
        "min": 0,
-        "name": "helloworld",
+        "name": "address",
        "pattern": "",
        "presentable": false,
        "primaryKey": false,
@@ -2792,6 +2901,20 @@
        "system": false,
        "type": "relation"
      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text2744374011",
+        "max": 0,
+        "min": 0,
+        "name": "state",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
      {
        "hidden": false,
        "id": "autodate2990389176",
@@ -2812,20 +2935,6 @@
        "system": false,
        "type": "autodate"
      },
-      {
-        "autogeneratePattern": "",
-        "hidden": false,
-        "id": "text2744374011",
-        "max": 0,
-        "min": 0,
-        "name": "state",
-        "pattern": "",
-        "presentable": false,
-        "primaryKey": false,
-        "required": false,
-        "system": false,
-        "type": "text"
-      },
      {
        "hidden": false,
        "id": "file376926767",
@@ -2853,6 +2962,128 @@
        "required": false,
        "system": false,
        "type": "text"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text1579384326",
+        "max": 0,
+        "min": 0,
+        "name": "name",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "exceptDomains": null,
+        "hidden": false,
+        "id": "email3885137012",
+        "name": "email",
+        "onlyDomains": null,
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "email"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text1146066909",
+        "max": 0,
+        "min": 0,
+        "name": "phone",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text1337919823",
+        "max": 0,
+        "min": 0,
+        "name": "company",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text2020362641",
+        "max": 0,
+        "min": 0,
+        "name": "taxId",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text922858135",
+        "max": 0,
+        "min": 0,
+        "name": "timezone",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text3571151285",
+        "max": 0,
+        "min": 0,
+        "name": "language",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text1767278655",
+        "max": 0,
+        "min": 0,
+        "name": "currency",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "cascadeDelete": false,
+        "collectionId": "pbc_1509025625",
+        "hidden": false,
+        "id": "relation2115670734",
+        "maxSelect": 999,
+        "minSelect": 0,
+        "name": "billingAddress",
+        "presentable": false,
+        "required": false,
+        "system": false,
+        "type": "relation"
      }
    ],
    "indexes": [],
@@ -3025,6 +3256,34 @@
        "presentable": false,
        "system": false,
        "type": "autodate"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text2058414169",
+        "max": 0,
+        "min": 0,
+        "name": "visible",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
+      },
+      {
+        "autogeneratePattern": "",
+        "hidden": false,
+        "id": "text2363381545",
+        "max": 0,
+        "min": 0,
+        "name": "type",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": false,
+        "system": false,
+        "type": "text"
      }
    ],
    "indexes": [],
@@ -3428,11 +3687,11 @@
  },
  {
    "id": "pbc_1509025625",
-    "listRule": null,
-    "viewRule": null,
-    "createRule": null,
-    "updateRule": null,
-    "deleteRule": null,
+    "listRule": "",
+    "viewRule": "",
+    "createRule": "",
+    "updateRule": "",
+    "deleteRule": "",
    "name": "billingAddress",
    "type": "base",
    "fields": [
@@ -3622,11 +3881,11 @@
  },
  {
    "id": "pbc_2109205374",
-    "listRule": null,
-    "viewRule": null,
-    "createRule": null,
-    "updateRule": null,
-    "deleteRule": null,
+    "listRule": "",
+    "viewRule": "",
+    "createRule": "",
+    "updateRule": "",
+    "deleteRule": "",
    "name": "t1",
    "type": "base",
    "fields": [
--- a/001_documentation/Requirements/REQ0013/index.md
+++ b/001_documentation/Requirements/REQ0013/index.md
@@ -0,0 +1,11 @@
+---
+tags: cms
+---
+
+# cms dashboard
+
+cms
+
+## files
+
+T.B.A.
--- a/001_documentation/Requirements/REQ0014/index.md
+++ b/001_documentation/Requirements/REQ0014/index.md
@@ -0,0 +1,11 @@
+---
+tags: mobile
+---
+
+# mobile client
+
+mobile
+
+## files
+
+T.B.A.
--- a/001_documentation/Requirements/REQ0015/convert.js
+++ b/001_documentation/Requirements/REQ0015/convert.js
@@ -0,0 +1,86 @@
+//
+// # REQ0015:
+// ## PURPOSE:
+//
+// This is a script to convert `schema.json` exported from pocketbase to dbml formatted file `schema.dbml`
+//
+//
+
+const fs = require("fs");
+const path = require("path");
+// Load schema.json
+const schemaPath = path.join(process.cwd(), "schema.json");
+const schema = JSON.parse(fs.readFileSync(schemaPath, "utf8"));
+
+// Type mapping from PocketBase to DBML/SQL
+const typeMapping = {
+  text: "text",
+  number: "integer",
+  bool: "boolean",
+  email: "text",
+  url: "varchar",
+  date: "datetime",
+  select: "varchar",
+  json: "text",
+  file: "file",
+  password: "varchar",
+  relation: "integer", // Assuming relations are stored as integer IDs
+  autodate: "datetime",
+};
+
+function convertToDBML(schema) {
+  let dbml = "";
+  dbml = "// Generated at:  " + new Date().toISOString();
+  dbml = dbml + "\n\n\n";
+
+  let collectionIdToTableMapping = {};
+  for (const [idx, tableDef] of Object.entries(schema)) {
+    collectionIdToTableMapping[tableDef.id] = tableDef.name;
+  }
+
+  for (const [idx, tableDef] of Object.entries(schema)) {
+    console.log({ idx });
+    dbml += `// \n`;
+    dbml += `// collection id:   ${tableDef.id} \n`;
+    dbml += `// collection name: ${tableDef.name} \n`;
+    dbml += `// collection type: ${tableDef.type} \n`;
+    dbml += `Table ${tableDef.name} {\n`;
+
+    for (const field of tableDef.fields) {
+      // Get field type
+      let fieldType = typeMapping[field.type] || "text";
+
+      // Handle special cases
+      if (field.type === "number" && field.options?.max === 1) {
+        fieldType = "boolean";
+      }
+
+      // Build field definition
+      let line = `  ${field.name} ${fieldType}`;
+
+      // Add constraints
+      const constraints = [];
+      if (field.name === "id" || field.primary) constraints.push("pk");
+      if (field.required) constraints.push("not null");
+      if (constraints.length > 0) line += ` [${constraints.join(", ")}]`;
+
+      if (field.collectionId) {
+        line += ` [ref: > ${
+          collectionIdToTableMapping[field.collectionId]
+        }.id] // ${field.id}`;
+      }
+
+      dbml += `${line}\n`;
+      console.log({ line });
+    }
+
+    dbml += "}\n\n";
+  }
+
+  return dbml;
+}
+
+// Convert and save
+const dbmlOutput = convertToDBML(schema);
+fs.writeFileSync("schema.dbml", dbmlOutput);
+console.log("DBML file generated successfully!");
--- a/001_documentation/Requirements/REQ0015/index.md
+++ b/001_documentation/Requirements/REQ0015/index.md
@@ -0,0 +1,9 @@
+---
+tags: mobile, cms, db, schema
+---
+
+# pocketbase json schema to dbml converter
+
+## description
+
+to generate a `schema.dbml` form `schema.json` exported from pocketbase
--- a/001_documentation/Requirements/REQ0015/schema.dbml
+++ b/001_documentation/Requirements/REQ0015/schema.dbml
@@ -0,0 +1,18 @@
+// Generated at:  2025-05-06T06:24:44.009Z
+
+
+// 
+// collection id:   pbc_3142635823 
+// collection name: helloworld 
+// collection type: auth 
+Table helloworld {
+  id text [pk, not null]
+  password varchar [not null]
+  tokenKey text [not null]
+  email text [not null]
+  emailVisibility boolean
+  verified boolean
+  created datetime
+  updated datetime
+}
+
--- a/001_documentation/Requirements/REQ0015/schema.json
+++ b/001_documentation/Requirements/REQ0015/schema.json
@@ -0,0 +1,174 @@
+[
+  {
+    "id": "pbc_3142635823",
+    "listRule": null,
+    "viewRule": null,
+    "createRule": null,
+    "updateRule": null,
+    "deleteRule": null,
+    "name": "helloworld",
+    "type": "auth",
+    "fields": [
+      {
+        "autogeneratePattern": "[a-z0-9]{15}",
+        "hidden": false,
+        "id": "text3208210256",
+        "max": 15,
+        "min": 15,
+        "name": "id",
+        "pattern": "^[a-z0-9]+$",
+        "presentable": false,
+        "primaryKey": true,
+        "required": true,
+        "system": true,
+        "type": "text"
+      },
+      {
+        "cost": 0,
+        "hidden": true,
+        "id": "password901924565",
+        "max": 0,
+        "min": 8,
+        "name": "password",
+        "pattern": "",
+        "presentable": false,
+        "required": true,
+        "system": true,
+        "type": "password"
+      },
+      {
+        "autogeneratePattern": "[a-zA-Z0-9]{50}",
+        "hidden": true,
+        "id": "text2504183744",
+        "max": 60,
+        "min": 30,
+        "name": "tokenKey",
+        "pattern": "",
+        "presentable": false,
+        "primaryKey": false,
+        "required": true,
+        "system": true,
+        "type": "text"
+      },
+      {
+        "exceptDomains": null,
+        "hidden": false,
+        "id": "email3885137012",
+        "name": "email",
+        "onlyDomains": null,
+        "presentable": false,
+        "required": true,
+        "system": true,
+        "type": "email"
+      },
+      {
+        "hidden": false,
+        "id": "bool1547992806",
+        "name": "emailVisibility",
+        "presentable": false,
+        "required": false,
+        "system": true,
+        "type": "bool"
+      },
+      {
+        "hidden": false,
+        "id": "bool256245529",
+        "name": "verified",
+        "presentable": false,
+        "required": false,
+        "system": true,
+        "type": "bool"
+      },
+      {
+        "hidden": false,
+        "id": "autodate2990389176",
+        "name": "created",
+        "onCreate": true,
+        "onUpdate": false,
+        "presentable": false,
+        "system": true,
+        "type": "autodate"
+      },
+      {
+        "hidden": false,
+        "id": "autodate3332085495",
+        "name": "updated",
+        "onCreate": true,
+        "onUpdate": true,
+        "presentable": false,
+        "system": true,
+        "type": "autodate"
+      }
+    ],
+    "indexes": [
+      "CREATE UNIQUE INDEX `idx_tokenKey_pbc_3142635823` ON `_superusers` (`tokenKey`)",
+      "CREATE UNIQUE INDEX `idx_email_pbc_3142635823` ON `_superusers` (`email`) WHERE `email` != ''"
+    ],
+    "system": true,
+    "authRule": "",
+    "manageRule": null,
+    "authAlert": {
+      "enabled": true,
+      "emailTemplate": {
+        "subject": "Login from a new location",
+        "body": "<p>Hello,</p>\n<p>We noticed a login to your {APP_NAME} account from a new location.</p>\n<p>If this was you, you may disregard this email.</p>\n<p><strong>If this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.</strong></p>\n<p>\n  Thanks,<br/>\n  {APP_NAME} team\n</p>"
+      }
+    },
+    "oauth2": {
+      "mappedFields": {
+        "id": "",
+        "name": "",
+        "username": "",
+        "avatarURL": ""
+      },
+      "enabled": false
+    },
+    "passwordAuth": {
+      "enabled": true,
+      "identityFields": [
+        "email"
+      ]
+    },
+    "mfa": {
+      "enabled": false,
+      "duration": 1800,
+      "rule": ""
+    },
+    "otp": {
+      "enabled": false,
+      "duration": 180,
+      "length": 8,
+      "emailTemplate": {
+        "subject": "OTP for {APP_NAME}",
+        "body": "<p>Hello,</p>\n<p>Your one-time password is: <strong>{OTP}</strong></p>\n<p><i>If you didn't ask for the one-time password, you can ignore this email.</i></p>\n<p>\n  Thanks,<br/>\n  {APP_NAME} team\n</p>"
+      }
+    },
+    "authToken": {
+      "duration": 86400
+    },
+    "passwordResetToken": {
+      "duration": 1800
+    },
+    "emailChangeToken": {
+      "duration": 1800
+    },
+    "verificationToken": {
+      "duration": 259200
+    },
+    "fileToken": {
+      "duration": 180
+    },
+    "verificationTemplate": {
+      "subject": "Verify your {APP_NAME} email",
+      "body": "<p>Hello,</p>\n<p>Thank you for joining us at {APP_NAME}.</p>\n<p>Click on the button below to verify your email address.</p>\n<p>\n  <a class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\">Verify</a>\n</p>\n<p>\n  Thanks,<br/>\n  {APP_NAME} team\n</p>"
+    },
+    "resetPasswordTemplate": {
+      "subject": "Reset your {APP_NAME} password",
+      "body": "<p>Hello,</p>\n<p>Click on the button below to reset your password.</p>\n<p>\n  <a class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\">Reset password</a>\n</p>\n<p><i>If you didn't ask to reset your password, you can ignore this email.</i></p>\n<p>\n  Thanks,<br/>\n  {APP_NAME} team\n</p>"
+    },
+    "confirmEmailChangeTemplate": {
+      "subject": "Confirm your {APP_NAME} new email address",
+      "body": "<p>Hello,</p>\n<p>Click on the button below to confirm your new email address.</p>\n<p>\n  <a class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\">Confirm new email</a>\n</p>\n<p><i>If you didn't ask to change your email address, you can ignore this email.</i></p>\n<p>\n  Thanks,<br/>\n  {APP_NAME} team\n</p>"
+    }
+  }
+]
--- a/001_documentation/Requirements/REQ0016/index.md
+++ b/001_documentation/Requirements/REQ0016/index.md
@@ -0,0 +1,39 @@
+---
+tags: cms, login-flow
+---
+
+# CMS login flow
+
+## description
+
+```mermaid
+graph TD;
+  Start-->A;
+  A-->B;
+  B-->C;
+  B-->D;
+  D-->E;
+  E-->F;
+  C-->G;
+  G-->A
+
+  F-->End;
+
+  A[greeting, asking username and password]
+  B[check if username and password is valid]
+  C[pasword failed]
+  D[pasword ok]
+  E[login success]
+  F[redirect to '/dashboard']
+
+  G[prompt user wrong username and password]
+
+  Start((start));
+  End((end))
+```
+
+## test
+
+![alt text](test.gif)
+
+## relation
--- a/001_documentation/Requirements/REQ0016/test.gif
+++ b/001_documentation/Requirements/REQ0016/test.gif
--- a/001_documentation/Requirements/REQ0017/image.png
+++ b/001_documentation/Requirements/REQ0017/image.png
--- a/001_documentation/Requirements/REQ0017/index.md
+++ b/001_documentation/Requirements/REQ0017/index.md
@@ -0,0 +1,9 @@
+---
+tags: mobile, lesson
+---
+
+# lesson page documentation
+
+it should have a lesson page
+
+![alt text](image.png)
--- a/001_documentation/Requirements/REQ0018/index.md
+++ b/001_documentation/Requirements/REQ0018/index.md
@@ -0,0 +1,7 @@
+---
+tags: mobile, cms, db
+---
+
+# family photo of frameworks
+
+it should have a family photo of used framework
--- a/001_documentation/Requirements/REQ0019/index.md
+++ b/001_documentation/Requirements/REQ0019/index.md
@@ -0,0 +1,43 @@
+---
+tags: architecture,mobile, cms, db
+---
+
+# System architecture
+
+## Description
+
+it should have a family photo of used framework
+
+## Diagram
+
+```mermaid {align="center"}
+
+architecture-beta
+  group running_config(logos:aws-opsworks)[running_config]
+    service db(database)[pocketbase] in running_config
+
+    service tra1(internet)[incoming traffic 3000] in running_config
+    service cms(logos:nextjs)[next app] in running_config
+
+    service tra2(internet)[incoming traffic 5173] in running_config
+    service ionic(logos:ionic)[ionic app] in running_config
+
+    tra1:R --> L:cms
+    cms:R --> L:db
+
+    tra2:R --> L:ionic
+    ionic:R --> B:db
+
+  %% group planning(logos:aws-lambda)[planning]
+  %%   service api_ts(logos:aws-lambda)[api_ts] in planning
+  %%   service pg_db(logos:postgresql)[pg_db] in planning
+  %%   ui:R --> L:api_ts
+  %%   ionic:R --> L:api_ts
+  %%   api_ts:B --> T:pg_db
+
+  %%   service task_server(logos:aws-lambda)[task_server] in planning
+  %%   api_ts:R --> L:task_server
+    %% service marketing(logos:wordpress-icon)[marketing] in planning
+
+
+```
--- a/001_documentation/Requirements/REQ0020/index.md
+++ b/001_documentation/Requirements/REQ0020/index.md
@@ -0,0 +1,41 @@
+---
+tags: mobile, login-flow
+---
+
+# Mobile login flow
+
+## description
+
+```mermaid
+graph TD;
+  Start-->A;
+  A-->B;
+  B-->C;
+  B-->D;
+  D-->E;
+  E-->F;
+  C-->G;
+  G-->A
+
+  F-->End;
+
+  A[greeting, asking username and password]
+  B[check if username and password is valid]
+  C[pasword failed]
+  D[pasword ok]
+  E[login success]
+  F[redirect to '/dashboard']
+
+  G[prompt user wrong username and password]
+
+  Start((start));
+  End((end))
+```
+
+## test
+
+![alt text](test.gif)
+
+### relations
+
+[REQ0016](../REQ0016/index.md)
--- a/001_documentation/Requirements/REQ0020/test.gif
+++ b/001_documentation/Requirements/REQ0020/test.gif
--- a/001_documentation/Requirements/REQ0021/index.md
+++ b/001_documentation/Requirements/REQ0021/index.md
@@ -0,0 +1,44 @@
+---
+tags: docker
+---
+
+# description
+
+docker and public endpoint
+
+## strategy
+
+```mermaid
+graph LR
+  A["next build"]
+  B["docker build"]
+  A --> B --> deploy --> run
+```
+
+1. build on develop machine
+1. docker build on develop machine (include source code)
+1. push image to production machine
+1. run image to production machine
+
+## endpoint table
+
+| function | address                                                                      |      | status                                               |
+| -------- | ---------------------------------------------------------------------------- | ---- | ---------------------------------------------------- |
+| DB       | [https://demo_ls_db.louislabs.com](https://demo_ls_db.louislabs.com)         | 3013 | ![](https://status.iamon99.com/api/badge/108/uptime) |
+| cms      | [https://demo_ls_cms.louislabs.com](https://demo_ls_cms.louislabs.com)       | 3011 | ![](https://status.iamon99.com/api/badge/109/uptime) |
+| mobile   | [https://demo_ls_mobile.louislabs.com](https://demo_ls_mobile.louislabs.com) | 3012 | ![](https://status.iamon99.com/api/badge/110/uptime) |
+| T.B.A.   | T.B.A.                                                                       | 3014 |                                                      |
+| T.B.A.   | T.B.A.                                                                       | 3015 |                                                      |
+| T.B.A.   | T.B.A.                                                                       | 3016 |                                                      |
+| T.B.A.   | T.B.A.                                                                       | 3017 |                                                      |
+| T.B.A.   | T.B.A.                                                                       | 3018 |                                                      |
+| T.B.A.   | T.B.A.                                                                       | 3019 |                                                      |
+| T.B.A.   | T.B.A.                                                                       | 3010 |                                                      |
+
+## status panel
+
+[https://status.iamon99.com/status/demo-ls](https://status.iamon99.com/status/demo-ls)
+
+## TODO
+
+pending separated ssl certificate, currently using shared affine.louislabs.com
--- a/001_documentation/Requirements/index.md
+++ b/001_documentation/Requirements/index.md
@@ -1,50 +1,25 @@
 # Requirements Index

-## REQ0001: project overview
-
-[View Requirement](./REQ0001/index.md)
-
-## REQ0002: lesson page documentation
-
-[View Requirement](./REQ0002/index.md)
-
-## REQ0003: quiz page documentation
-
-[View Requirement](./REQ0003/index.md)
-
-## REQ0004: record page documentation
-
-[View Requirement](./REQ0004/index.md)
-
-## REQ0005: settings page documentation
-
-[View Requirement](./REQ0005/index.md)
-
-## REQ0006: db schema design
-
-[View Requirement](./REQ0006/index.md)
-
-## REQ0007: testing of mobile app home
-
-[View Requirement](./REQ0007/index.md)
-
-## REQ0008: schema design
-
-[View Requirement](./REQ0008/index.md)
-
-## REQ0009: loading screen
-
-[View Requirement](./REQ0009/index.md)
-
-## REQ0010: user friendly error messages
-
-[View Requirement](./REQ0010/index.md)
-
-## REQ0011: developer friendly error messages
-
-[View Requirement](./REQ0011/index.md)
-
-## REQ0012: cms navigation system
-
-[View Requirement](./REQ0012/index.md)
-
+- [REQ0001: project overview](./REQ0001/index.md)
+- [REQ0002: time tracking](./REQ0002/index.md)
+- [REQ0003: quiz page documentation](./REQ0003/index.md)
+- [REQ0004: record page documentation](./REQ0004/index.md)
+- [REQ0005: settings page documentation](./REQ0005/index.md)
+- [REQ0006: task](./REQ0006/008_update_dbml_from_json.md)
+- [REQ0006: GUIDELINES](./REQ0006/_GUIDELINE.md)
+- [REQ0006: db schema design](./REQ0006/index.md)
+- [REQ0007: testing of mobile app home](./REQ0007/index.md)
+- [REQ0008: schema design](./REQ0008/index.md)
+- [REQ0009: loading screen](./REQ0009/index.md)
+- [REQ0010: user friendly error messages](./REQ0010/index.md)
+- [REQ0011: developer friendly error messages](./REQ0011/index.md)
+- [REQ0012: cms navigation system](./REQ0012/index.md)
+- [REQ0013: cms dashboard](./REQ0013/index.md)
+- [REQ0014: mobile client](./REQ0014/index.md)
+- [REQ0015: pocketbase json schema to dbml converter](./REQ0015/index.md)
+- [REQ0016: CMS login flow](./REQ0016/index.md)
+- [REQ0017: lesson page documentation](./REQ0017/index.md)
+- [REQ0018: family photo of frameworks](./REQ0018/index.md)
+- [REQ0019: System architecture](./REQ0019/index.md)
+- [REQ0020: Mobile login flow](./REQ0020/index.md)
+- [REQ0021: description](./REQ0021/index.md)
--- a/001_documentation/Requirements/update.sh
+++ b/001_documentation/Requirements/update.sh
@@ -0,0 +1,5 @@
+#!/usr/bin/env bash
+
+set -ex
+
+npx nodemon --delay 0.1 --ext md,js --ignore ./index.md --exec "node ./update_req_index.js"
--- a/001_documentation/Requirements/update_req_index.js
+++ b/001_documentation/Requirements/update_req_index.js
@@ -36,8 +36,8 @@ async function updateIndex() {
        const heading = extractH1(content);

        if (heading) {
-          indexContent += `## ${dir}: ${heading}\n\n`;
-          indexContent += `[View Requirement](./${dir}/${file})\n\n`;
+          indexContent += `- [${dir}: ${heading}](./${dir}/${file})\n`;
+          // indexContent += `[View Requirement](./${dir}/${file})\n\n`;
        }
      }
    }
--- a/001_documentation/documentation.code-workspace
+++ b/001_documentation/documentation.code-workspace
@@ -0,0 +1,11 @@
+{
+  "folders": [
+    {
+      "path": "."
+    },
+    {
+      "path": "../003_test"
+    }
+  ],
+  "settings": {}
+}
--- a/001_documentation/o7f74lN9wZ.mp4
+++ b/001_documentation/o7f74lN9wZ.mp4
--- a/002_source/.env
+++ b/002_source/.env
@@ -0,0 +1,14 @@
+# THIS IS env file for use with docker-compose.yml
+
+# cms
+
+# doc
+
+# ionic_mobile
+
+# api_ts
+
+# pocketbase
+PB_HOSTNAME=pocketbase
+PB_USERNAME=admin@123.com
+PB_PASSWORD=Aa12345678
--- a/002_source/.gitignore
+++ b/002_source/.gitignore
@@ -0,0 +1,6 @@
+**/*.del
+**/*.log
+**/_archive
+**/_del
+
+**/*copy*
--- a/002_source/README.md
+++ b/002_source/README.md
@@ -0,0 +1,74 @@
+# README
+
+## to start production
+
+```bash
+# start docker before hand
+$ ./dc_build.sh
+
+$ ./dc_up.sh
+```
+
+## to start develop
+
+```bash
+#
+$ ./dc_build.sh
+$ ./dc_dev.sh
+$ docker compose -f docker-compose.yml -f docker-compose.dev.yml up -d pocketbase api_ts --remove-orphans
+$ docker compose logs -f pocketbase api_ts
+```
+
+## test api endpoint
+
+```bash
+# browse to http://localhost:3000/helloworld
+```
+
+```bash
+# start docker before hand
+
+$ cd 002_source
+$ ./dev.sh
+
+# docker containers up
+```
+
+---
+
+## deprecated
+
+```bash
+# mobile
+$ cd 002_source/mobile
+$ pnpm run dev
+
+# cms
+$ cd 002_source/cms
+$ npm run dev
+```
+
+ideation
+prototyping
+testing
+production deployment
+evaluation
+monitoring
+
+## addresses
+
+```
+mobile:
+http://localhost:5173
+
+pocketbase:
+http://localhost:8090/_
+
+cms:
+http://localhost:3000
+
+documentation
+http://localhost:3001
+```
+
+extend to vocabularies
--- a/002_source/cms/.dockerignore
+++ b/002_source/cms/.dockerignore
@@ -0,0 +1,40 @@
+# Ignore all files and directories by default
+
+-
+
+# Except for the following:
+
+!.dockerignore
+!.gitignore
+!.env.example
+!.git/
+!.env
+!.vscode/
+!.idea/
+
+# Node.js specific
+
+node_modules/
+
+# Build artifacts
+
+dist/
+build/
+
+# Logs
+
+logs/
+\*.log
+
+# Environment files
+
+.env\*
+
+# Cache files
+
+\*.cache
+
+# OS generated files
+
+.DS_Store
+Thumbs.db
--- a/002_source/cms/.env.development
+++ b/002_source/cms/.env.development
@@ -58,4 +58,4 @@ NEXT_PUBLIC_MAPBOX_API_KEY=
 # Google Tag Manager
 NEXT_PUBLIC_GOOGLE_TAG_MANAGER_ID=

-NEXT_PUBLIC_POCKETBASE_URL=http://localhost:8090
+NEXT_PUBLIC_POCKETBASE_URL=http://192.168.222.199:8090
--- a/002_source/cms/.eslintrc.js
+++ b/002_source/cms/.eslintrc.js
@@ -82,7 +82,14 @@ module.exports = {
    'eslintreact/jsx-sort-props': 'off',
    'react/jsx-sort-props': 'off',
  },
-  ignorePatterns: ['**/*del', '**/*bak', '**/*copy.*', '**/*copy*.*'],
+  ignorePatterns: [
+    '**/*.del',
+    '**/*.bak',
+    '**/*copy.*',
+    '**/*copy*.*',
+    '**/*draft*/**',
+    //
+  ],
  overrides: [
    {
      // override to ignore no-def for `describe`, `it`, and `expect`
--- a/002_source/cms/.gitignore
+++ b/002_source/cms/.gitignore
@@ -3,6 +3,8 @@
 **/*log
 **/*tmp

+.pnpm-store
+
 .env
 .env.production

--- a/002_source/cms/Dockerfile
+++ b/002_source/cms/Dockerfile
@@ -0,0 +1,17 @@
+# Use official Node 18 base image
+FROM node:22-slim
+
+# Install pnpm globally
+RUN npm install -g pnpm
+
+# Copy your application code (optional, comment out if not needed)
+COPY . /app
+
+RUN cd /app && pnpm i
+RUN cd /app && pnpm run build
+
+# Set working directory
+WORKDIR /app
+
+# Default command (optional)
+CMD ["./scripts/docker/entrypoint.sh"]
--- a/002_source/cms/cms-letter_soup.code-workspace
+++ b/002_source/cms/cms-letter_soup.code-workspace
--- a/002_source/cms/package.json
+++ b/002_source/cms/package.json
@@ -7,10 +7,13 @@
    "node": "==22"
  },
  "scripts": {
-    "dev": "next dev",
+    "dev": "next dev -H 0.0.0.0",
    "build": "next build",
    "build:w": "pnpx nodemon --ext ts,tsx,json,mjs,js,jsx --delay 15 --exec \"pnpm run build\"",
-    "start": "next start",
+    "docker:push": "docker push 192.168.10.61:5000/demo_ls_cms ",
+    "docker:build": "docker build -t 192.168.10.61:5000/demo_ls_cms .",
+    "build:docker": "pnpm run build && pnpm run docker:build && pnpm run docker:push",
+    "start": "next start -H 0.0.0.0",
    "lint": "next lint --quiet",
    "lint:fix": "next lint --fix",
    "lint:w": "pnpx nodemon --ext ts,tsx,json,mjs,js,jsx --delay 5 --exec \"pnpm run lint\"",
@@ -117,4 +120,4 @@
      "protobufjs"
    ]
  }
-}
+}
--- a/002_source/cms/prettier.config.mjs
+++ b/002_source/cms/prettier.config.mjs
@@ -29,7 +29,8 @@ const config = {
    '^[./]',
  ],
  plugins: [
-    // '@ianvs/prettier-plugin-sort-imports'
+    '@ianvs/prettier-plugin-sort-imports',
+    //
  ],
  overrides: [
    {
--- a/002_source/cms/public/assets/logo-github.svg
+++ b/002_source/cms/public/assets/logo-github.svg
@@ -0,0 +1 @@
+<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 16 16"><path fill="currentColor" d="M8 0c4.42 0 8 3.58 8 8a8.01 8.01 0 0 1-5.45 7.59c-.4.08-.55-.17-.55-.38c0-.27.01-1.13.01-2.2c0-.75-.25-1.23-.54-1.48c1.78-.2 3.65-.88 3.65-3.95c0-.88-.31-1.59-.82-2.15c.08-.2.36-1.02-.08-2.12c0 0-.67-.22-2.2.82c-.64-.18-1.32-.27-2-.27s-1.36.09-2 .27c-1.53-1.03-2.2-.82-2.2-.82c-.44 1.1-.16 1.92-.08 2.12c-.51.56-.82 1.28-.82 2.15c0 3.06 1.86 3.75 3.64 3.95c-.23.2-.44.55-.51 1.07c-.46.21-1.61.55-2.33-.66c-.15-.24-.6-.83-1.23-.82c-.67.01-.27.38.01.53c.34.19.73.9.82 1.13c.16.45.68 1.31 2.69.94c0 .67.01 1.3.01 1.49c0 .21-.15.45-.55.38A7.995 7.995 0 0 1 0 8c0-4.42 3.58-8 8-8"/></svg>
--- a/002_source/cms/public/locales/dev/sign_in.json
+++ b/002_source/cms/public/locales/dev/sign_in.json
@@ -0,0 +1,31 @@
+{
+  "sign-in": "Sign in / 登入",
+  "dont-have-an-account": "Don't have an account ?",
+  "continue-with_fh": "以",
+  "continue-with_sh": "繼續",
+  "forgot-password": "Forgot password",
+  "user": "用戶名稱",
+  "password": "密碼",
+  "email-address": "用戶電郵",
+  "first-name-is-required": "名字是必填项",
+  "last-name-is-required": "姓氏不能为空",
+  "email-is-required": "邮箱不能为空",
+  "password-should-be-at-least-6-characters": "密码至少需要6个字符",
+  "you-must-accept-the-terms-and-conditions": "您必须接受条款和条件",
+  "sign-up": "注册",
+  "already-have-an-account": "已有账号？",
+  "or": "或",
+  "create-account": "创建账号",
+  "created-users-are-not-persisted": "已创建的用户不会被保存",
+  "i-have-read-the": "我已阅读",
+  "terms-and-conditions": "用户协议和隐私政策",
+  "e.g.": "例如:",
+  "first-name": "名",
+  "last-name": "姓",
+  "hello": "world",
+  "welcome-title": "Welcome to devias kit pro",
+  "welcome-notes": "A professional template that comes with ready-to-use MUI components developed with one common goal in mind, help you build faster & beautiful applications.",
+  "reset-password": "重置密码",
+  "back-to-login": "返回登录",
+  "send-recovery-link": "发送恢复链接"
+}
--- a/002_source/cms/scripts/003_build_w.sh
+++ b/002_source/cms/scripts/003_build_w.sh
@@ -3,5 +3,11 @@
 set -ex

 reset
-rm -rf .next
+
+# rm -rf .next
+
+# pnpm run typecheck
+# pnpm run lint
+
+# echo "check ok"
 pnpm run build
--- a/002_source/cms/scripts/docker/entrypoint.sh
+++ b/002_source/cms/scripts/docker/entrypoint.sh
@@ -1,15 +1,19 @@
 #!/usr/bin/env bash

-# set -x
+set -x

-# nvm use 20
-nvm alias default 18
-nvm use default
-node -v
+while true; do
+  pnpm run start

-npm i -D
+  echo "command restarted"

-npm run dev
+  sleep 5
+
+done
+
+# pnpm i -D
+
+# pnpm run start

 # while true; do
 #     if [ "$NODE_ENV" = "development" ]; then
--- a/002_source/cms/src/.vscode/settings.json
+++ b/002_source/cms/src/.vscode/settings.json
@@ -1,3 +1,10 @@
 {
-  "git.ignoreLimitWarning": true
-}
+  "git.ignoreLimitWarning": true,
+  "todo-tree.filtering.excludeGlobs": [
+    "**/node_modules/*/**",
+    "**/*.bundle.*",
+    "**/.next/*/**",
+    "**/dist/*/**",
+    "**/build/*/**",
+  ],
+}
--- a/002_source/cms/src/tests/app/_helloworld/page.test.tsx
+++ b/002_source/cms/src/tests/app/_helloworld/page.test.tsx
@@ -1,21 +0,0 @@
-/// <reference types="jest" />
-import '@testing-library/jest-dom';
-import { render, screen } from '@testing-library/react';
-import Page from '@/app/_helloworld/page';
-
-// Mock the translation hook
-jest.mock('react-i18next', () => ({
-  useTranslation: () => ({
-    t: (key: string) => key,
-  }),
-}));
-
-describe('Page', () => {
-  it('renders a heading', () => {
-    render(<Page hello={'world'} />);
-
-    const heading = screen.getByRole('heading', { level: 1 });
-
-    expect(heading).toBeInTheDocument();
-  });
-});
--- a/002_source/cms/src/tests/snapshot.js
+++ b/002_source/cms/src/tests/snapshot.js
@@ -1,9 +0,0 @@
-import { render } from '@testing-library/react';
-
-// CUT = Component Under Test
-import CUT from '../components/_helloworld';
-
-it('renders homepage unchanged', () => {
-  const { container } = render(<CUT />);
-  expect(container).toMatchSnapshot();
-});
--- a/002_source/cms/src/app/dashboard/Sample/_repomix.md
+++ b/002_source/cms/src/app/dashboard/Sample/_repomix.md
--- a/002_source/cms/src/app/dashboard/Sample/repomix-output.xml
+++ b/002_source/cms/src/app/dashboard/Sample/repomix-output.xml
@@ -1,558 +0,0 @@
-This file is a merged representation of the entire codebase, combined into a single document by Repomix.
-
-<file_summary>
-This section contains a summary of this file.
-
-<purpose>
-This file contains a packed representation of the entire repository's contents.
-It is designed to be easily consumable by AI systems for analysis, code review,
-or other automated processes.
-</purpose>
-
-<file_format>
-The content is organized as follows:
-1. This summary section
-2. Repository information
-3. Directory structure
-4. Repository files, each consisting of:
-  - File path as an attribute
-  - Full contents of the file
-</file_format>
-
-<usage_guidelines>
- This file should be treated as read-only. Any changes should be made to the
-  original repository files, not this packed version.
- When processing this file, use the file path to distinguish
-  between different files in the repository.
- Be aware that this file may contain sensitive information. Handle it with
-  the same level of security as you would the original repository.
-</usage_guidelines>
-
-<notes>
- Some files may have been excluded based on .gitignore rules and Repomix's configuration
- Binary files are not included in this packed representation. Please refer to the Repository Structure section for a complete list of file paths, including binary files
- Files matching patterns in .gitignore are excluded
- Files matching default ignore patterns are excluded
- Files are sorted by Git change count (files with more changes are at the bottom)
-</notes>
-
-<additional_info>
-
-</additional_info>
-
-</file_summary>
-
-<directory_structure>
-AddressCard/
-  index.tsx
-  SampleAddresses.tsx
-BasicDetailCard/
-  index.tsx
-Notifications/
-  index.tsx
-  type.d.ts
-PaymentCard/
-  index.tsx
-  SamplePayments.tsx
-SecurityCard/
-  index.tsx
-TitleCard/
-  index.tsx
-Helloworld.tsx
-</directory_structure>
-
-<files>
-This section contains the contents of the repository's files.
-
-<file path="AddressCard/index.tsx">
-'use client';
-
-import * as React from 'react';
-import Avatar from '@mui/material/Avatar';
-import Button from '@mui/material/Button';
-import Card from '@mui/material/Card';
-import CardContent from '@mui/material/CardContent';
-import CardHeader from '@mui/material/CardHeader';
-import Grid from '@mui/material/Unstable_Grid2';
-import { House as HouseIcon } from '@phosphor-icons/react/dist/ssr/House';
-import { Plus as PlusIcon } from '@phosphor-icons/react/dist/ssr/Plus';
-import { useTranslation } from 'react-i18next';
-
-import type { Address } from '@/types/Address';
-import { ShippingAddress } from '@/components/dashboard/lp/categories/shipping-address';
-
-import { SampleAddresses } from './SampleAddresses';
-
-export default function SampleAddressCard(): React.JSX.Element {
-  const { t } = useTranslation();
-  return (
-    <Card>
-      <CardHeader
-        action={
-          <Button
-            color="secondary"
-            startIcon={<PlusIcon />}
-          >
-            {t('list.add')}
-          </Button>
-        }
-        avatar={
-          <Avatar>
-            <HouseIcon fontSize="var(--Icon-fontSize)" />
-          </Avatar>
-        }
-        title={t('list.shipping-addresses')}
-      />
-      <CardContent>
-        <Grid
-          container
-          spacing={3}
-        >
-          {(SampleAddresses satisfies Address[]).map((address) => (
-            <Grid
-              key={address.id}
-              md={6}
-              xs={12}
-            >
-              <ShippingAddress address={address} />
-            </Grid>
-          ))}
-        </Grid>
-      </CardContent>
-    </Card>
-  );
-}
-</file>
-
-<file path="AddressCard/SampleAddresses.tsx">
-'use client';
-
-import type { Address } from '@/types/Address';
-
-export const SampleAddresses: Address[] = [
-  {
-    id: 'ADR-001',
-    country: 'United States',
-    state: 'Michigan',
-    city: 'Lansing',
-    zipCode: '48933',
-    street: '480 Haven Lane',
-    primary: true,
-  },
-  {
-    id: 'ADR-002',
-    country: 'United States',
-    state: 'Missouri',
-    city: 'Springfield',
-    zipCode: '65804',
-    street: '4807 Lighthouse Drive',
-  },
-];
-</file>
-
-<file path="BasicDetailCard/index.tsx">
-'use client';
-
-import * as React from 'react';
-import { useRouter } from 'next/navigation';
-import Avatar from '@mui/material/Avatar';
-import Card from '@mui/material/Card';
-import CardHeader from '@mui/material/CardHeader';
-import Chip from '@mui/material/Chip';
-import Divider from '@mui/material/Divider';
-import IconButton from '@mui/material/IconButton';
-import LinearProgress from '@mui/material/LinearProgress';
-import Stack from '@mui/material/Stack';
-import Typography from '@mui/material/Typography';
-import { PencilSimple as PencilSimpleIcon } from '@phosphor-icons/react/dist/ssr/PencilSimple';
-import { User as UserIcon } from '@phosphor-icons/react/dist/ssr/User';
-import { useTranslation } from 'react-i18next';
-
-import { PropertyItem } from '@/components/core/property-item';
-import { PropertyList } from '@/components/core/property-list';
-
-export default function BasicDetailCard({
-  lpCatId,
-  handleEditClick,
-}: {
-  lpCatId: string;
-  handleEditClick: () => void;
-}): React.JSX.Element {
-  const { t } = useTranslation();
-
-  return (
-    <Card>
-      <CardHeader
-        action={
-          <IconButton
-            onClick={() => {
-              handleEditClick();
-            }}
-          >
-            <PencilSimpleIcon />
-          </IconButton>
-        }
-        avatar={
-          <Avatar>
-            <UserIcon fontSize="var(--Icon-fontSize)" />
-          </Avatar>
-        }
-        title={t('list.basic-details')}
-      />
-      <PropertyList
-        divider={<Divider />}
-        orientation="vertical"
-        sx={{ '--PropertyItem-padding': '12px 24px' }}
-      >
-        {(
-          [
-            {
-              key: 'Customer ID',
-              value: (
-                <Chip
-                  label="USR-001"
-                  size="small"
-                  variant="soft"
-                />
-              ),
-            },
-            { key: 'Name', value: 'Miron Vitold' },
-            { key: 'Email', value: 'miron.vitold@domain.com' },
-            { key: 'Phone', value: '(425) 434-5535' },
-            { key: 'Company', value: 'Devias IO' },
-            {
-              key: 'Quota',
-              value: (
-                <Stack
-                  direction="row"
-                  spacing={2}
-                  sx={{ alignItems: 'center' }}
-                >
-                  <LinearProgress
-                    sx={{ flex: '1 1 auto' }}
-                    value={50}
-                    variant="determinate"
-                  />
-                  <Typography
-                    color="text.secondary"
-                    variant="body2"
-                  >
-                    50%
-                  </Typography>
-                </Stack>
-              ),
-            },
-          ] satisfies { key: string; value: React.ReactNode }[]
-        ).map(
-          (item): React.JSX.Element => (
-            <PropertyItem
-              key={item.key}
-              name={item.key}
-              value={item.value}
-            />
-          )
-        )}
-      </PropertyList>
-    </Card>
-  );
-}
-</file>
-
-<file path="Notifications/index.tsx">
-'use client';
-
-import { dayjs } from '@/lib/dayjs';
-
-import type { Notification } from './type';
-
-export const SampleNotifications: Notification[] = [
-  {
-    id: 'EV-002',
-    type: 'Refund request approved',
-    status: 'pending',
-    createdAt: dayjs().subtract(34, 'minute').subtract(5, 'hour').subtract(3, 'day').toDate(),
-  },
-  {
-    id: 'EV-001',
-    type: 'Order confirmation',
-    status: 'delivered',
-    createdAt: dayjs().subtract(49, 'minute').subtract(11, 'hour').subtract(4, 'day').toDate(),
-  },
-];
-</file>
-
-<file path="Notifications/type.d.ts">
-export interface Notification {
-  id: string;
-  type: string;
-  status: 'delivered' | 'pending' | 'failed';
-  createdAt: Date;
-}
-</file>
-
-<file path="PaymentCard/index.tsx">
-'use client';
-
-import * as React from 'react';
-import Avatar from '@mui/material/Avatar';
-import Button from '@mui/material/Button';
-import Card from '@mui/material/Card';
-import CardContent from '@mui/material/CardContent';
-import CardHeader from '@mui/material/CardHeader';
-import Divider from '@mui/material/Divider';
-import { CreditCard as CreditCardIcon } from '@phosphor-icons/react/dist/ssr/CreditCard';
-import { PencilSimple as PencilSimpleIcon } from '@phosphor-icons/react/dist/ssr/PencilSimple';
-import { useTranslation } from 'react-i18next';
-
-import { PropertyItem } from '@/components/core/property-item';
-import { PropertyList } from '@/components/core/property-list';
-import { Payments } from '@/components/dashboard/lp/categories/payments';
-
-import { SamplePayments } from './SamplePayments';
-
-export default function SamplePaymentCard(): React.JSX.Element {
-  const { t } = useTranslation();
-  return (
-    <>
-      <Payments
-        ordersValue={2069.48}
-        payments={SamplePayments}
-        refundsValue={324.5}
-        totalOrders={5}
-      />
-      <Card>
-        <CardHeader
-          action={
-            <Button
-              color="secondary"
-              startIcon={<PencilSimpleIcon />}
-            >
-              {t('list.edit')}
-            </Button>
-          }
-          avatar={
-            <Avatar>
-              <CreditCardIcon fontSize="var(--Icon-fontSize)" />
-            </Avatar>
-          }
-          title={t('list.billing-details')}
-        />
-        <CardContent>
-          <Card
-            sx={{ borderRadius: 1 }}
-            variant="outlined"
-          >
-            <PropertyList
-              divider={<Divider />}
-              sx={{ '--PropertyItem-padding': '16px' }}
-            >
-              {(
-                [
-                  { key: t('Credit card'), value: '**** 4142' },
-                  { key: t('Country'), value: t('United States') },
-                  { key: t('State'), value: t('Michigan') },
-                  { key: t('City'), value: t('Southfield') },
-                  { key: t('Address'), value: t('Address') },
-                  { key: t('Tax ID'), value: t('Tax ID') },
-                ] satisfies { key: string; value: React.ReactNode }[]
-              ).map(
-                (item): React.JSX.Element => (
-                  <PropertyItem
-                    key={item.key}
-                    name={item.key}
-                    value={item.value}
-                  />
-                )
-              )}
-            </PropertyList>
-          </Card>
-        </CardContent>
-      </Card>
-    </>
-  );
-}
-</file>
-
-<file path="PaymentCard/SamplePayments.tsx">
-'use client';
-
-// import { dayjs } from 'dayjs';
-import type { Payment } from '@/types/Payment';
-import { dayjs } from '@/lib/dayjs';
-
-export const SamplePayments: Payment[] = [
-  {
-    currency: 'USD',
-    amount: 500,
-    invoiceId: 'INV-005',
-    status: 'completed',
-    createdAt: dayjs().subtract(5, 'minute').subtract(1, 'hour').toDate(),
-  },
-  {
-    currency: 'USD',
-    amount: 324.5,
-    invoiceId: 'INV-004',
-    status: 'refunded',
-    createdAt: dayjs().subtract(21, 'minute').subtract(2, 'hour').toDate(),
-  },
-  {
-    currency: 'USD',
-    amount: 746.5,
-    invoiceId: 'INV-003',
-    status: 'completed',
-    createdAt: dayjs().subtract(7, 'minute').subtract(3, 'hour').toDate(),
-  },
-  {
-    currency: 'USD',
-    amount: 56.89,
-    invoiceId: 'INV-002',
-    status: 'completed',
-    createdAt: dayjs().subtract(48, 'minute').subtract(4, 'hour').toDate(),
-  },
-  {
-    currency: 'USD',
-    amount: 541.59,
-    invoiceId: 'INV-001',
-    status: 'completed',
-    createdAt: dayjs().subtract(31, 'minute').subtract(5, 'hour').toDate(),
-  },
-];
-</file>
-
-<file path="SecurityCard/index.tsx">
-'use client';
-
-import * as React from 'react';
-import Avatar from '@mui/material/Avatar';
-import Button from '@mui/material/Button';
-import Card from '@mui/material/Card';
-import CardContent from '@mui/material/CardContent';
-import CardHeader from '@mui/material/CardHeader';
-import Stack from '@mui/material/Stack';
-import Typography from '@mui/material/Typography';
-import { ShieldWarning as ShieldWarningIcon } from '@phosphor-icons/react/dist/ssr/ShieldWarning';
-import { useTranslation } from 'react-i18next';
-
-export default function SampleSecurityCard(): React.JSX.Element {
-  const { t } = useTranslation();
-
-  return (
-    <Card>
-      <CardHeader
-        avatar={
-          <Avatar>
-            <ShieldWarningIcon fontSize="var(--Icon-fontSize)" />
-          </Avatar>
-        }
-        title={t('list.security')}
-      />
-      <CardContent>
-        <Stack spacing={1}>
-          <div>
-            <Button
-              color="error"
-              variant="contained"
-            >
-              {t('Delete account')}
-            </Button>
-          </div>
-          <Typography
-            color="text.secondary"
-            variant="body2"
-          >
-            {t('a-deleted-customer-cannot-be-restored-all-data-will-be-permanently-removed')}
-          </Typography>
-        </Stack>
-      </CardContent>
-    </Card>
-  );
-}
-</file>
-
-<file path="TitleCard/index.tsx">
-'use client';
-
-import * as React from 'react';
-import { Button } from '@mui/material';
-import Avatar from '@mui/material/Avatar';
-import Chip from '@mui/material/Chip';
-import Stack from '@mui/material/Stack';
-import Typography from '@mui/material/Typography';
-import { CaretDown as CaretDownIcon } from '@phosphor-icons/react/dist/ssr/CaretDown';
-import { CheckCircle as CheckCircleIcon } from '@phosphor-icons/react/dist/ssr/CheckCircle';
-import { useTranslation } from 'react-i18next';
-
-export default function SampleTitleCard(): React.JSX.Element {
-  const { t } = useTranslation();
-
-  return (
-    <>
-      <Stack
-        direction="row"
-        spacing={2}
-        sx={{ alignItems: 'center', flex: '1 1 auto' }}
-      >
-        <Avatar
-          src="/assets/avatar-1.png"
-          sx={{ '--Avatar-size': '64px' }}
-        >
-          empty
-        </Avatar>
-        <div>
-          <Stack
-            direction="row"
-            spacing={2}
-            sx={{ alignItems: 'center', flexWrap: 'wrap' }}
-          >
-            <Typography variant="h4">{t('list.customer-name')}</Typography>
-            <Chip
-              icon={
-                <CheckCircleIcon
-                  color="var(--mui-palette-success-main)"
-                  weight="fill"
-                />
-              }
-              label={t('list.active')}
-              size="small"
-              variant="outlined"
-            />
-          </Stack>
-          <Typography
-            color="text.secondary"
-            variant="body1"
-          >
-            {t('list.customer-email')}
-          </Typography>
-        </div>
-      </Stack>
-      <div>
-        <Button
-          endIcon={<CaretDownIcon />}
-          variant="contained"
-        >
-          {t('list.action')}
-        </Button>
-      </div>
-    </>
-  );
-}
-</file>
-
-<file path="Helloworld.tsx">
-'use client';
-
-import * as React from 'react';
-import useEnhancedEffect from '@mui/utils/useEnhancedEffect';
-
-function Page(): React.JSX.Element {
-  React.useLayoutEffect(() => {
-    console.log('helloworld');
-  }, []);
-
-  return <>helloworld</>;
-}
-
-export default Page;
-</file>
-
-</files>
--- a/002_source/cms/src/app/dashboard/connectives/lesson-categories-sample-data.tsx
+++ b/002_source/cms/src/app/dashboard/connectives/lesson-categories-sample-data.tsx
@@ -1,5 +1,5 @@
 import { dayjs } from '@/lib/dayjs';
-import { LessonCategory } from '@/components/dashboard/lesson_category/type';
+import type { LessonCategory } from '@/components/dashboard/lesson_category/type';

 // import type { LessonCategory } from '@/components/dashboard/lp_categories/type';

--- a/002_source/cms/src/app/dashboard/connectives/view/[cat_id]/page.tsx
+++ b/002_source/cms/src/app/dashboard/connectives/view/[cat_id]/page.tsx
@@ -28,12 +28,13 @@ import { PencilSimple as PencilSimpleIcon } from '@phosphor-icons/react/dist/ssr
 import { Plus as PlusIcon } from '@phosphor-icons/react/dist/ssr/Plus';
 import { ShieldWarning as ShieldWarningIcon } from '@phosphor-icons/react/dist/ssr/ShieldWarning';
 import { User as UserIcon } from '@phosphor-icons/react/dist/ssr/User';
-import { RecordModel } from 'pocketbase';
+import type { RecordModel } from 'pocketbase';
 import { useTranslation } from 'react-i18next';

 import { paths } from '@/paths';
 import { dayjs } from '@/lib/dayjs';
 import { logger } from '@/lib/default-logger';
+import getImageUrlFromFile from '@/lib/get-image-url-from-file.ts';
 import { pb } from '@/lib/pb';
 import { PropertyItem } from '@/components/core/property-item';
 import { PropertyList } from '@/components/core/property-list';
@@ -45,7 +46,7 @@ import { Notifications } from '@/components/dashboard/lesson_category/notificati
 import { Payments } from '@/components/dashboard/lesson_category/payments';
 import type { Address } from '@/components/dashboard/lesson_category/shipping-address';
 import { ShippingAddress } from '@/components/dashboard/lesson_category/shipping-address';
-import { LessonCategory } from '@/components/dashboard/lesson_category/type';
+import type { LessonCategory } from '@/components/dashboard/lesson_category/type';
 // import type { LessonCategory } from '@/components/dashboard/lp_categories/type';
 import FormLoading from '@/components/loading';

@@ -119,39 +120,72 @@ export default function Page(): React.JSX.Element {
              {t('dashboard.lessonCategorys.list.title')}
            </Link>
          </div>
-          <Stack direction={{ xs: 'column', sm: 'row' }} spacing={3} sx={{ alignItems: 'flex-start' }}>
-            <Stack direction="row" spacing={2} sx={{ alignItems: 'center', flex: '1 1 auto' }}>
+          <Stack
+            direction={{ xs: 'column', sm: 'row' }}
+            spacing={3}
+            sx={{ alignItems: 'flex-start' }}
+          >
+            <Stack
+              direction="row"
+              spacing={2}
+              sx={{ alignItems: 'center', flex: '1 1 auto' }}
+            >
              <Avatar
-                src={`http://127.0.0.1:8090/api/files/${showLessonCategory.collectionId}/${showLessonCategory.id}/${showLessonCategory.cat_image}`}
+                src={getImageUrlFromFile(
+                  showLessonCategory.collectionId,
+                  showLessonCategory.id,
+                  showLessonCategory.cat_image
+                )}
                sx={{ '--Avatar-size': '64px' }}
                variant="rounded"
              >
                empty
              </Avatar>
              <div>
-                <Stack direction="row" spacing={2} sx={{ alignItems: 'center', flexWrap: 'wrap' }}>
+                <Stack
+                  direction="row"
+                  spacing={2}
+                  sx={{ alignItems: 'center', flexWrap: 'wrap' }}
+                >
                  <Typography variant="h4">{showLessonCategory.name}</Typography>
                  <Chip
-                    icon={<CheckCircleIcon color="var(--mui-palette-success-main)" weight="fill" />}
+                    icon={
+                      <CheckCircleIcon
+                        color="var(--mui-palette-success-main)"
+                        weight="fill"
+                      />
+                    }
                    label={showLessonCategory.visible}
                    size="small"
                    variant="outlined"
                  />
                </Stack>
-                <Typography color="text.secondary" variant="body1">
+                <Typography
+                  color="text.secondary"
+                  variant="body1"
+                >
                  {showLessonCategory.id}
                </Typography>
              </div>
            </Stack>
            <div>
-              <Button endIcon={<CaretDownIcon />} variant="contained">
+              <Button
+                endIcon={<CaretDownIcon />}
+                variant="contained"
+              >
                Action
              </Button>
            </div>
          </Stack>
        </Stack>
-        <Grid container spacing={4}>
-          <Grid lg={4} xs={12}>
+        <Grid
+          container
+          spacing={4}
+        >
+          <Grid
+            lg={4}
+            xs={12}
+          >
            <Stack spacing={4}>
              <Card>
                <CardHeader
@@ -178,7 +212,16 @@ export default function Page(): React.JSX.Element {
                >
                  {(
                    [
-                      { key: 'Customer ID', value: <Chip label={showLessonCategory.id} size="small" variant="soft" /> },
+                      {
+                        key: 'Customer ID',
+                        value: (
+                          <Chip
+                            label={showLessonCategory.id}
+                            size="small"
+                            variant="soft"
+                          />
+                        ),
+                      },
                      { key: 'Name', value: showLessonCategory.name },
                      { key: 'Pos', value: showLessonCategory.pos },
                      {
@@ -195,9 +238,20 @@ export default function Page(): React.JSX.Element {
                      {
                        key: 'Quota',
                        value: (
-                          <Stack direction="row" spacing={2} sx={{ alignItems: 'center' }}>
-                            <LinearProgress sx={{ flex: '1 1 auto' }} value={50} variant="determinate" />
-                            <Typography color="text.secondary" variant="body2">
+                          <Stack
+                            direction="row"
+                            spacing={2}
+                            sx={{ alignItems: 'center' }}
+                          >
+                            <LinearProgress
+                              sx={{ flex: '1 1 auto' }}
+                              value={50}
+                              variant="determinate"
+                            />
+                            <Typography
+                              color="text.secondary"
+                              variant="body2"
+                            >
                              50%
                            </Typography>
                          </Stack>
@@ -206,7 +260,11 @@ export default function Page(): React.JSX.Element {
                    ] satisfies { key: string; value: React.ReactNode }[]
                  ).map(
                    (item): React.JSX.Element => (
-                      <PropertyItem key={item.key} name={item.key} value={item.value} />
+                      <PropertyItem
+                        key={item.key}
+                        name={item.key}
+                        value={item.value}
+                      />
                    )
                  )}
                </PropertyList>
@@ -223,11 +281,17 @@ export default function Page(): React.JSX.Element {
                <CardContent>
                  <Stack spacing={1}>
                    <div>
-                      <Button color="error" variant="contained">
+                      <Button
+                        color="error"
+                        variant="contained"
+                      >
                        Delete account
                      </Button>
                    </div>
-                    <Typography color="text.secondary" variant="body2">
+                    <Typography
+                      color="text.secondary"
+                      variant="body2"
+                    >
                      A deleted lesson category cannot be restored. All data will be permanently removed.
                    </Typography>
                  </Stack>
@@ -235,7 +299,10 @@ export default function Page(): React.JSX.Element {
              </Card>
            </Stack>
          </Grid>
-          <Grid lg={8} xs={12}>
+          <Grid
+            lg={8}
+            xs={12}
+          >
            <Stack spacing={4}>
              <Payments
                ordersValue={2069.48}
@@ -282,7 +349,10 @@ export default function Page(): React.JSX.Element {
              <Card>
                <CardHeader
                  action={
-                    <Button color="secondary" startIcon={<PencilSimpleIcon />}>
+                    <Button
+                      color="secondary"
+                      startIcon={<PencilSimpleIcon />}
+                    >
                      Edit
                    </Button>
                  }
@@ -294,8 +364,14 @@ export default function Page(): React.JSX.Element {
                  title={t('billing-details', { ns: 'lesson_category' })}
                />
                <CardContent>
-                  <Card sx={{ borderRadius: 1 }} variant="outlined">
-                    <PropertyList divider={<Divider />} sx={{ '--PropertyItem-padding': '16px' }}>
+                  <Card
+                    sx={{ borderRadius: 1 }}
+                    variant="outlined"
+                  >
+                    <PropertyList
+                      divider={<Divider />}
+                      sx={{ '--PropertyItem-padding': '16px' }}
+                    >
                      {(
                        [
                          { key: 'Credit card', value: '**** 4142' },
@@ -307,7 +383,11 @@ export default function Page(): React.JSX.Element {
                        ] satisfies { key: string; value: React.ReactNode }[]
                      ).map(
                        (item): React.JSX.Element => (
-                          <PropertyItem key={item.key} name={item.key} value={item.value} />
+                          <PropertyItem
+                            key={item.key}
+                            name={item.key}
+                            value={item.value}
+                          />
                        )
                      )}
                    </PropertyList>
@@ -317,7 +397,10 @@ export default function Page(): React.JSX.Element {
              <Card>
                <CardHeader
                  action={
-                    <Button color="secondary" startIcon={<PlusIcon />}>
+                    <Button
+                      color="secondary"
+                      startIcon={<PlusIcon />}
+                    >
                      Add
                    </Button>
                  }
@@ -329,7 +412,10 @@ export default function Page(): React.JSX.Element {
                  title={t('shipping-addresses', { ns: 'lesson_category' })}
                />
                <CardContent>
-                  <Grid container spacing={3}>
+                  <Grid
+                    container
+                    spacing={3}
+                  >
                    {(
                      [
                        {
@@ -351,7 +437,11 @@ export default function Page(): React.JSX.Element {
                        },
                      ] satisfies Address[]
                    ).map((address) => (
-                      <Grid key={address.id} md={6} xs={12}>
+                      <Grid
+                        key={address.id}
+                        md={6}
+                        xs={12}
+                      >
                        <ShippingAddress address={address} />
                      </Grid>
                    ))}
--- a/002_source/cms/src/app/dashboard/cr/categories/list/page.tsx
+++ b/002_source/cms/src/app/dashboard/cr/categories/list/page.tsx
@@ -90,8 +90,7 @@ export default function Page({ searchParams }: PageProps): React.JSX.Element {
  React.useEffect(() => {
    if (!isFirstRun.current) {
      isFirstRun.current = true;
-    } else {
-      if (JSON.stringify(listOption) !== JSON.stringify(lastListOption)) {
+    } else if (JSON.stringify(listOption) !== JSON.stringify(lastListOption)) {
        // reset page number as tab changes
        setLastListOption(listOption);
        setCurrentPage(0);
@@ -99,7 +98,6 @@ export default function Page({ searchParams }: PageProps): React.JSX.Element {
      } else {
        void reloadRows();
      }
-    }
  }, [currentPage, rowsPerPage, listOption]);

  React.useEffect(() => {
--- a/002_source/cms/src/app/dashboard/cr/categories/lp-categories-sample-data.tsx
+++ b/002_source/cms/src/app/dashboard/cr/categories/lp-categories-sample-data.tsx
@@ -1,5 +1,5 @@
 import { dayjs } from '@/lib/dayjs';
-import { LessonCategory } from '@/components/dashboard/lesson_category/type';
+import type { LessonCategory } from '@/components/dashboard/lesson_category/type';

 export const LpCategoriesSampleData = [
  {
--- a/002_source/cms/src/app/dashboard/cr/categories/view/[cat_id]/BasicDetailCard.tsx
+++ b/002_source/cms/src/app/dashboard/cr/categories/view/[cat_id]/BasicDetailCard.tsx
@@ -13,7 +13,7 @@ import { useTranslation } from 'react-i18next';

 import { PropertyItem } from '@/components/core/property-item';
 import { PropertyList } from '@/components/core/property-list';
-import { CrCategory } from '@/components/dashboard/cr/categories/type';
+import type { CrCategory } from '@/components/dashboard/cr/categories/type';

 export default function BasicDetailCard({
  lpModel: model,
--- a/002_source/cms/src/app/dashboard/cr/categories/view/[cat_id]/TitleCard.tsx
+++ b/002_source/cms/src/app/dashboard/cr/categories/view/[cat_id]/TitleCard.tsx
@@ -10,12 +10,9 @@ import { CaretDown as CaretDownIcon } from '@phosphor-icons/react/dist/ssr/Caret
 import { CheckCircle as CheckCircleIcon } from '@phosphor-icons/react/dist/ssr/CheckCircle';
 import { useTranslation } from 'react-i18next';

+import getImageUrlFromFile from '@/lib/get-image-url-from-file.ts';
 import type { CrCategory } from '@/components/dashboard/cr/categories/type';

-function getImageUrlFrRecord(record: CrCategory): string {
-  return `http://127.0.0.1:8090/api/files/${record.collectionId}/${record.id}/${record.cat_image}`;
-}
-
 export default function SampleTitleCard({ lpModel }: { lpModel: CrCategory }): React.JSX.Element {
  const { t } = useTranslation();

@@ -28,7 +25,7 @@ export default function SampleTitleCard({ lpModel }: { lpModel: CrCategory }): R
      >
        <Avatar
          variant="rounded"
-          src={getImageUrlFrRecord(lpModel)}
+          src={getImageUrlFromFile(lpModel.collectionId, lpModel.id, lpModel.cat_image)}
          sx={{ '--Avatar-size': '64px' }}
        >
          {t('empty')}
--- a/002_source/cms/src/app/dashboard/cr/questions/[cat_id]/BasicDetailCard.tsx
+++ b/002_source/cms/src/app/dashboard/cr/questions/[cat_id]/BasicDetailCard.tsx
@@ -13,7 +13,7 @@ import { useTranslation } from 'react-i18next';

 import { PropertyItem } from '@/components/core/property-item';
 import { PropertyList } from '@/components/core/property-list';
-import { LpCategory } from '@/components/dashboard/lp/categories/type';
+import type { LpCategory } from '@/components/dashboard/lp/categories/type';

 export default function BasicDetailCard({
  lpModel: model,
--- a/002_source/cms/src/app/dashboard/cr/questions/[cat_id]/TitleCard.tsx
+++ b/002_source/cms/src/app/dashboard/cr/questions/[cat_id]/TitleCard.tsx
@@ -10,11 +10,8 @@ import { CaretDown as CaretDownIcon } from '@phosphor-icons/react/dist/ssr/Caret
 import { CheckCircle as CheckCircleIcon } from '@phosphor-icons/react/dist/ssr/CheckCircle';
 import { useTranslation } from 'react-i18next';

-import { LpCategory } from '@/components/dashboard/lp/categories/type';
-
-function getImageUrlFrRecord(record: LpCategory): string {
-  return `http://127.0.0.1:8090/api/files/${record.collectionId}/${record.id}/${record.cat_image}`;
-}
+import getImageUrlFromFile from '@/lib/get-image-url-from-file.ts';
+import type { LpCategory } from '@/components/dashboard/lp/categories/type';

 export default function SampleTitleCard({ lpModel }: { lpModel: LpCategory }): React.JSX.Element {
  const { t } = useTranslation();
@@ -28,7 +25,7 @@ export default function SampleTitleCard({ lpModel }: { lpModel: LpCategory }): R
      >
        <Avatar
          variant="rounded"
-          src={getImageUrlFrRecord(lpModel)}
+          src={getImageUrlFromFile(lpModel.collectionId, lpModel.id, lpModel.cat_image)}
          sx={{ '--Avatar-size': '64px' }}
        >
          {t('empty')}
--- a/002_source/cms/src/app/dashboard/cr/questions/cr-categories-sample-data.tsx
+++ b/002_source/cms/src/app/dashboard/cr/questions/cr-categories-sample-data.tsx
@@ -1,5 +1,5 @@
 import { dayjs } from '@/lib/dayjs';
-import { LessonCategory } from '@/components/dashboard/lesson_category/type';
+import type { LessonCategory } from '@/components/dashboard/lesson_category/type';

 export const CrCategoriesSampleData = [
  {
--- a/002_source/cms/src/app/dashboard/customers/[customerId]/TitleCard.tsx
+++ b/002_source/cms/src/app/dashboard/customers/[customerId]/TitleCard.tsx
@@ -9,14 +9,14 @@ import Typography from '@mui/material/Typography';
 import { CaretDown as CaretDownIcon } from '@phosphor-icons/react/dist/ssr/CaretDown';
 import { CheckCircle as CheckCircleIcon } from '@phosphor-icons/react/dist/ssr/CheckCircle';
 import { useTranslation } from 'react-i18next';
+
 import type { Customer } from '@/components/dashboard/customer/type.d';

 // import type { CrCategory } from '@/components/dashboard/cr/categories/type';

 function getImageUrlFrRecord(record: Customer): string {
-  // TODO: fix this
-  //  `http://127.0.0.1:8090/api/files/${'record.collectionId'}/${'record.id'}/${'record.cat_image'}`;
-  return 'getImageUrlFrRecord(helloworld)';
+  // TODO: implement getImageUrlFrRecord
+  return 'not implemented';
 }

 export default function SampleTitleCard({ lpModel }: { lpModel: Customer }): React.JSX.Element {
--- a/002_source/cms/src/app/dashboard/lesson_categories/lesson-categories-sample-data.tsx
+++ b/002_source/cms/src/app/dashboard/lesson_categories/lesson-categories-sample-data.tsx
@@ -1,5 +1,5 @@
 import { dayjs } from '@/lib/dayjs';
-import { LessonCategory } from '@/components/dashboard/lesson_category/type';
+import type { LessonCategory } from '@/components/dashboard/lesson_category/type';

 // import type { LessonCategory } from '@/components/dashboard/lp_categories/type';

--- a/002_source/cms/src/app/dashboard/lesson_categories/view/[cat_id]/page.tsx
+++ b/002_source/cms/src/app/dashboard/lesson_categories/view/[cat_id]/page.tsx
@@ -28,12 +28,13 @@ import { PencilSimple as PencilSimpleIcon } from '@phosphor-icons/react/dist/ssr
 import { Plus as PlusIcon } from '@phosphor-icons/react/dist/ssr/Plus';
 import { ShieldWarning as ShieldWarningIcon } from '@phosphor-icons/react/dist/ssr/ShieldWarning';
 import { User as UserIcon } from '@phosphor-icons/react/dist/ssr/User';
-import { RecordModel } from 'pocketbase';
+import type { RecordModel } from 'pocketbase';
 import { useTranslation } from 'react-i18next';

 import { paths } from '@/paths';
 import { dayjs } from '@/lib/dayjs';
 import { logger } from '@/lib/default-logger';
+import getImageUrlFromFile from '@/lib/get-image-url-from-file.ts';
 import { pb } from '@/lib/pb';
 import { PropertyItem } from '@/components/core/property-item';
 import { PropertyList } from '@/components/core/property-list';
@@ -45,7 +46,7 @@ import { Notifications } from '@/components/dashboard/lesson_category/notificati
 import { Payments } from '@/components/dashboard/lesson_category/payments';
 import type { Address } from '@/components/dashboard/lesson_category/shipping-address';
 import { ShippingAddress } from '@/components/dashboard/lesson_category/shipping-address';
-import { LessonCategory } from '@/components/dashboard/lesson_category/type';
+import type { LessonCategory } from '@/components/dashboard/lesson_category/type';
 // import type { LessonCategory } from '@/components/dashboard/lp_categories/type';
 import FormLoading from '@/components/loading';

@@ -119,39 +120,72 @@ export default function Page(): React.JSX.Element {
              {t('dashboard.lessonCategorys.list.title')}
            </Link>
          </div>
-          <Stack direction={{ xs: 'column', sm: 'row' }} spacing={3} sx={{ alignItems: 'flex-start' }}>
-            <Stack direction="row" spacing={2} sx={{ alignItems: 'center', flex: '1 1 auto' }}>
+          <Stack
+            direction={{ xs: 'column', sm: 'row' }}
+            spacing={3}
+            sx={{ alignItems: 'flex-start' }}
+          >
+            <Stack
+              direction="row"
+              spacing={2}
+              sx={{ alignItems: 'center', flex: '1 1 auto' }}
+            >
              <Avatar
-                src={`http://127.0.0.1:8090/api/files/${showLessonCategory.collectionId}/${showLessonCategory.id}/${showLessonCategory.cat_image}`}
+                src={getImageUrlFromFile(
+                  showLessonCategory.collectionId,
+                  showLessonCategory.id,
+                  showLessonCategory.cat_image
+                )}
                sx={{ '--Avatar-size': '64px' }}
                variant="rounded"
              >
                empty
              </Avatar>
              <div>
-                <Stack direction="row" spacing={2} sx={{ alignItems: 'center', flexWrap: 'wrap' }}>
+                <Stack
+                  direction="row"
+                  spacing={2}
+                  sx={{ alignItems: 'center', flexWrap: 'wrap' }}
+                >
                  <Typography variant="h4">{showLessonCategory.name}</Typography>
                  <Chip
-                    icon={<CheckCircleIcon color="var(--mui-palette-success-main)" weight="fill" />}
+                    icon={
+                      <CheckCircleIcon
+                        color="var(--mui-palette-success-main)"
+                        weight="fill"
+                      />
+                    }
                    label={showLessonCategory.visible}
                    size="small"
                    variant="outlined"
                  />
                </Stack>
-                <Typography color="text.secondary" variant="body1">
+                <Typography
+                  color="text.secondary"
+                  variant="body1"
+                >
                  {showLessonCategory.id}
                </Typography>
              </div>
            </Stack>
            <div>
-              <Button endIcon={<CaretDownIcon />} variant="contained">
+              <Button
+                endIcon={<CaretDownIcon />}
+                variant="contained"
+              >
                Action
              </Button>
            </div>
          </Stack>
        </Stack>
-        <Grid container spacing={4}>
-          <Grid lg={4} xs={12}>
+        <Grid
+          container
+          spacing={4}
+        >
+          <Grid
+            lg={4}
+            xs={12}
+          >
            <Stack spacing={4}>
              <Card>
                <CardHeader
@@ -178,7 +212,16 @@ export default function Page(): React.JSX.Element {
                >
                  {(
                    [
-                      { key: 'Customer ID', value: <Chip label={showLessonCategory.id} size="small" variant="soft" /> },
+                      {
+                        key: 'Customer ID',
+                        value: (
+                          <Chip
+                            label={showLessonCategory.id}
+                            size="small"
+                            variant="soft"
+                          />
+                        ),
+                      },
                      { key: 'Name', value: showLessonCategory.name },
                      { key: 'Pos', value: showLessonCategory.pos },
                      {
@@ -195,9 +238,20 @@ export default function Page(): React.JSX.Element {
                      {
                        key: 'Quota',
                        value: (
-                          <Stack direction="row" spacing={2} sx={{ alignItems: 'center' }}>
-                            <LinearProgress sx={{ flex: '1 1 auto' }} value={50} variant="determinate" />
-                            <Typography color="text.secondary" variant="body2">
+                          <Stack
+                            direction="row"
+                            spacing={2}
+                            sx={{ alignItems: 'center' }}
+                          >
+                            <LinearProgress
+                              sx={{ flex: '1 1 auto' }}
+                              value={50}
+                              variant="determinate"
+                            />
+                            <Typography
+                              color="text.secondary"
+                              variant="body2"
+                            >
                              50%
                            </Typography>
                          </Stack>
@@ -206,7 +260,11 @@ export default function Page(): React.JSX.Element {
                    ] satisfies { key: string; value: React.ReactNode }[]
                  ).map(
                    (item): React.JSX.Element => (
-                      <PropertyItem key={item.key} name={item.key} value={item.value} />
+                      <PropertyItem
+                        key={item.key}
+                        name={item.key}
+                        value={item.value}
+                      />
                    )
                  )}
                </PropertyList>
@@ -223,11 +281,17 @@ export default function Page(): React.JSX.Element {
                <CardContent>
                  <Stack spacing={1}>
                    <div>
-                      <Button color="error" variant="contained">
+                      <Button
+                        color="error"
+                        variant="contained"
+                      >
                        Delete account
                      </Button>
                    </div>
-                    <Typography color="text.secondary" variant="body2">
+                    <Typography
+                      color="text.secondary"
+                      variant="body2"
+                    >
                      A deleted lesson category cannot be restored. All data will be permanently removed.
                    </Typography>
                  </Stack>
@@ -235,7 +299,10 @@ export default function Page(): React.JSX.Element {
              </Card>
            </Stack>
          </Grid>
-          <Grid lg={8} xs={12}>
+          <Grid
+            lg={8}
+            xs={12}
+          >
            <Stack spacing={4}>
              <Payments
                ordersValue={2069.48}
@@ -282,7 +349,10 @@ export default function Page(): React.JSX.Element {
              <Card>
                <CardHeader
                  action={
-                    <Button color="secondary" startIcon={<PencilSimpleIcon />}>
+                    <Button
+                      color="secondary"
+                      startIcon={<PencilSimpleIcon />}
+                    >
                      Edit
                    </Button>
                  }
@@ -294,8 +364,14 @@ export default function Page(): React.JSX.Element {
                  title={t('billing-details', { ns: 'lesson_category' })}
                />
                <CardContent>
-                  <Card sx={{ borderRadius: 1 }} variant="outlined">
-                    <PropertyList divider={<Divider />} sx={{ '--PropertyItem-padding': '16px' }}>
+                  <Card
+                    sx={{ borderRadius: 1 }}
+                    variant="outlined"
+                  >
+                    <PropertyList
+                      divider={<Divider />}
+                      sx={{ '--PropertyItem-padding': '16px' }}
+                    >
                      {(
                        [
                          { key: 'Credit card', value: '**** 4142' },
@@ -307,7 +383,11 @@ export default function Page(): React.JSX.Element {
                        ] satisfies { key: string; value: React.ReactNode }[]
                      ).map(
                        (item): React.JSX.Element => (
-                          <PropertyItem key={item.key} name={item.key} value={item.value} />
+                          <PropertyItem
+                            key={item.key}
+                            name={item.key}
+                            value={item.value}
+                          />
                        )
                      )}
                    </PropertyList>
@@ -317,7 +397,10 @@ export default function Page(): React.JSX.Element {
              <Card>
                <CardHeader
                  action={
-                    <Button color="secondary" startIcon={<PlusIcon />}>
+                    <Button
+                      color="secondary"
+                      startIcon={<PlusIcon />}
+                    >
                      Add
                    </Button>
                  }
@@ -329,7 +412,10 @@ export default function Page(): React.JSX.Element {
                  title={t('shipping-addresses', { ns: 'lesson_category' })}
                />
                <CardContent>
-                  <Grid container spacing={3}>
+                  <Grid
+                    container
+                    spacing={3}
+                  >
                    {(
                      [
                        {
@@ -351,7 +437,11 @@ export default function Page(): React.JSX.Element {
                        },
                      ] satisfies Address[]
                    ).map((address) => (
-                      <Grid key={address.id} md={6} xs={12}>
+                      <Grid
+                        key={address.id}
+                        md={6}
+                        xs={12}
+                      >
                        <ShippingAddress address={address} />
                      </Grid>
                    ))}
--- a/Show More
+++ b/Show More
				`@@ -0,0 +1 @@`
				<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 16 16"><path fill="currentColor" d="M8 0c4.42 0 8 3.58 8 8a8.01 8.01 0 0 1-5.45 7.59c-.4.08-.55-.17-.55-.38c0-.27.01-1.13.01-2.2c0-.75-.25-1.23-.54-1.48c1.78-.2 3.65-.88 3.65-3.95c0-.88-.31-1.59-.82-2.15c.08-.2.36-1.02-.08-2.12c0 0-.67-.22-2.2.82c-.64-.18-1.32-.27-2-.27s-1.36.09-2 .27c-1.53-1.03-2.2-.82-2.2-.82c-.44 1.1-.16 1.92-.08 2.12c-.51.56-.82 1.28-.82 2.15c0 3.06 1.86 3.75 3.64 3.95c-.23.2-.44.55-.51 1.07c-.46.21-1.61.55-2.33-.66c-.15-.24-.6-.83-1.23-.82c-.67.01-.27.38.01.53c.34.19.73.9.82 1.13c.16.45.68 1.31 2.69.94c0 .67.01 1.3.01 1.49c0 .21-.15.45-.55.38A7.995 7.995 0 0 1 0 8c0-4.42 3.58-8 8-8"/></svg>