CREATE TABLE CASH (
       id_cash              INTEGER NOT NULL,
       money                INTEGER NULL,
       cashname             VARCHAR2( 20 ) NULL
);

CREATE TABLE COUNTRY (
       id_country           INTEGER NOT NULL,
       countryname          VARCHAR2( 20 ) NULL
);

CREATE TABLE DAY (
       id_day               SMALLINT NOT NULL,
       dayname              CHAR( 18 ) NULL
);

CREATE TABLE FIRM (
       id_firm              INTEGER NOT NULL,
       firmname             VARCHAR2( 20 ) NULL
);

CREATE TABLE FIRM_COUNTRY (
       id_firm              INTEGER NOT NULL,
       id_country           INTEGER NOT NULL
);

CREATE TABLE GOODS (
       id_goods             INTEGER NOT NULL,
       id_goodsname         INTEGER NOT NULL,
       id_country           INTEGER NOT NULL,
       id_firm              INTEGER NOT NULL,
       price                INTEGER NULL,
       d_guarant            SMALLINT NULL,
       m_guarant            SMALLINT NULL,
       y_guarant            SMALLINT NULL
);

CREATE TABLE GOODSNAME (
       id_goodsname         INTEGER NOT NULL,
       goodsname            VARCHAR2( 50 ) NULL
);

CREATE TABLE ORDERS (
       id_order             INTEGER NOT NULL,
       id_goods             INTEGER NOT NULL,
       id_cash              INTEGER NOT NULL,
       amount               INTEGER NULL,
       datetime             DATE NULL
);

CREATE TABLE SELLER (
       id_seller            INTEGER NOT NULL,
       firstname            VARCHAR2( 20 ) NULL,
       secondname           VARCHAR2( 20 ) NULL,
       patronymic           VARCHAR2( 20 ) NULL
);

CREATE TABLE SELLER_CASH (
       id_cash              INTEGER NOT NULL,
       id_seller            INTEGER NOT NULL,
       id_day               SMALLINT NOT NULL
);

CREATE TABLE STORE (
       id_goods             INTEGER NOT NULL,
       amount               INTEGER NULL
);