CREATE TABLE Branch_Equipment (
       id_of_instrument     INTEGER NOT NULL,
       id_branch            INTEGER NOT NULL
);




CREATE TABLE Equipment (
       id_of_instrument     INTEGER NOT NULL,
       name_of_instrument   VARCHAR2(20) NULL,
       serial_number        INTEGER NULL,
       date_of_purchase     DATE NULL
);




CREATE TABLE Odered_Service (
       id_branch_service_employee INTEGER NOT NULL,
       id_executed_orders   INTEGER NOT NULL
);



CREATE TABLE Branch_service_employee (
       id_branch_service_employee INTEGER NOT NULL,
       price                INTEGER NULL,
       date_of_opening      DATE NULL,
       date_of_closing      DATE NULL,
       id_service           INTEGER NULL,
       id_branch_employee   INTEGER NULL
);




CREATE TABLE Service (
       id_service           INTEGER NOT NULL,
       Name_of_service      VARCHAR2(20) NULL,
       id_of_type           INTEGER NULL
);




CREATE TABLE Type_of_service (
       id_of_type           INTEGER NOT NULL,
       type_name            VARCHAR2(20) NULL
);




CREATE TABLE Branch_employee (
       id_branch_employee   INTEGER NOT NULL,
       Rate                 INTEGER NULL,
       wages                INTEGER NULL,
       Date_of_employment   DATE NULL,
       id_branch            INTEGER NULL,
       id_employee          INTEGER NULL,
       id_post              INTEGER NULL
);




CREATE TABLE Executed_orders (
       id_executed_orders   INTEGER NOT NULL,
       date_reception_order DATE NULL,
       date_delivery_result DATE NULL,
       paid                 VARCHAR2(20) NULL,
       id_card              INTEGER NULL
);




CREATE TABLE Card (
       id_card              INTEGER NOT NULL,
       date_of_institution_card DATE NULL,
       id_branch            INTEGER NULL,
       id_person            INTEGER NULL
);




CREATE TABLE Branch (
       id_branch            INTEGER NOT NULL,
       address              VARCHAR2(20) NULL,
       Phone                INTEGER NULL
);




CREATE TABLE Employee (
       id_employee          INTEGER NOT NULL,
       experience           INTEGER NULL,
       formation            VARCHAR2(20) NULL,
       id_person            INTEGER NULL
);


CREATE TABLE Post (
       id_post              INTEGER NOT NULL,
       Name_of_a_post       VARCHAR2(20) NULL
);




CREATE TABLE Person (
       id_person            INTEGER NOT NULL,
       surname              VARCHAR2(20) NULL,
       name                 VARCHAR2(20) NULL,
       patronymic           VARCHAR2(20) NULL,
       date_of_birth        DATE NULL,
       address              VARCHAR2(20) NULL,
       phone                INTEGER NULL,
       sex                  VARCHAR2(20) NULL
);