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,
13
'developer_id' integer
16
CREATE TABLE 'topics' (
17
'id' INTEGER PRIMARY KEY NOT NULL,
19
'subtitle' varchar(255),
21
'created_at' datetime,
25
CREATE TABLE 'developers' (
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
33
CREATE TABLE 'projects' (
34
'id' INTEGER PRIMARY KEY NOT NULL,
35
'name' TEXT DEFAULT NULL
38
CREATE TABLE 'developers_projects' (
39
'developer_id' INTEGER NOT NULL,
40
'project_id' INTEGER NOT NULL,
41
'joined_on' DATE DEFAULT NULL,
42
'access_level' INTEGER DEFAULT 1
45
CREATE TABLE 'mascots' (
46
'id' INTEGER PRIMARY KEY NOT NULL,
47
'company_id' INTEGER NOT NULL,
48
'name' TEXT DEFAULT NULL
b'\\ No newline at end of file'