I keep getting an error trying to create a database. Please see below:

CREATE TABLE MOVIE(

MOVIE_ID VARCHAR(100), DIRECTOR VARCHAR(100) NOT NULL, NAME VARCHAR(100) UNIQUE NOT NULL, TYPE CHAR(1) CHECK (TYPE IN ('C','H','S')), DISTRIBUTOR_ID VARCHAR (100), ACTOR_NAME VARCHAR(100), LENGTH NUMERIC(14,0) CHECK (LENGTH > 0), AWARDS VARCHAR(1000), RATINGS NUMERIC (2,0) CHECK (RATINGS IN (1,2,3,4,5,6,7,8,9,10)), RELEASE_YEAR NUMERIC (4,0) CONSTRAINT MOVIE_PK PRIMARY KEY (MOVIE_ID), CONSTRAINT VIDEO_DVD_FK1 FOREIGN KEY (DISTRIBUTOR_ID) REFERENCES DISTRIBUTOR.DISTRIBUTOR_ID);

Johnson Video Store/postgres@PostgreSQL 10 v Query Editor Query History Scratch Pad 1 CREATE TABLE MOVIE 2 3 4 5 6 7 8 MOVIE_ID VARCHAR(100), DIRECTOR VARCHAR(100) NOT NULL, NAME VARCHAR(100) UNIQUE NOT NULL, TYPE CHAR (1) CHECK (TYPE IN ('C', 'H','S')), DISTRIBUTOR_ID VARCHAR (100), ACTOR_NAME VARCHAR(100), LENGTH NUMERIC (14,0) CHECK (LENGTH > 0), AWARDS VARCHAR(1000), RATINGS NUMERIC (2,0) CHECK (RATINGS IN (1,2,3,4,5,6,7,8,9,10)), RELEASE_YEAR NUMERIC (4,0) CONSTRAINT MOVIE_PK PRIMARY KEY (MOVIE_ID), CONSTRAINT VIDEO_DVD_FK1 FOREIGN KEY DISTRIBUTOR_ID) REFERENCES DISTRIBUTOR. DISTRIBUTOR_ID); 9 10 11 12 13 14 Data Output Explain Messages Notifications ERROR: syntax error at or near "C" LINE 13: CONSTRAINT MOVIE_PK PRIMARY KEY (MOVIE_ID), SQL state: 42601 Character: 402