Honeymoon Apr 2026

-- Romantic add-ons (e.g., candlelight dinner, couple massage) CREATE TABLE honeymoon_addons ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), name VARCHAR(255), price DECIMAL(10,2), location_specific BOOLEAN DEFAULT FALSE, location_id UUID REFERENCES locations(id) );

-- User's booked honeymoon CREATE TABLE honeymoon_bookings ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), profile_id UUID REFERENCES honeymoon_profiles(id), package_id UUID REFERENCES honeymoon_packages(id), booking_date TIMESTAMP DEFAULT NOW(), check_in DATE, check_out DATE, total_price DECIMAL(10,2), status VARCHAR(20) DEFAULT 'confirmed' ); honeymoon

-- Join table for booking add-ons CREATE TABLE booking_addons ( booking_id UUID REFERENCES honeymoon_bookings(id), addon_id UUID REFERENCES honeymoon_addons(id), quantity INT DEFAULT 1 ); POST /api/honeymoon/profile Create or update honeymoon profile. -- Romantic add-ons (e