familySearchServer/tables.txt at master · jasonhuang0081/familySearchServer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
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
drop table if exists user;
drop table if exists person;
drop table if exists events;
drop table if exists auth;
create table user
(
	username varchar(255) not null primary key unique,
	password varchar(255) not null,
	email varchar(255) not null,
	firstname varchar(255) not null,
	lastname varchar(255) not null,
	gender varchar(255) not null,
	personID varchar(255) not null unique
);
create table person
(
	personID varchar(255) not null primary key unique,
	descendant varchar(255),
	firstname varchar(255) not null,
	lastname varchar(255) not null,
	gender varchar(10) not null,
	father varchar(255),
	mother varchar(255),
	spouse varchar(255)
);
create table events
(
	eventID varchar(255) not null primary key,
	descendant varchar(255) not null,
	personID varchar(255) not null,
	latitude real not null,
	longtitude real not null,
	country varchar(255) not null,
	city varchar(255) not null,
	eventtype varchar (255) not null,
	year integer not null
);
create table auth
(
	token varchar(255) not null unique,
	username varchar(255) not null
);