summaryrefslogtreecommitdiff
path: root/schema.txt
diff options
context:
space:
mode:
Diffstat (limited to 'schema.txt')
-rw-r--r--schema.txt24
1 files changed, 24 insertions, 0 deletions
diff --git a/schema.txt b/schema.txt
new file mode 100644
index 0000000..d43229e
--- /dev/null
+++ b/schema.txt
@@ -0,0 +1,24 @@
+-------------------------------------------------------------------------------
+| |
+| HKGI Database Schema |
+| |
+-------------------------------------------------------------------------------
+
+Plant:
+ *id: UUID
+ kind: enum Kind ("bbc", "hvv", "cyl", "dirt")
+ statuses: String[]
+ xp: Integer
+ xp_multiplier: Float
+ next_yield: UtcDateTime
+
+
+Stead:
+ *id: UUID
+ username: String
+ password: String
+ plants: UUID[] (Foreign Key -> Plant(id))
+ inventory: JSONB
+ ephemeral_statuses:
+
+