chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.db-test.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
11a88dd58b3b800b93f9a56b6f44b02a32186e0d
[ypp-sc-tools.db-test.git]
/
pctb
/
schema-notes.txt
1
2
BUY and SELL
3
commodity id } indexed } indexed } unique
4
island id ?? } } indexed?
5
stall id }
6
=>?
7
price integer
8
qty integer, 1001 means `>1000'
9
10
COMMODITIES
11
commodity id
12
=>
13
commodity name
14
unit mass
15
unit volume
16
17
ISLANDS
18
island id
19
=>
20
island name
21
archipelago name
22
23
STALLS
24
stall id
25
=>
26
island id
27
stall name
28
29
UPLOADS
30
island id
31
=>?
32
age integer time_t
33
clientspec us-ascii
34
serverspec us-ascii
35
36
DISTANCES
37
island a id
38
island b id
39
distance integer leagues