---- Certificate Table ----
-- Records information about signing certificates
create table audit_cert
(
	event_id		number(20) not null,
	cert_thumbprint	nvarchar2(50) not null,
	cert_serial		nvarchar2(50) null,
	cert_alg		nvarchar2(50) null,
	cert_issuer		nvarchar2(50) null,
	cert_subject	nvarchar2(50) null,
	cert_from		timestamp null,
	cert_to			timestamp null,
	cert_sid		raw(85) null,
	constraint	audit_cert_pk primary key (event_id),
	constraint	event_id_cert_fk foreign key (event_id) references audit_event(event_id) ON DELETE CASCADE
)
/
---- Document Signature Table ----
-- Records information about signatures
create table audit_doc_sign
(
	event_id			number(20) not null,
	doc_sign_id			number(10) null,
	doc_sign_alg		nvarchar2(50) null,
	doc_sign_comment	nvarchar2(250) null,
	doc_sign_tgt_ids	number(10) null,
	constraint	audit_doc_sign_pk primary key (event_id),
	constraint	event_id_doc_sign_fk foreign key (event_id) references audit_event(event_id) ON DELETE CASCADE
)
/
---- Classification Table ----
-- Records information regarding adding, modifying,
-- and deleting classification levels.
create table audit_class
(
	event_id		number(20) not null,
	class_level		number(5) not null,
	new_class_level number(5) null,
	class_name		nvarchar2(47) null,
	new_class_name	nvarchar2(47) null,
	constraint	audit_class_pk primary key (event_id),
	constraint	event_id_class_fk foreign key (event_id) references audit_event(event_id) ON DELETE CASCADE
)
/

---- Email Profile Table ----
-- Names and IDs of email profiles registered, unregistered,
-- and modified.
create table audit_email
(
	event_id		number(20) not null,
	email_id		number(10) not null,
	email_name		nvarchar2(47) not null,
	new_email_name	nvarchar2(47) null,
	constraint	audit_email_pk primary key (event_id),
	constraint	event_id_email_fk foreign key (event_id) references audit_event(event_id) ON DELETE CASCADE
)
/
---- Parent Entry Table ----
-- IDs and paths of parents of entries appearing in
-- ENTRY_LISTED events.
create table audit_parent
(
	event_id	number(20) not null,
	parent_id	number(10) not null,
	parent_uuid char(36) not null,
	parent_name nvarchar2(1023) null,
	constraint	audit_parent_pk primary key (event_id),
	constraint	event_id_parent_fk foreign key (event_id) references audit_event(event_id) ON DELETE CASCADE
)
/