-- create tables create table ch14_type_of_plant ( id number generated by default on null as identity constraint ch14_type_of_plant_id_pk primary key, name_of_type_of_plant varchar2(30 char), ch14_is_subtype_of number constraint ch14_type_of_ch14_is_subty_fk references ch14_type_of_plant on delete cascade ) ; -- table index create index ch14_type_of_plant_i1 on ch14_type_of_plant (ch14_is_subtype_of); create table ch14_plants ( id number generated by default on null as identity constraint ch14_plants_id_pk primary key, ch14_plant_type_id number constraint ch14_plants_ch14_plant_type_fk references ch14_type_of_plant on delete cascade, names_local varchar2(100 char), names_english varchar2(100 char), name_latin varchar2(40 char), description varchar2(200 char), habitat varchar2(50 char), cultivation varchar2(100 char), use varchar2(100 char), photo blob, hyperlinks varchar2(100 char), status varchar2(20 char) ) ; -- table index create index ch14_plants_i1 on ch14_plants (ch14_plant_type_id);