· 7 years ago · Sep 24, 2018, 08:16 AM
1CREATE TABLE IF NOT EXISTS family (
2 id INT(11) PRIMARY KEY AUTO_INCREMENT NOT NULL,
3 name VARCHAR(250),
4 father INT(11),
5 mother INT(11),
6 husband INT(11),
7 wife INT(11),
8 gender ENUM('M','F'),
9 state ENUM('Dead','Alive','Unknown')
10);
11
12[
13 {"id":"10", "gen":"1", "name":"Great Papa", "father":"", "mother":"", "gender":"M", "wife":"9", "husb":""},
14 {"id":"9", "gen":"1", "name":"Great Mama", "father":"", "mother":"", "gender":"F", "wife":"", "husb":"10"},
15 {"id":"1", "gen":"2", "name":"Papa Tucker", "father":"", "mother":"", "gender":"M", "wife":"11", "husb":""},
16 {"id":"11", "gen":"2", "name":"Wifey Tucker", "father":"", "mother":"", "gender":"F", "wife":"", "husb":"1"},
17 {"id":"21", "gen":"2", "name":"Sis Tucker", "father":"10", "mother":"9", "gender":"F", "wife":"", "husb":""},
18 {"id":"2", "gen":"3", "name":"Son Tucker", "father":"1", "mother":"11", "gender":"M", "wife":"", "husb":""}
19]