DROP TABLE FilmT;
DROP TABLE CinemaT;
DROP TABLE DemonstrationT;
DROP TABLE ProviderT;

CREATE TABLE ProviderT(
    ProviderID INTEGER NOT NULL PRIMARY KEY,
    Provider CHAR(40) NOT NULL,
    Address CHAR(60) NOT NULL,
    Bank CHAR(60) NOT NULL,
    Accounting CHAR (20) NOT NULL
);

CREATE TABLE FilmT(
    FilmID INTEGER NOT NULL PRIMARY KEY,
    Film CHAR(20) NOT NULL,
    Script CHAR(60) NOT NULL,
    Producer CHAR(60) NOT NULL,
    Company CHAR(40) NOT NULL,
    YEAR NUMBER NOT NULL,
    Expense NUMBER NOT NULL,
    Price NUMBER NOT NULL,
    Worker CHAR(60) NOT NULL,
    Summa NUMBER NOT NULL,

    CONSTRAINT FK_ProviderID foreign KEY (ProviderID),
    CONSTRAINT FK_CinemaID foreign KEY (CinemaID)
);

CREATE TABLE CinemaT(
    CinemaID INTEGER NOT NULL PRIMARY KEY,
    Cinema CHAR(20) NOT NULL,
    INNCinema CHAR(10) NOT NULL,
    AddressCinema CHAR (60) NOT NULL,
    Chef CHAR(60) NOT NULL,
    Owner CHAR(60) NOT NULL,
    BankCinema CHAR(60) NOT NULL,
    Phone CHAR(10) NOT NULL,
    AccountCinema CHAR(20) NOT NULL,
    Capacity INTEGER NOT NULL
);

CREATE TABLE DemonstrationT(
    DemonstrationID INTEGER NOT NULL PRIMARY KEY,
    DateStart DATE NOT NULL,
    DateStop DATE NOT NULL,

    CONSTRAINT FK_FilmID foreign KEY (FilmID),
    CONSTRAINT FK_CinemaID foreign KEY (ConemaID)
);