wip:modifications to guarantor related services
update ddl, reference data and demo schemas based on patch