1 CREATE TABLE 'companies' (
2 'id' INTEGER PRIMARY KEY NOT NULL,
3 'name' TEXT DEFAULT NULL,
4 'rating' INTEGER DEFAULT 1
7 CREATE TABLE 'replies' (
8 'id' INTEGER PRIMARY KEY NOT NULL,
10 'created_at' datetime,
11 'updated_at' datetime,
15 CREATE TABLE 'topics' (
16 'id' INTEGER PRIMARY KEY NOT NULL,
17 'project_id' INTEGER DEFAULT NULL,
19 'subtitle' varchar(255),
21 'created_at' datetime,
25 CREATE TABLE 'users' (
26 'id' INTEGER PRIMARY KEY NOT NULL,
27 'name' TEXT DEFAULT NULL,
28 'salary' INTEGER DEFAULT 70000,
29 'created_at' DATETIME DEFAULT NULL,
30 'updated_at' DATETIME DEFAULT NULL,
31 'type' TEXT DEFAULT NULL
34 CREATE TABLE 'projects' (
35 'id' INTEGER PRIMARY KEY NOT NULL,
36 'name' TEXT DEFAULT NULL
39 CREATE TABLE 'developers_projects' (
40 'developer_id' INTEGER NOT NULL,
41 'project_id' INTEGER NOT NULL,
42 'joined_on' DATE DEFAULT NULL,
43 'access_level' INTEGER DEFAULT 1