15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
CREATE TABLE linguistic (
ID INT PRIMARY KEY,
SPATID INT NOT NULL,
DOUSPAT INT CHECK (DOUSPAT IN (1)) NULL,
MAINID INT,
TOPONYM TEXT NOT NULL,
DOUTOPO INT CHECK (DOUTOPO IN (1)) NULL,
LANG VARCHAR(3) NOT NULL,
DOULANG INT CHECK (DOULANG IN (1)) NULL,
PRONUNC TEXT,
DOUPRON INT CHECK (DOUPRON IN (1)) NULL,
ETYM TEXT, -- Always doubtful
ORIGIN VARCHAR(3), -- Always doubtful
COMMENTS TEXT,
OTHER TEXT,
FOREIGN KEY (SPATID) REFERENCES spatial(ID),
FOREIGN KEY (MAINID) REFERENCES linguistic(ID)
);
CREATE TABLE temporal (
ID INT PRIMARY KEY,
LINGID INT NOT NULL,
LINGNAME TEXT NOT NULL,
TOPFORMS TEXT,
|
>
<
|
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
CREATE TABLE linguistic (
ID INT PRIMARY KEY,
SPATID INT NOT NULL,
DOUSPAT INT CHECK (DOUSPAT IN (1)) NULL,
MAINID INT,
TOPONYM TEXT NOT NULL,
TOPFORMS TEXT,
DOUTOPO INT CHECK (DOUTOPO IN (1)) NULL,
LANG VARCHAR(3) NOT NULL,
DOULANG INT CHECK (DOULANG IN (1)) NULL,
PRONUNC TEXT,
DOUPRON INT CHECK (DOUPRON IN (1)) NULL,
ETYM TEXT, -- Always doubtful
ORIGIN VARCHAR(3), -- Always doubtful
COMMENTS TEXT,
OTHER TEXT,
FOREIGN KEY (SPATID) REFERENCES spatial(ID),
FOREIGN KEY (MAINID) REFERENCES linguistic(ID)
);
CREATE TABLE temporal (
ID INT PRIMARY KEY,
LINGID INT NOT NULL,
LINGNAME TEXT NOT NULL,
START INT NOT NULL,
DOUSTART INT CHECK (DOUSTART IN (1)) NULL,
END INT,
DOUEND INT CHECK (DOUEND IN (1)) NULL,
EVENT TEXT CHECK (EVENT IN ('MERGEIN', 'ACTIVE', 'RENAME', 'CEASE')),
OBJID INT,
OBJNAME TEXT,
FULLTEXT TEXT NOT NULL,
COMMENTS TEXT,
OTHER TEXT,
FOREIGN KEY (LINGID, LINGNAME) REFERENCES linguistic(ID, TOPONYM),
FOREIGN KEY (OBJID, OBJNAME) REFERENCES linguistic(ID, TOPONYM)
);
|