Creating a table
Create the tables and set the data schema for them using the statement CREATE TABLE.
Keywords are case-insensitive and written in capital letters for clarity only.
CREATE TABLE series -- series is the table name. ( -- Must be unique within the folder. series_id Uint64, title Utf8, series_info Utf8, release_date Uint64, PRIMARY KEY (series_id) -- The primary key is a column or -- combination of columns that uniquely identifies -- each table row (contains only -- non-repeating values). A table can have -- only one primary key. For every table -- in YDB, the primary key is required. ); CREATE TABLE seasons ( series_id Uint64, season_id Uint64, title Utf8, first_aired Uint64, last_aired Uint64, PRIMARY KEY (series_id, season_id) ); CREATE TABLE episodes ( series_id Uint64, season_id Uint64, episode_id Uint64, title Utf8, air_date Uint64, PRIMARY KEY (series_id, season_id, episode_id) ); COMMIT;