From fc8fa5a30bf464557051ac22a75ca83de3a29f7b Mon Sep 17 00:00:00 2001
From: Andrew Guschin <guschin.drew@gmail.com>
Date: Wed, 29 Jun 2022 17:45:07 +0400
Subject: =?UTF-8?q?=D0=9E=D1=81=D0=BD=D0=BE=D0=B2=D0=BD=D0=BE=D0=B9=20?=
 =?UTF-8?q?=D1=81=D0=BA=D0=B5=D0=BB=D0=B5=D1=82=20=D0=B1=D0=BE=D1=82=D0=B0?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 spec.org | 49 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 spec.org

(limited to 'spec.org')

diff --git a/spec.org b/spec.org
new file mode 100644
index 0000000..eea2014
--- /dev/null
+++ b/spec.org
@@ -0,0 +1,49 @@
+#+TITLE: Bot architecture
+
+* База данных
+
+** Таблицы
+
+*** users
+| field     | type     | foreign |
+|-----------+----------+---------|
+| id        | int PK   | no      |
+| tg_id     | int      | no      |
+| tg_handle | varchar  | no      |
+| joined_at | datetime | no      |
+
+*** clients
+| field      | type     | foreign  |
+|------------+----------+----------|
+| id         | int PK   | no       |
+| user_id    | int      | users.id |
+| ip         | int      | no       |
+| pubkey     | varchar  | no       |
+| created_at | datetime | no       |
+
+*** user_perms
+| field     | type   | foreign  |
+|-----------+--------+----------|
+| user_id   | int PK | users.id |
+| is_admin  | bool   | no       |
+| is_client | bool   | no       |
+
+
+** Представления
+
+*** ClientsView
+| field  | type    | foreign |
+|--------+---------+---------|
+| ip     | int     | no      |
+| pubkey | varchar | no      |
+WHERE: user.is_client = True
+
+* Бот
+
+** MAIN_MENU
+- Создать новый клиент -> CREATE
+- Список созданных клиентов
+
+** NAME_CLIENT
+- [Ввод] Название клиента
+- Назад -> MAIN_MENU
-- 
cgit v1.2.3