Hospitality Service Management Schema

Part 1: Node.js Initialization Script

This script initializes the collections and seeds them with sample data to represent the schema structure. It ensures the Core System Tables and Service-Specific Tables are linked correctly using the Firebase Admin SDK.

const admin = require('firebase-admin');
const serviceAccount = require('./path/to/serviceAccountKey.json');

admin.initializeApp({
  credential: admin.credential.cert(serviceAccount)
});

const db = admin.firestore();

async function createHospitalitySchema() {
  
  // ======================================================
  // 1. CORE SYSTEM TABLES (Users & Master_Requests) [1], [2]
  // ======================================================

  // --- Table: Users [1] ---
  // Creating a Guest Profile
  const guestRef = db.collection('users').doc('guest_123');
  await guestRef.set({
    role: 'GUEST',           // Source [1]
    name: 'John Doe',
    room_number: '101',      // Source [1]
    language_pref: 'en'      // Source [1]
  });

  // Creating a Staff Profile
  const staffRef = db.collection('users').doc('staff_456');
  await staffRef.set({
    role: 'STAFF',           // Source [1]
    name: 'Alice Manager',
    department: 'HOUSEKEEPING'
  });

  console.log("Users created.");

  // --- Table: Master_Requests [2] ---
  // The central list used by Staff to view "Open" tasks
  const requestRef = db.collection('master_requests').doc('req_001');
  await requestRef.set({
    guest_id: 'guest_123',       // Linked to Users [2]
    service_type: 'HOUSEKEEPING',// Source [2]
    status: 'PENDING',           // Source [2]
    assigned_staff_id: null,     // Initially unassigned [2]
    created_at: admin.firestore.FieldValue.serverTimestamp()
  });

  console.log("Master Request created.");

  // ======================================================
  // 2. SERVICE-SPECIFIC TABLES (Top 5 Services) [3] - [4]
  // ======================================================

  // --- Service 1: Housekeeping Details [3] ---
  // Focus: Extra towels, toiletries
  await db.collection('housekeeping_details').add({
    request_id: 'req_001',       // FK to Master_Requests [3]
    item_name: 'TOWELS',         // ENUM Source [3]
    quantity: 2,
    allergy_note: 'None'         // Source [3]
  });

  // --- Service 2: Dining Orders [5] ---
  // Focus: On-demand dining, dietary restrictions
  await db.collection('dining_orders').add({
    request_id: 'req_002',       // Link to a dining master request
    menu_item_id: 55,            // Linked to Menu Catalog [5]
    special_instructions: 'Gluten-free', // Source [5]
    delivery_time: '2023-10-27T19:00:00Z' // Source [5]
  });

  // --- Service 3: Transport Bookings [6] ---
  // Focus: Airport Pickups, Flight Data
  await db.collection('transport_bookings').add({
    request_id: 'req_003',
    pickup_type: 'AIRPORT_SHUTTLE', // Source [6]
    destination: 'JFK Airport',
    flight_number: 'UA990',         // Source [6]
    pickup_time: '2023-10-28T08:00:00Z'
  });

  // --- Service 4: Front Desk Requests [4] ---
  // Focus: Late Check-Out, Upgrades
  await db.collection('front_desk_requests').add({
    request_id: 'req_004',
    request_type: 'LATE_CHECKOUT',  // Source [4]
    requested_time: '14:00',
    upgrade_pref: 'Sea View Suite'  // Source [4]
  });

  // --- Service 5: Maintenance Tickets [4], [7] ---
  // Focus: Repairs, Workflow Automation
  await db.collection('maintenance_tickets').add({
    request_id: 'req_005',
    issue_category: 'PLUMBING',     // Source [4]
    description: 'Sink is leaking', // Source [4]
    severity: 'MEDIUM',             // Source [4]
    is_automated: false             // Source [4]
  });

  console.log("Service specific tables populated.");
}

createHospitalitySchema();