/
imdb_database
79 lines (72 loc) · 5.17 KB
/
imdb_database
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
Table "public.crew_molten"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
------------+------+-----------+----------+---------+----------+--------------+-------------
tconst | text | | not null | | extended | |
profession | text | | not null | | extended | |
nconst | text | | not null | | extended | |
Indexes:
"tconst_pk_08" PRIMARY KEY, btree (tconst, profession, nconst)
Table "public.genres_molten"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------+------+-----------+----------+---------+----------+--------------+-------------
tconst | text | | not null | | extended | |
genres | text | | not null | | extended | |
Indexes:
"tconst_pk_07" PRIMARY KEY, btree (tconst, genres)
Table "public.name_basics"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-------------------+---------+-----------+----------+---------+----------+--------------+-------------
nconst | text | | not null | | extended | |
primaryname | text | | | | extended | |
birthyear | integer | | | | plain | |
deathyear | integer | | | | plain | |
primaryprofession | text | | | | extended | |
knownfortitles | text | | | | extended | |
Indexes:
"tconst_pk_05" PRIMARY KEY, btree (nconst)
Table "public.title_basics"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
----------------+---------+-----------+----------+---------+----------+--------------+-------------
tconst | text | | not null | | extended | |
titletype | text | | | | extended | |
primarytitle | text | | | | extended | |
originaltitle | text | | | | extended | |
isadult | boolean | | | | plain | |
startyear | integer | | | | plain | |
endyear | integer | | | | plain | |
runtimeminutes | integer | | | | plain | |
genres | text | | | | extended | |
Indexes:
"tconst_pk" PRIMARY KEY, btree (tconst)
Table "public.title_crew"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-----------+------+-----------+----------+---------+----------+--------------+-------------
tconst | text | | not null | | extended | |
directors | text | | | | extended | |
writers | text | | | | extended | |
Indexes:
"tconst_pk_02" PRIMARY KEY, btree (tconst)
Table "public.title_episode"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
---------------+---------+-----------+----------+---------+----------+--------------+-------------
tconst | text | | not null | | extended | |
parenttconst | text | | | | extended | |
seasonnumber | integer | | | | plain | |
episodenumber | integer | | | | plain | |
Indexes:
"tconst_pk_06" PRIMARY KEY, btree (tconst)
Table "public.title_principals_melt"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
---------------+------+-----------+----------+---------+----------+--------------+-------------
tconst | text | | not null | | extended | |
principalcast | text | | not null | | extended | |
Indexes:
"tconst_pk_03" PRIMARY KEY, btree (tconst, principalcast)
Table "public.title_ratings"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
---------------+---------+-----------+----------+---------+----------+--------------+-------------
tconst | text | | not null | | extended | |
averagerating | numeric | | | | main | |
numvotes | integer | | | | plain | |
Indexes:
"tconst_pk_04" PRIMARY KEY, btree (tconst)