9TBTWcpW

1CREATE TABLE IF NOT EXISTS 3idb.users_score(
2    user_id INT NOT NULL,
3    go_id INT NOT NULL,
4    score float NULL,
5    )
6
7
8
9CREATE TABLE IF NOT EXISTS 3idb.rec_insight(
10    rec_id INT AUTO_INCREMENT PRIMARY KEY,
11    rec_desc VARCHAR(255) NOT NULL
12    ) 
13
14CREATE TABLE IF NOT EXISTS 3idb.sdg_goals(
15    sdg_id INT AUTO_INCREMENT PRIMARY KEY,
16    sdg_desc VARCHAR(255) NOT NULL,
17    created_at date NOT NULL
18    )  
19
20
21CREATE TABLE IF NOT EXISTS 3idb.sust_goals(
22    go_id INT AUTO_INCREMENT PRIMARY KEY,
23    go_desc VARCHAR(255) NOT NULL,
24    sdg_id int null,
25    go_category VARCHAR(255)  NULL
26
27)  
28
29CREATE TABLE IF NOT EXISTS 3idb.groups (
30    group_id INT AUTO_INCREMENT PRIMARY KEY,
31    group_desc VARCHAR(255) NOT NULL,
32    user_id int NOT NULL
33)  
34
35
36CREATE TABLE IF NOT EXISTS 3idb.users (
37    user_id INT AUTO_INCREMENT PRIMARY KEY,
38    email VARCHAR(255) NOT NULL,
39    first_name VARCHAR(255) NOT NULL,
40    last_name VARCHAR(255) NOT NULL,
41    status TINYINT NOT NULL,
42    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
43)  
44
45CREATE TABLE IF NOT EXISTS 3idb.groups (
46    group_id INT AUTO_INCREMENT PRIMARY KEY,
47    group_desc VARCHAR(255) NOT NULL,
48    user_id int NOT NULL,
49)