-- create tables create table ch15_user ( id number generated by default on null as identity constraint ch15_user_id_pk primary key, user_type varchar2(13 char) constraint ch15_user_user_type_ck check (user_type in ('MEMBER','ADMINISTRATOR')), firstname varchar2(30 char), lastname varchar2(30 char), address varchar2(50 char), email varchar2(80 char), phone varchar2(20 char), date_of_birth date, intests varchar2(256 char), user_status varchar2(9 char) constraint ch15_user_user_status_ck check (user_status in ('ACTIVE','SUSPENDED','INACTIVE')), username varchar2(50 char), user_passwd varchar2(50 char) ) ; create table ch15_user_history ( id number generated by default on null as identity constraint ch15_user_history_id_pk primary key, user_id number constraint ch15_user_history_user_id_fk references ch15_user on delete cascade, user_type varchar2(15 char), firstname varchar2(30 char), lastname varchar2(30 char), address varchar2(50 char), email varchar2(80 char), phone varchar2(20 char), date_of_birth date, intests varchar2(256 char), user_status varchar2(10 char), username varchar2(50 char), user_passwd varchar2(50 char), change_date date ) ; -- table index create index ch15_user_history_i1 on ch15_user_history (user_id); alter table ch15_user_history modify id generated always as identity restart start with 21; -- Generated by Quick SQL Tuesday April 25, 2023 07:36:26 /* ch15_user /insert 10 user_type vc15 /check 'member' 'administrator' firstname vc30 lastname vc30 address vc50 email vc80 phone vc20 date_of_birth date intests vc256 user_status vc10 /check 'active' 'suspended' 'inactive' username vc50 user_passwd vc50 ch15_user_history /insert 20 user_id num /fk ch15_user user_type vc15 firstname vc30 lastname vc30 address vc50 email vc80 phone vc20 date_of_birth date intests vc256 user_status vc10 username vc50 user_passwd vc50 change_date date # settings = { semantics: "CHAR", language: "EN", APEX: true } */