text2typeql/dataset/synthetic-1/recommendations/schema.tql at master · typedb-osi/text2typeql · 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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
define
  attribute url value string;
  attribute runtime value integer;
  attribute revenue value integer;
  attribute plot_embedding value string;
  attribute poster_embedding value string;
  attribute imdb_rating value double;
  attribute released value string;
  attribute countries value string;
  attribute languages value string;
  attribute plot value string;
  attribute imdb_votes value integer;
  attribute imdb_id value string;
  attribute year value integer;
  attribute poster value string;
  attribute movie_id value string;
  attribute tmdb_id value string;
  attribute title value string;
  attribute budget value integer;
  attribute name value string;
  attribute user_id value string;
  attribute born_in value string;
  attribute bio value string;
  attribute died value datetime;
  attribute born value datetime;
  attribute rating value double;
  attribute timestamp value integer;
  attribute character_role value string;
  attribute age value integer;
  attribute description value string;
  attribute died_in value string;
  attribute gender value string;

  entity movie,
    owns url,
    owns runtime,
    owns revenue,
    owns plot_embedding,
    owns poster_embedding,
    owns imdb_rating,
    owns released,
    owns countries,
    owns languages,
    owns plot,
    owns imdb_votes,
    owns imdb_id,
    owns year,
    owns poster @card(0..),
    owns movie_id @key,
    owns tmdb_id,
    owns title,
    owns budget,
    plays in_genre:film,
    plays rated:film,
    plays acted_in:film,
    plays directed:film,
    plays won:film;

  entity genre,
    owns name @key,
    plays in_genre:genre;

  entity user,
    owns user_id @key,
    owns name,
    owns age,
    owns gender @values("male", "female", "other"),
    plays rated:user,
    plays located_in:resident;

  entity person,
    owns url,
    owns name,
    owns tmdb_id @key,
    owns born_in,
    owns died_in,
    owns bio,
    owns died,
    owns born,
    owns imdb_id,
    owns poster,
    owns gender @values("male", "female", "other"),
    plays acted_in:actor,
    plays directed:director;

  relation in_genre,
    relates film,
    relates genre;

  relation rated,
    relates user,
    relates film,
    owns rating,
    owns timestamp;

  relation acted_in,
    relates actor,
    relates film,
    owns character_role;

  relation directed,
    relates director,
    relates film,
    owns character_role;

  entity award,
    owns name @key,
    owns description,
    plays won:award;

  relation won,
    relates film,
    relates award;

  entity country,
    owns name @key,
    plays located_in:country;

  relation located_in,
    relates resident,
    relates country;