Skip to main content

JSON Files

airline.json​

{
  "airline": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "airline",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "airline_name": {
        "index": true,
        "name": "airline_name",
        "length": 128,
        "type": "String",
        "required": true
      },
      "airline_code": {
        "index": true,
        "name": "airline_code",
        "length": 128,
        "type": "String",
        "required": true
      },
      "status": {
        "index": true,
        "name": "status",
        "length": 128,
        "type": "String",
        "required": false
      }
    }
  }
}

airline_admin.json​

{
  "airline_admin": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "airline_admin",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "email": {
        "index": false,
        "name": "email",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "password": {
        "index": false,
        "name": "password",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "name": {
        "index": false,
        "name": "name",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "airline_id": {
        "index": false,
        "name": "airline_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "airline"
        }
      },
      "status": {
        "index": false,
        "name": "status",
        "length": 128,
        "type": "String",
        "required": false
      }
    }
  }
}

booking.json​

{
  "booking": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "booking",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "flight_id": {
        "index": false,
        "name": "flight_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "flight"
        }
      },
      "user_id": {
        "index": false,
        "name": "user_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "user"
        }
      },
      "booking_date_and_time": {
        "index": false,
        "name": "booking_date_and_time",
        "length": 128,
        "type": "timestamp",
        "required": false
      },
      "status": {
        "index": false,
        "name": "status",
        "length": 128,
        "type": "String",
        "required": false
      },
      "confirmation_number": {
        "index": false,
        "name": "confirmation_number",
        "length": 128,
        "type": "String",
        "required": false
      }
    }
  }
}

document.json​

{
  "document": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "document",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "document_name": {
        "index": false,
        "name": "document_name",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "file_format": {
        "index": false,
        "name": "file_format",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "file_size": {
        "index": false,
        "name": "file_size",
        "length": 128,
        "required": false,
        "type": "String"
      },
      "passenger_id": {
        "index": false,
        "name": "passenger_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "passenger"
        }
      }
    }
  }
}

flight.json​

{
  "flight": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "flight",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "airline_id": {
        "index": false,
        "name": "airline_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "airline"
        }
      },
      "airline_name": {
        "index": false,
        "name": "airline_name",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign_derived": {
          "parent_field": "airline_id",
          "foreign_field": "airline_name"
        }
      },
      "destination_location_id": {
        "index": false,
        "name": "destination_location_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "location"
        }
      },
      "departure_location_id": {
        "index": false,
        "name": "departure_location_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "location"
        }
      },
      "departure_date_and_time": {
        "index": false,
        "name": "departure_date_and_time",
        "length": 128,
        "type": "timestamp",
        "required": false
      },
      "arrival_date_and_time": {
        "index": false,
        "name": "arrival_date_and_time",
        "length": 128,
        "type": "timestamp",
        "required": false
      },
      "status": {
        "index": false,
        "name": "status",
        "length": 128,
        "type": "String",
        "required": false
      },
      "price": {
        "index": false,
        "name": "status",
        "type": "long",
        "required": false
      },
      "capacity": {
        "index": false,
        "name": "status",
        "type": "long",
        "required": false
      }
    }
  }
}

location.json​

{
  "location": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "location",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "location_name": {
        "index": true,
        "name": "location_name",
        "length": 128,
        "type": "String",
        "required": true
      },
      "location_code": {
        "index": true,
        "name": "location_code",
        "length": 128,
        "type": "String",
        "required": true
      },
      "status": {
        "index": true,
        "name": "status",
        "length": 128,
        "type": "String",
        "required": false
      }
    }
  }
}

passenger.json​

{
  "passenger": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "passenger",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "email": {
        "index": false,
        "name": "email",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "first_name": {
        "index": false,
        "name": "first_name",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "last_name": {
        "index": false,
        "name": "last_name",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "gender": {
        "index": false,
        "name": "gender",
        "length": 128,
        "required": false,
        "type": "String"
      },
      "dob": {
        "index": false,
        "name": "dob",
        "length": 128,
        "type": "String",
        "required": false
      },
      "phone_no": {
        "index": false,
        "name": "phone_no",
        "length": 15,
        "type": "String",
        "required": false
      },
      "user_id": {
        "index": false,
        "name": "user_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "user"
        }
      },
      "booking_id": {
        "index": false,
        "name": "booking_id",
        "length": 128,
        "type": "String",
        "required": false,
        "foreign": {
          "resource": "booking"
        }
      }
    }
  }
}

super_admin.json​

{
  "super_admin": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "super_admin",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "email": {
        "index": false,
        "name": "email",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "password": {
        "index": false,
        "name": "password",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "name": {
        "index": false,
        "name": "name",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "status": {
        "index": false,
        "name": "status",
        "length": 128,
        "type": "String",
        "required": false
      }
    }
  }
}

user.json​

{
  "user": {
    "cluster": "DB_PROFILE",
    "ui": false,
    "api": true,
    "display_name": "user",
    "fields": {
      "id": {
        "index": true,
        "name": "id",
        "length": 40,
        "required": true,
        "type": "String"
      },
      "email": {
        "index": false,
        "name": "email",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "password": {
        "index": false,
        "name": "password",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "name": {
        "index": false,
        "name": "name",
        "length": 128,
        "required": true,
        "type": "String"
      },
      "gender": {
        "index": false,
        "name": "gender",
        "length": 128,
        "required": false,
        "type": "String"
      },
      "dob": {
        "index": false,
        "name": "dob",
        "length": 128,
        "type": "String",
        "required": false
      },
      "phone_no": {
        "index": false,
        "name": "phone_no",
        "length": 15,
        "type": "String",
        "required": false
      }
    }
  }
}