dltLearning/schema.out at main · kelazarus/dltLearning · GitHub

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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
Table "pokemon" {
  "id" text
  "name" text
  "data__color" text
  "data__capacity_gb" bigint
  "_dlt_load_id" text [not null]
  "_dlt_id" text [pk, not null]
  "data__price" double
}

Table "berry" {
  "id" text
  "name" text
  "data__color" text
  "data__capacity_gb" bigint
  "_dlt_load_id" text [not null]
  "_dlt_id" text [pk, not null]
  "data__price" double
}

Table "location" {
  "id" text
  "name" text
  "data__color" text
  "data__capacity_gb" bigint
  "_dlt_load_id" text [not null]
  "_dlt_id" text [pk, not null]
  "data__price" double
}

Table "employees_100_kb_json" {
  "employee__id" text
  "employee__name" text
  "employee__position" text
  "employee__department__id" text
  "employee__department__name" text
  "employee__department__manager__id" text
  "employee__department__manager__name" text
  "employee__department__manager__contact__email" text
  "employee__department__manager__contact__phone" text
  "_dlt_load_id" text [not null]
  "_dlt_id" text [pk, not null]
}

Table "employees_100_kb_json__employee__projects" {
  "project_id" text
  "project_name" text
  "start_date" text
  "_dlt_parent_id" text [not null]
  "_dlt_list_idx" bigint [not null]
  "_dlt_id" text [pk, not null]
}

Table "employees_100_kb_json__employee__projects__tasks" {
  "task_id" text
  "title" text
  "status" text
  "details__hours_spent" bigint
  "_dlt_parent_id" text [not null]
  "_dlt_list_idx" bigint [not null]
  "_dlt_id" text [pk, not null]
  "details__completion_date" text
  "details__expected_completion" text
}

Table "employees_100_kb_json__employee__projects__tasks__details__technologies_used" {
  "value" text
  "_dlt_parent_id" text [not null]
  "_dlt_list_idx" bigint [not null]
  "_dlt_id" text [pk, not null]
}

Ref: "employees_100_kb_json__employee__projects"."_dlt_parent_id" > "employees_100_kb_json"."_dlt_id"
Ref: "employees_100_kb_json__employee__projects__tasks"."_dlt_parent_id" > "employees_100_kb_json__employee__projects"."_dlt_id"
Ref: "employees_100_kb_json__employee__projects__tasks__details__technologies_used"."_dlt_parent_id" > "employees_100_kb_json__employee__projects__tasks"."_dlt_id"