CREATE TABLE amico_TD_wk_type@hpss.world
(
	am_type_id		integer   not null,
	am_type_desc		varchar(400)   not null,
        primary key (am_type_id)
);

CREATE TABLE amico_TD_wk_classif@hpss.world
(
	am_classif_id		integer   not null,
	am_classif_term 	varchar(400)   not null,
	am_classif_scheme 	varchar(400)   not null,
        primary key (am_classif_id)
);

CREATE TABLE amico_TD_wkdim_typ@hpss.world
(
	am_dimen_type_id	integer   not null,
	am_dimen_type_desc	varchar(400)   not null, 
        primary key (am_dimen_type_id)
);

CREATE TABLE amico_TD_wkdim_unt@hpss.world
(
	am_dimen_unit_id	integer   not null,
	am_dimen_unit_desc	varchar(400)   not null,
        primary key (am_dimen_unit_id)
);

CREATE TABLE amico_TD_wk_mtrl@hpss.world
(
	am_mat_term_id		varchar(400)   not null,
	am_mat_term_desc	varchar(400)   not null,
        primary key (am_mat_term_id)
);

CREATE TABLE amico_TD_wk_tchnq@hpss.world
(
	am_technq_term_id	varchar(400)   not null,
	am_technq_term_desc	varchar(400),
        primary key (am_technq_term_id)   
);

CREATE TABLE amico_TD_wk_style@hpss.world
(
	am_style_id		varchar(400)   not null,
	am_style_desc		varchar(400)   not null,
        primary key (am_style_id)
);

CREATE TABLE amico_TD_wk_period@hpss.world
(
	am_period_id		varchar(400)   not null,
	am_period_desc		varchar(400)   not null,
        primary key (am_period_id)
);

CREATE TABLE amico_TD_wk_subjec@hpss.world
(
	am_subj_id		varchar(400)   not null,
	am_subj_desc		varchar(400)   not null,
        primary key (am_subj_id)
);

CREATE TABLE amico_TD_pers_info@hpss.world
(
	am_person_id		integer   not null,
	am_person		varchar(400)   not null,
        primary key (am_person_id)
);

CREATE TABLE amico_TD_plac_info@hpss.world
(
	am_place_id		integer   not null,
	am_city			varchar(100),
	am_state		varchar(100),
	am_country		varchar(100),
        primary key (am_place_id)
);



CREATE TABLE amico_TD_creator_core@hpss.world
(
	am_creator_id		integer   not null,
	am_creator_qual		varchar(200),
	am_creator_name		varchar(200)   not null,
	am_creator_sortnm	varchar(200),
	am_crtr_national	varchar(200),	
	am_creator_gender	varchar(10),
	am_creator_bio		varchar(2000),
	am_crtr_date_locn	varchar(200),
	am_crtr_birthdate	varchar(50),
	am_crtr_birthplace	varchar(200),
	am_crtr_birthqual	varchar(200),
	am_crtr_deathdate	varchar(50),
	am_crtr_deathplace	varchar(200),
	am_crtr_deathqual	varchar(200),
	am_crtr_activedate	varchar(200),
	am_crtr_notes		varchar(700),
        primary key (am_creator_id)
);

CREATE TABLE amico_TD_owner_core@hpss.world
(
	am_owner_id		integer,
	am_owner_name		varchar(200)   not null,
	am_owner_info		varchar(700),
        primary key (am_owner_id)
);

CREATE TABLE amico_TD_work_core@hpss.world
(
	am_work_id		varchar(100)   not null,
	am_work_desc		varchar(700)   not null,
        primary key (am_work_id)
);


CREATE TABLE amico_cr_activity@hpss.world
(
	am_creator_id		integer,
	am_crtr_activeplac	varchar(200),
	foreign key (am_creator_id) references amico_TD_creator_core@hpss.world (am_creator_id)
);

