CREATE VIEW BasicCalendarPeriods AS
SELECT
  UUID,
  DI000475,
  DI000987,
  DI000997,
  DI000999,
  /* FOREIGN KEYS */
  (SELECT UUID FROM DT418 WHERE DT418.DI000305 = DT430.DI000475) "calendarUUID"
FROM DT430