-
Notifications
You must be signed in to change notification settings - Fork 0
/
create.sql
29 lines (29 loc) · 956 Bytes
/
create.sql
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
CREATE TABLE "public"."code_metric" (
"id" bigserial NOT NULL,
"physical_sloc" float8 NOT NULL,
"logical_sloc" float8 NOT NULL,
"cyclomatic" float8 NOT NULL,
"cyclomatic_density" float8 NOT NULL,
"halstead_length" float8 NOT NULL,
"halstead_vocabulary" float8 NOT NULL,
"halstead_difficulty" float8 NOT NULL,
"halstead_volume" float8 NOT NULL,
"halstead_effort" float8 NOT NULL,
"halstead_bugs" float8 NOT NULL,
"halstead_time" float8 NOT NULL,
"function_count" float8 NOT NULL,
"dependency_count" float8 NOT NULL,
"maintainability" float8 NOT NULL,
"valid" boolean NOT NULL,
"total_deletions" float8 NOT NULL,
"total_additions" float8 NOT NULL,
"additions" float8 NOT NULL,
"deletions" float8 NOT NULL,
"time_since_bug" float8 NOT NULL,
"commit_count" float8 NOT NULL,
"author_count" float8 NOT NULL,
"is_buggy" boolean,
"filename" varchar(1024) UNIQUE NOT NULL,
PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);