summaryrefslogtreecommitdiff
path: root/schema.txt
diff options
context:
space:
mode:
authorCara Salter <cara@devcara.com>2023-08-29 11:37:33 -0400
committerCara Salter <cara@devcara.com>2023-08-29 11:37:33 -0400
commiteb882d0cb6f497d6f083956e6400cb09efadbf41 (patch)
treed9928cb024c08e98cf1e019fa7e8deed7da820e8 /schema.txt
downloadhkgi-eb882d0cb6f497d6f083956e6400cb09efadbf41.tar.gz
hkgi-eb882d0cb6f497d6f083956e6400cb09efadbf41.zip
initial commit
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:
+
+