mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
Andriy YakovlevandCursor
cf6ea46bd4
Provide the original PostgreSQL-style schema as `init.sql`, created with `data_type_default_nullable=1` so nullable columns are mapped correctly, and keep the ClickHouse-typed translation as `init_cloud.sql` for ClickHouse Cloud (workaround for a bug in the cloud shared catalog). Document both in the README and add the `data_type_default_nullable` setting to `settings.json`. Co-authored-by: Cursor <[email protected]>
171 lines
4.0 KiB
SQL
171 lines
4.0 KiB
SQL
CREATE TABLE aka_name (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
person_id integer NOT NULL,
|
|
name text NOT NULL,
|
|
imdb_index character varying(12),
|
|
name_pcode_cf character varying(5),
|
|
name_pcode_nf character varying(5),
|
|
surname_pcode character varying(5),
|
|
md5sum character varying(32)
|
|
);
|
|
|
|
CREATE TABLE aka_title (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
movie_id integer NOT NULL,
|
|
title text NOT NULL,
|
|
imdb_index character varying(12),
|
|
kind_id integer NOT NULL,
|
|
production_year integer,
|
|
phonetic_code character varying(5),
|
|
episode_of_id integer,
|
|
season_nr integer,
|
|
episode_nr integer,
|
|
note text,
|
|
md5sum character varying(32)
|
|
);
|
|
|
|
CREATE TABLE cast_info (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
person_id integer NOT NULL,
|
|
movie_id integer NOT NULL,
|
|
person_role_id integer,
|
|
note text,
|
|
nr_order integer,
|
|
role_id integer NOT NULL
|
|
);
|
|
|
|
CREATE TABLE char_name (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
name text NOT NULL,
|
|
imdb_index character varying(12),
|
|
imdb_id integer,
|
|
name_pcode_nf character varying(5),
|
|
surname_pcode character varying(5),
|
|
md5sum character varying(32)
|
|
);
|
|
|
|
CREATE TABLE comp_cast_type (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
kind character varying(32) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE company_name (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
name text NOT NULL,
|
|
country_code character varying(255),
|
|
imdb_id integer,
|
|
name_pcode_nf character varying(5),
|
|
name_pcode_sf character varying(5),
|
|
md5sum character varying(32)
|
|
);
|
|
|
|
CREATE TABLE company_type (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
kind character varying(32) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE complete_cast (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
movie_id integer,
|
|
subject_id integer NOT NULL,
|
|
status_id integer NOT NULL
|
|
);
|
|
|
|
CREATE TABLE info_type (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
info character varying(32) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE keyword (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
keyword text NOT NULL,
|
|
phonetic_code character varying(5)
|
|
);
|
|
|
|
CREATE TABLE kind_type (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
kind character varying(15) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE link_type (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
link character varying(32) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE movie_companies (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
movie_id integer NOT NULL,
|
|
company_id integer NOT NULL,
|
|
company_type_id integer NOT NULL,
|
|
note text
|
|
);
|
|
|
|
CREATE TABLE movie_info (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
movie_id integer NOT NULL,
|
|
info_type_id integer NOT NULL,
|
|
info text NOT NULL,
|
|
note text
|
|
);
|
|
|
|
CREATE TABLE movie_info_idx (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
movie_id integer NOT NULL,
|
|
info_type_id integer NOT NULL,
|
|
info text NOT NULL,
|
|
note text
|
|
);
|
|
|
|
CREATE TABLE movie_keyword (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
movie_id integer NOT NULL,
|
|
keyword_id integer NOT NULL
|
|
);
|
|
|
|
CREATE TABLE movie_link (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
movie_id integer NOT NULL,
|
|
linked_movie_id integer NOT NULL,
|
|
link_type_id integer NOT NULL
|
|
);
|
|
|
|
CREATE TABLE name (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
name text NOT NULL,
|
|
imdb_index character varying(12),
|
|
imdb_id integer,
|
|
gender character varying(1),
|
|
name_pcode_cf character varying(5),
|
|
name_pcode_nf character varying(5),
|
|
surname_pcode character varying(5),
|
|
md5sum character varying(32)
|
|
);
|
|
|
|
CREATE TABLE person_info (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
person_id integer NOT NULL,
|
|
info_type_id integer NOT NULL,
|
|
info text NOT NULL,
|
|
note text
|
|
);
|
|
|
|
CREATE TABLE role_type (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
role character varying(32) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE title (
|
|
id integer NOT NULL PRIMARY KEY,
|
|
title text NOT NULL,
|
|
imdb_index character varying(12),
|
|
kind_id integer NOT NULL,
|
|
production_year integer,
|
|
imdb_id integer,
|
|
phonetic_code character varying(5),
|
|
episode_of_id integer,
|
|
season_nr integer,
|
|
episode_nr integer,
|
|
series_years character varying(49),
|
|
md5sum character varying(32)
|
|
);
|