chiark / gitweb /
ids in schema; distances
authorIan Jackson <ian@liberator.relativity.greenend.org.uk>
Sun, 26 Jul 2009 11:38:45 +0000 (12:38 +0100)
committerIan Jackson <ian@liberator.relativity.greenend.org.uk>
Sun, 26 Jul 2009 11:38:45 +0000 (12:38 +0100)
pctb/schema-notes.txt

index a60f9b0..11a88dd 100644 (file)
@@ -1,28 +1,39 @@
 
-OFFERS
-       ocean           utf-8
-       island          utf-8
-       commodity       utf-8
-       stall           utf-8
-       buy/sell        buy/sell
-    =>?
+BUY and SELL
+       commodity id    } indexed       } indexed       } unique
+       island id ??    }                               } indexed?
+       stall id                                        }
+       =>?
        price           integer
-       qty             integer
-       qty>1000?       boolean
+       qty             integer, 1001 means `>1000'
+
+COMMODITIES
+       commodity id
+       =>
+       commodity name
+       unit mass
+       unit volume
+
+ISLANDS
+       island id
+       =>
+       island name
+       archipelago name
+
+STALLS
+       stall id
+       =>
+       island id
+       stall name
 
 UPLOADS
-       ocean
-       island
+       island id
     =>?
        age             integer time_t
        clientspec      us-ascii
        serverspec      us-ascii
 
-COMMODITIES
-       commodity
-
-ISLANDS
-       ocean
-       island
-    =>
-       archipelago     utf-8
+DISTANCES
+       island a id
+       island b id
+       distance        integer leagues