chiark / gitweb /
ids in schema; distances
[ypp-sc-tools.web-live.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