CREATE TABLE amico_wk_validate@hpss.world
(
	am_work_id		varchar(100),
	am_validated_date	varchar(50),
	am_validated_vers	varchar(100),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_dataproc@hpss.world
(
	am_work_id		varchar(100),
	am_deletion_flag	varchar(5),
	am_dp_year		integer,
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_physical@hpss.world
(
	am_work_id		varchar(100),
	am_physical_desc	varchar(700),
	am_physical_orient	varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_type@hpss.world
(
	am_work_id		varchar(100),
	am_type_id		integer,
	foreign key (am_type_id) references amico_TD_wk_type@hpss.world (am_type_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_parts@hpss.world
(
	am_work_id		varchar(100),
	am_parts_num		integer,
	am_parts_desc		varchar(400),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_classif@hpss.world
(
	am_work_id		varchar(100),
	am_classif_id		integer,
	foreign key (am_classif_id) references amico_TD_wk_classif@hpss.world (am_classif_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_title@hpss.world
(
	am_work_id		varchar(100),
	am_title		varchar(400),
	am_title_type		varchar(400),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_state@hpss.world
(
	am_work_id		varchar(100),
	am_state		varchar(200),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_edition@hpss.world
(
	am_work_id		varchar(100),
	am_edition		varchar(200),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_meas_text@hpss.world
(
	am_work_id		varchar(100),
	am_measure_text		varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_measurmnt@hpss.world
(
	am_work_id		varchar(100),
	am_component		varchar(200),
	am_dimen_type_id	integer,
	am_dimen_value		number,
	am_dimen_unit_id	integer,
	am_dimen_qualify	varchar(200),
	foreign key (am_dimen_type_id) references amico_TD_wkdim_typ@hpss.world (am_dimen_type_id),
	foreign key (am_dimen_unit_id) references amico_TD_wkdim_unt@hpss.world (am_dimen_unit_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_mtrl_tchnq@hpss.world
(
	am_work_id		varchar(100),
	am_mtrl_tchnq_id	integer,
	am_mat_tech_desc	varchar(700),
	primary key (am_mtrl_tchnq_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_mtrl_term@hpss.world
(
	am_mtrl_tchnq_id	integer,
	am_mat_term_id		varchar(400),
	foreign key (am_mat_term_id) references amico_TD_wk_mtrl@hpss.world (am_mat_term_id),
	foreign key (am_mtrl_tchnq_id) references amico_wk_mtrl_tchnq@hpss.world (am_mtrl_tchnq_id)
);

CREATE TABLE amico_wk_technq_term@hpss.world
(
	am_mtrl_tchnq_id	integer,
	am_technq_term_id	varchar(400),
	foreign key (am_technq_term_id) references amico_TD_wk_tchnq@hpss.world (am_technq_term_id),
	foreign key (am_mtrl_tchnq_id) references amico_wk_mtrl_tchnq@hpss.world (am_mtrl_tchnq_id)
);

CREATE TABLE amico_wk_support_term@hpss.world
(
	am_mtrl_tchnq_id	integer,
	am_sup_mat_term_id	varchar(400),
	foreign key (am_sup_mat_term_id) references amico_TD_wk_mtrl@hpss.world (am_mat_term_id),
	foreign key (am_mtrl_tchnq_id) references amico_wk_mtrl_tchnq@hpss.world (am_mtrl_tchnq_id)
);

CREATE TABLE amico_wk_inscription@hpss.world
(
	am_work_id		varchar(100),
	am_inscript_txt		varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_examhst@hpss.world
(
	am_work_id		varchar(100),
	am_cond_exam_txt	varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_consrvhst@hpss.world
(
	am_work_id		varchar(100),
	am_trmt_consrv_txt	varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_creator@hpss.world
(
	am_work_id		varchar(100),
	am_creator_id		integer,
	am_creator_role		varchar(700),
	foreign key (am_creator_id) references amico_TD_creator_core@hpss.world (am_creator_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);


CREATE TABLE amico_wk_date@hpss.world
(
	am_work_id		varchar(100),
	am_crtn_date_text	varchar(400),
	am_crtn_start_date	varchar(50),
	am_crtn_end_date	varchar(50),
	am_crtn_date_qual	varchar(200),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_locn@hpss.world
(
	am_work_id		varchar(100),
	am_place_id		integer,
	foreign key (am_place_id) references amico_TD_plac_info@hpss.world (am_place_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_style@hpss.world
(
	am_work_id		varchar(100),
	am_style_id		varchar(400),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (am_style_id) references amico_TD_wk_style@hpss.world (am_style_id)
);

CREATE TABLE amico_wk_period@hpss.world
(
	am_work_id		varchar(100),
	am_period_id		varchar(400),
	foreign key (am_period_id) references amico_TD_wk_period@hpss.world (am_period_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_supreicon@hpss.world
(
	am_work_id		varchar(100),
	am_preicon_desc		varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_su_icon@hpss.world
(
	am_work_id		varchar(100),
	am_icon_desc		varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_su_inxtrm@hpss.world
(
	am_work_id		varchar(100),
	am_subj_id		varchar(400),
	foreign key (am_subj_id) references amico_TD_wk_subjec@hpss.world (am_subj_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);


CREATE TABLE amico_wk_cntxt_dsc@hpss.world
(
	am_contxt_id		integer,
	am_work_id		varchar(100),
	am_contxt_desc		varchar(400),
	am_contxt_prd		varchar(200),
	primary key (am_contxt_id),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
	);

CREATE TABLE amico_wk_cntxt_prs@hpss.world
(
	am_contxt_id		integer,
	am_person_id		integer,
	foreign key (am_person_id) references amico_TD_pers_info@hpss.world (am_person_id),
	foreign key (am_contxt_id) references amico_wk_cntxt_dsc@hpss.world (am_contxt_id)
);

CREATE TABLE amico_wk_cntxt_loc@hpss.world
(
	am_contxt_id		integer,
	am_place_id		integer,
	foreign key (am_contxt_id) references amico_wk_cntxt_dsc@hpss.world (am_contxt_id),
	foreign key (am_place_id) references amico_TD_plac_info@hpss.world (am_place_id)
);

CREATE TABLE amico_wk_cri_resp@hpss.world
(
	am_work_id		varchar(100),
	am_critiq_desc		varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_exhibit@hpss.world
(
	am_work_id		varchar(100),
	am_exhib_when		varchar(50),
	am_exhib_where		integer,
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (am_exhib_where) references amico_TD_plac_info@hpss.world (am_place_id)
);

CREATE TABLE amico_wk_ownr_plac@hpss.world
(
	am_work_id		varchar(100),
	am_owner_id		integer,
	am_place_id		integer,
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (am_owner_id) references amico_TD_owner_core@hpss.world (am_owner_id),
	foreign key (am_place_id) references amico_TD_plac_info@hpss.world (am_place_id)
);

CREATE TABLE amico_wk_ownr_acno@hpss.world
(
	am_work_id		varchar(100),
	am_owner_id		integer,
	am_acc_num		varchar(200),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (am_owner_id) references amico_TD_owner_core@hpss.world (am_owner_id)
);

CREATE TABLE amico_wk_ownr_crdt@hpss.world
(
	am_work_id		varchar(100),
	am_owner_id		integer,
	am_credit_line		varchar(400),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (am_owner_id) references amico_TD_owner_core@hpss.world (am_owner_id)
);

CREATE TABLE amico_wk_ownr_prov@hpss.world
(
	am_work_id		varchar(100),
	am_owner_id		integer,
	am_provenance		varchar(400),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (am_owner_id) references amico_TD_owner_core@hpss.world (am_owner_id)
);

CREATE TABLE amico_wk_copyright@hpss.world
(
	am_work_id		varchar(100),
	am_owner_id		integer,
	am_cpyrt_stmt		varchar(700),
	am_cpyrt_link		varchar(700),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (am_owner_id) references amico_TD_owner_core@hpss.world (am_owner_id)
);

CREATE TABLE amico_wk_rel_works@hpss.world
(
	am_work_id		varchar(100),
	am_rel_work_id		varchar(100),
	relation_type_id	integer,
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (am_rel_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (relation_type_id) references DC_TD_RELATION_TYP (relation_type_id)
);

CREATE TABLE amico_wk_rel_othr@hpss.world
(
	am_work_id		varchar(100),
	data_id			varchar(100),
	am_rel_wk_type_id	varchar(100),
	relation_type_id	integer,
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (data_id) references MDAS_AD_REPL (data_id),
	foreign key (relation_type_id) references DC_TD_RELATION_TYP (relation_type_id),
	foreign key (am_rel_wk_type_id) references DC_TD_TYPE (dc_type_id)
);


CREATE TABLE amico_wk_catperson@hpss.world
(
	am_work_id		varchar(100),
	am_cataloguer		varchar(200),
	am_cat_date		varchar(50),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_media_inf@hpss.world
(
	am_work_id		varchar(100),
	am_validated_date	varchar(50),
	am_validated_vers	varchar(100),
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_wk_media_dp@hpss.world
(
	am_work_id		varchar(100),
	am_deletion_flag	varchar(5),
	am_dp_year		integer,
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id)
);

CREATE TABLE amico_mcatimage@hpss.world
(
	am_work_id		varchar(100),
	data_id			integer,
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (data_id) references MDAS_AD_REPL(data_id)
);

CREATE TABLE amico_mcatthumbnail@hpss.world
(
	am_work_id		varchar(100),
	data_id			integer,
	foreign key (am_work_id) references amico_TD_work_core@hpss.world (am_work_id),
	foreign key (data_id) references MDAS_AD_REPL(data_id)
);