From eb882d0cb6f497d6f083956e6400cb09efadbf41 Mon Sep 17 00:00:00 2001 From: Cara Salter Date: Tue, 29 Aug 2023 11:37:33 -0400 Subject: initial commit --- schema.txt | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 schema.txt (limited to 'schema.txt') 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: + + -- cgit v1.2.3