-- View: public.BookingsTimeStatus

-- DROP VIEW public."BookingsTimeStatus";

CREATE OR REPLACE VIEW public."BookingTimeStatus"
 AS
 SELECT "Booking".id,
    "Booking".uid,
    "Booking"."eventTypeId",
    "Booking".title,
    "Booking".description,
    "Booking"."startTime",
    "Booking"."endTime",
    "Booking"."createdAt",
    "Booking".location,
    "Booking".paid,
    "Booking".status,
    "Booking".rescheduled,
    "Booking"."userId",
    "et"."teamId",
	  "et"."length" as "eventLength",
      CASE
          WHEN "Booking".rescheduled IS TRUE THEN 'rescheduled'::text
          WHEN "Booking".status = 'cancelled'::"BookingStatus" AND "Booking".rescheduled IS NULL THEN 'cancelled'::text
          WHEN "Booking"."endTime" < now() THEN 'completed'::text
          WHEN "Booking"."endTime" > now() THEN 'uncompleted'::text
          ELSE NULL::text
      END AS "timeStatus",
	  "et"."parentId" as "eventParentId"
   FROM "Booking"
    LEFT JOIN "EventType" et ON "Booking"."eventTypeId" = et.id
	  LEFT JOIN "Membership" mb ON "mb"."userId" = "Booking"."userId";