-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy paththe_love_schema.txt
59 lines (30 loc) · 3.11 KB
/
the_love_schema.txt
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
MariaDB [The_Love_Schema]> SHOW TABLES;
+---------------------------+
| Tables_in_The_Love_Schema |
+---------------------------+
| Love |
| person_1 |
| person_2 |
+---------------------------+
3 rows in set (0.000 sec)
MariaDB [The_Love_Schema]> SELECT * FROM person_1;
+------------+-----------+----------+------------+--------------------------------+--------+------+----------+-------+-------------+--------+-----------+--------------+------+-----------+------------+-----------+------------+---------+
| person1_id | FirstName | LastName | BirthDate | Description | Height | Age | BodyType | Race | Nationality | Gender | RomOrient | SexualOrient | MBTI | CharTrope | ZodiacSign | BloodType | Occupation | EQLevel |
+------------+-----------+----------+------------+--------------------------------+--------+------+----------+-------+-------------+--------+-----------+--------------+------+-----------+------------+-----------+------------+---------+
| 1 | Esther | Odekunle | 1997-09-11 | One lovely brown-skinned girl. | 5'11 | 25 | Curvy | Black | British | Female | Aromantic | Asexual | ESTJ | Tsundere | Virgo | O | Scientist | Varies |
+------------+-----------+----------+------------+--------------------------------+--------+------+----------+-------+-------------+--------+-----------+--------------+------+-----------+------------+-----------+------------+---------+
1 row in set (0.000 sec)
MariaDB [The_Love_Schema]> SELECT * FROM person_2;
+------------+-----------+----------+------------+-----------------------+--------+------+----------+-------+-------------+--------+-------------+--------------+------+-----------+------------+-----------+------------+---------+
| person2_id | FirstName | LastName | BirthDate | Description | Height | Age | BodyType | Race | Nationality | Gender | RomOrient | SexualOrient | MBTI | CharTrope | ZodiacSign | BloodType | Occupation | EQLevel |
+------------+-----------+----------+------------+-----------------------+--------+------+----------+-------+-------------+--------+-------------+--------------+------+-----------+------------+-----------+------------+---------+
| 2 | Adam | Lee | 1996-11-22 | One handsome tan guy. | 5'7 | 26 | Muscular | Asian | American | Male | Polyamorous | Pansexual | ESFP | Himbo | Leo | AB- | Pilot | Varies |
+------------+-----------+----------+------------+-----------------------+--------+------+----------+-------+-------------+--------+-------------+--------------+------+-----------+------------+-----------+------------+---------+
1 row in set (0.000 sec)
MariaDB [The_Love_Schema]> SELECT * FROM Love;
+---------+------------+------------+--------------+------------+
| love_id | person1_id | person2_id | duration | type |
+---------+------------+------------+--------------+------------+
| 4 | 1 | 2 | 2020-Present | Unrequited |
+---------+------------+------------+--------------+------------+
1 row in set (0.000 sec)