schema {
  query: query_root
  mutation: mutation_root
  subscription: subscription_root
}

"""
expression to compare columns of type boolean. All fields are combined with logical 'AND'.
"""
input boolean_comparison_exp {
  _eq: Boolean
  _gt: Boolean
  _gte: Boolean
  _in: [Boolean]
  _is_null: Boolean
  _lt: Boolean
  _lte: Boolean
  _neq: Boolean
  _nin: [Boolean]
}

"""conflict action"""
enum conflict_action {
  """ignore the insert on this row"""
  ignore

  """update the row with the given values"""
  update
}

"""
columns and relationships of "customer"
"""
type customer {
  companyname: String
  customernumber: String
  dateofbirth: date
  email: String
  firstname: String
  gender: String
  homephone: String
  id: uuid!
  mobilephone: String
  modifiedon: timestamp
  surname: String
}

"""
aggregated selection of "customer"
"""
type customer_aggregate {
  aggregate: customer_aggregate_fields
  nodes: [customer!]!
}

"""
aggregate fields of "customer"
"""
type customer_aggregate_fields {
  count(columns: [customer_select_column!], distinct: Boolean): Int
  max: customer_max_fields
  min: customer_min_fields
}

"""
input type for inserting array relation for remote table "customer"
"""
input customer_arr_rel_insert_input {
  data: [customer_insert_input!]!
  on_conflict: customer_on_conflict
}

"""
Boolean expression to filter rows from the table "customer". All fields are combined with a logical 'AND'.
"""
input customer_bool_exp {
  _and: [customer_bool_exp]
  _not: customer_bool_exp
  _or: [customer_bool_exp]
  companyname: varchar_comparison_exp
  customernumber: varchar_comparison_exp
  dateofbirth: date_comparison_exp
  email: varchar_comparison_exp
  firstname: varchar_comparison_exp
  gender: varchar_comparison_exp
  homephone: varchar_comparison_exp
  id: uuid_comparison_exp
  mobilephone: varchar_comparison_exp
  modifiedon: timestamp_comparison_exp
  surname: varchar_comparison_exp
}

"""
unique or primary key constraints on table "customer"
"""
enum customer_constraint {
  """unique or primary key constraint"""
  customer_pkey
}

"""
input type for inserting data into table "customer"
"""
input customer_insert_input {
  companyname: String
  customernumber: String
  dateofbirth: date
  email: String
  firstname: String
  gender: String
  homephone: String
  id: uuid
  mobilephone: String
  modifiedon: timestamp
  surname: String
}

"""aggregate max on columns"""
type customer_max_fields {
  companyname: String
  customernumber: String
  dateofbirth: date
  email: String
  firstname: String
  gender: String
  homephone: String
  mobilephone: String
  surname: String
}

"""aggregate min on columns"""
type customer_min_fields {
  companyname: String
  customernumber: String
  dateofbirth: date
  email: String
  firstname: String
  gender: String
  homephone: String
  mobilephone: String
  surname: String
}

"""
response of any mutation on the table "customer"
"""
type customer_mutation_response {
  """number of affected rows by the mutation"""
  affected_rows: Int!

  """data of the affected rows by the mutation"""
  returning: [customer!]!
}

"""
input type for inserting object relation for remote table "customer"
"""
input customer_obj_rel_insert_input {
  data: customer_insert_input!
  on_conflict: customer_on_conflict
}

"""
on conflict condition type for table "customer"
"""
input customer_on_conflict {
  """action when conflict occurs (deprecated)"""
  action: conflict_action
  constraint: customer_constraint!
  update_columns: [customer_update_column!]
}

"""
ordering options when selecting data from "customer"
"""
input customer_order_by {
  companyname: order_by
  customernumber: order_by
  dateofbirth: order_by
  email: order_by
  firstname: order_by
  gender: order_by
  homephone: order_by
  id: order_by
  mobilephone: order_by
  modifiedon: order_by
  surname: order_by
}

"""
select columns of table "customer"
"""
enum customer_select_column {
  """column name"""
  companyname

  """column name"""
  customernumber

  """column name"""
  dateofbirth

  """column name"""
  email

  """column name"""
  firstname

  """column name"""
  gender

  """column name"""
  homephone

  """column name"""
  id

  """column name"""
  mobilephone

  """column name"""
  modifiedon

  """column name"""
  surname
}

"""
input type for updating data in table "customer"
"""
input customer_set_input {
  companyname: String
  customernumber: String
  dateofbirth: date
  email: String
  firstname: String
  gender: String
  homephone: String
  id: uuid
  mobilephone: String
  modifiedon: timestamp
  surname: String
}

"""
update columns of table "customer"
"""
enum customer_update_column {
  """column name"""
  companyname

  """column name"""
  customernumber

  """column name"""
  dateofbirth

  """column name"""
  email

  """column name"""
  firstname

  """column name"""
  gender

  """column name"""
  homephone

  """column name"""
  id

  """column name"""
  mobilephone

  """column name"""
  modifiedon

  """column name"""
  surname
}

scalar date

"""
expression to compare columns of type date. All fields are combined with logical 'AND'.
"""
input date_comparison_exp {
  _eq: date
  _gt: date
  _gte: date
  _in: [date]
  _is_null: Boolean
  _lt: date
  _lte: date
  _neq: date
  _nin: [date]
}

"""
columns and relationships of "email"
"""
type email {
  """An object relationship"""
  email_customer: customer

  """An array relationship"""
  email_transaction(
    """distinct select on columns"""
    distinct_on: [emailtransaction_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [emailtransaction_order_by!]

    """filter the rows returned"""
    where: emailtransaction_bool_exp
  ): [emailtransaction!]!

  """An aggregated array relationship"""
  email_transaction_aggregate(
    """distinct select on columns"""
    distinct_on: [emailtransaction_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [emailtransaction_order_by!]

    """filter the rows returned"""
    where: emailtransaction_bool_exp
  ): emailtransaction_aggregate!
  emailbody: String
  id: uuid!
  issend: Boolean
  metadata: jsonb
  notificationtype: String
  recipientemail: String
  senderemail: String
  subject: String
}

"""
aggregated selection of "email"
"""
type email_aggregate {
  aggregate: email_aggregate_fields
  nodes: [email!]!
}

"""
aggregate fields of "email"
"""
type email_aggregate_fields {
  count(columns: [email_select_column!], distinct: Boolean): Int
  max: email_max_fields
  min: email_min_fields
}

"""append existing jsonb value of filtered columns with new jsonb value"""
input email_append_input {
  metadata: jsonb
}

"""
input type for inserting array relation for remote table "email"
"""
input email_arr_rel_insert_input {
  data: [email_insert_input!]!
  on_conflict: email_on_conflict
}

"""
Boolean expression to filter rows from the table "email". All fields are combined with a logical 'AND'.
"""
input email_bool_exp {
  _and: [email_bool_exp]
  _not: email_bool_exp
  _or: [email_bool_exp]
  email_customer: customer_bool_exp
  email_transaction: emailtransaction_bool_exp
  emailbody: text_comparison_exp
  id: uuid_comparison_exp
  issend: boolean_comparison_exp
  metadata: jsonb_comparison_exp
  notificationtype: varchar_comparison_exp
  recipientemail: varchar_comparison_exp
  senderemail: varchar_comparison_exp
  subject: varchar_comparison_exp
}

"""
unique or primary key constraints on table "email"
"""
enum email_constraint {
  """unique or primary key constraint"""
  email_pkey
}

"""
delete the field or element with specified path (for JSON arrays, negative integers count from the end)
"""
input email_delete_at_path_input {
  metadata: [String]
}

"""
delete the array element with specified index (negative integers count from the
end). throws an error if top level container is not an array
"""
input email_delete_elem_input {
  metadata: Int
}

"""
delete key/value pair or string element. key/value pairs are matched based on their key value
"""
input email_delete_key_input {
  metadata: String
}

"""
input type for inserting data into table "email"
"""
input email_insert_input {
  email_customer: customer_obj_rel_insert_input
  email_transaction: emailtransaction_arr_rel_insert_input
  emailbody: String
  id: uuid
  issend: Boolean
  metadata: jsonb
  notificationtype: String
  recipientemail: String
  senderemail: String
  subject: String
}

"""aggregate max on columns"""
type email_max_fields {
  emailbody: String
  notificationtype: String
  recipientemail: String
  senderemail: String
  subject: String
}

"""aggregate min on columns"""
type email_min_fields {
  emailbody: String
  notificationtype: String
  recipientemail: String
  senderemail: String
  subject: String
}

"""
response of any mutation on the table "email"
"""
type email_mutation_response {
  """number of affected rows by the mutation"""
  affected_rows: Int!

  """data of the affected rows by the mutation"""
  returning: [email!]!
}

"""
input type for inserting object relation for remote table "email"
"""
input email_obj_rel_insert_input {
  data: email_insert_input!
  on_conflict: email_on_conflict
}

"""
on conflict condition type for table "email"
"""
input email_on_conflict {
  """action when conflict occurs (deprecated)"""
  action: conflict_action
  constraint: email_constraint!
  update_columns: [email_update_column!]
}

"""
ordering options when selecting data from "email"
"""
input email_order_by {
  email_customer: customer_order_by
  emailbody: order_by
  id: order_by
  issend: order_by
  metadata: order_by
  notificationtype: order_by
  recipientemail: order_by
  senderemail: order_by
  subject: order_by
}

"""prepend existing jsonb value of filtered columns with new jsonb value"""
input email_prepend_input {
  metadata: jsonb
}

"""
select columns of table "email"
"""
enum email_select_column {
  """column name"""
  emailbody

  """column name"""
  id

  """column name"""
  issend

  """column name"""
  metadata

  """column name"""
  notificationtype

  """column name"""
  recipientemail

  """column name"""
  senderemail

  """column name"""
  subject
}

"""
input type for updating data in table "email"
"""
input email_set_input {
  emailbody: String
  id: uuid
  issend: Boolean
  metadata: jsonb
  notificationtype: String
  recipientemail: String
  senderemail: String
  subject: String
}

"""
update columns of table "email"
"""
enum email_update_column {
  """column name"""
  emailbody

  """column name"""
  id

  """column name"""
  issend

  """column name"""
  metadata

  """column name"""
  notificationtype

  """column name"""
  recipientemail

  """column name"""
  senderemail

  """column name"""
  subject
}

"""
columns and relationships of "emailtransaction"
"""
type emailtransaction {
  deliveredon: timestamp
  emailid: uuid!
  id: uuid!
}

"""
aggregated selection of "emailtransaction"
"""
type emailtransaction_aggregate {
  aggregate: emailtransaction_aggregate_fields
  nodes: [emailtransaction!]!
}

"""
aggregate fields of "emailtransaction"
"""
type emailtransaction_aggregate_fields {
  count(columns: [emailtransaction_select_column!], distinct: Boolean): Int
}

"""
input type for inserting array relation for remote table "emailtransaction"
"""
input emailtransaction_arr_rel_insert_input {
  data: [emailtransaction_insert_input!]!
  on_conflict: emailtransaction_on_conflict
}

"""
Boolean expression to filter rows from the table "emailtransaction". All fields are combined with a logical 'AND'.
"""
input emailtransaction_bool_exp {
  _and: [emailtransaction_bool_exp]
  _not: emailtransaction_bool_exp
  _or: [emailtransaction_bool_exp]
  deliveredon: timestamp_comparison_exp
  emailid: uuid_comparison_exp
  id: uuid_comparison_exp
}

"""
unique or primary key constraints on table "emailtransaction"
"""
enum emailtransaction_constraint {
  """unique or primary key constraint"""
  emailtransaction_pkey
}

"""
input type for inserting data into table "emailtransaction"
"""
input emailtransaction_insert_input {
  deliveredon: timestamp
  emailid: uuid
  id: uuid
}

"""
response of any mutation on the table "emailtransaction"
"""
type emailtransaction_mutation_response {
  """number of affected rows by the mutation"""
  affected_rows: Int!

  """data of the affected rows by the mutation"""
  returning: [emailtransaction!]!
}

"""
input type for inserting object relation for remote table "emailtransaction"
"""
input emailtransaction_obj_rel_insert_input {
  data: emailtransaction_insert_input!
  on_conflict: emailtransaction_on_conflict
}

"""
on conflict condition type for table "emailtransaction"
"""
input emailtransaction_on_conflict {
  """action when conflict occurs (deprecated)"""
  action: conflict_action
  constraint: emailtransaction_constraint!
  update_columns: [emailtransaction_update_column!]
}

"""
ordering options when selecting data from "emailtransaction"
"""
input emailtransaction_order_by {
  deliveredon: order_by
  emailid: order_by
  id: order_by
}

"""
select columns of table "emailtransaction"
"""
enum emailtransaction_select_column {
  """column name"""
  deliveredon

  """column name"""
  emailid

  """column name"""
  id
}

"""
input type for updating data in table "emailtransaction"
"""
input emailtransaction_set_input {
  deliveredon: timestamp
  emailid: uuid
  id: uuid
}

"""
update columns of table "emailtransaction"
"""
enum emailtransaction_update_column {
  """column name"""
  deliveredon

  """column name"""
  emailid

  """column name"""
  id
}

scalar jsonb

"""
expression to compare columns of type jsonb. All fields are combined with logical 'AND'.
"""
input jsonb_comparison_exp {
  """is the column contained in the given json value"""
  _contained_in: jsonb

  """does the column contain the given json value at the top level"""
  _contains: jsonb
  _eq: jsonb
  _gt: jsonb
  _gte: jsonb

  """does the string exist as a top-level key in the column"""
  _has_key: String

  """do all of these strings exist as top-level keys in the column"""
  _has_keys_all: [String!]

  """do any of these strings exist as top-level keys in the column"""
  _has_keys_any: [String!]
  _in: [jsonb]
  _is_null: Boolean
  _lt: jsonb
  _lte: jsonb
  _neq: jsonb
  _nin: [jsonb]
}

"""mutation root"""
type mutation_root {
  """
  delete data from the table: "customer"
  """
  delete_customer(
    """filter the rows which have to be deleted"""
    where: customer_bool_exp!
  ): customer_mutation_response

  """
  delete data from the table: "email"
  """
  delete_email(
    """filter the rows which have to be deleted"""
    where: email_bool_exp!
  ): email_mutation_response

  """
  delete data from the table: "emailtransaction"
  """
  delete_emailtransaction(
    """filter the rows which have to be deleted"""
    where: emailtransaction_bool_exp!
  ): emailtransaction_mutation_response

  """
  insert data into the table: "customer"
  """
  insert_customer(
    """the rows to be inserted"""
    objects: [customer_insert_input!]!

    """on conflict condition"""
    on_conflict: customer_on_conflict
  ): customer_mutation_response

  """
  insert data into the table: "email"
  """
  insert_email(
    """the rows to be inserted"""
    objects: [email_insert_input!]!

    """on conflict condition"""
    on_conflict: email_on_conflict
  ): email_mutation_response

  """
  insert data into the table: "emailtransaction"
  """
  insert_emailtransaction(
    """the rows to be inserted"""
    objects: [emailtransaction_insert_input!]!

    """on conflict condition"""
    on_conflict: emailtransaction_on_conflict
  ): emailtransaction_mutation_response

  """
  update data of the table: "customer"
  """
  update_customer(
    """sets the columns of the filtered rows to the given values"""
    _set: customer_set_input

    """filter the rows which have to be updated"""
    where: customer_bool_exp!
  ): customer_mutation_response

  """
  update data of the table: "email"
  """
  update_email(
    """append existing jsonb value of filtered columns with new jsonb value"""
    _append: email_append_input

    """
    delete the field or element with specified path (for JSON arrays, negative integers count from the end)
    """
    _delete_at_path: email_delete_at_path_input

    """
    delete the array element with specified index (negative integers count from
    the end). throws an error if top level container is not an array
    """
    _delete_elem: email_delete_elem_input

    """
    delete key/value pair or string element. key/value pairs are matched based on their key value
    """
    _delete_key: email_delete_key_input

    """prepend existing jsonb value of filtered columns with new jsonb value"""
    _prepend: email_prepend_input

    """sets the columns of the filtered rows to the given values"""
    _set: email_set_input

    """filter the rows which have to be updated"""
    where: email_bool_exp!
  ): email_mutation_response

  """
  update data of the table: "emailtransaction"
  """
  update_emailtransaction(
    """sets the columns of the filtered rows to the given values"""
    _set: emailtransaction_set_input

    """filter the rows which have to be updated"""
    where: emailtransaction_bool_exp!
  ): emailtransaction_mutation_response
}

"""column ordering options"""
enum order_by {
  """in the ascending order, nulls last"""
  asc

  """in the ascending order, nulls first"""
  asc_nulls_first

  """in the ascending order, nulls last"""
  asc_nulls_last

  """in the descending order, nulls first"""
  desc

  """in the descending order, nulls first"""
  desc_nulls_first

  """in the descending order, nulls last"""
  desc_nulls_last
}

"""query root"""
type query_root {
  """
  fetch data from the table: "customer"
  """
  customer(
    """distinct select on columns"""
    distinct_on: [customer_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [customer_order_by!]

    """filter the rows returned"""
    where: customer_bool_exp
  ): [customer!]!

  """
  fetch aggregated fields from the table: "customer"
  """
  customer_aggregate(
    """distinct select on columns"""
    distinct_on: [customer_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [customer_order_by!]

    """filter the rows returned"""
    where: customer_bool_exp
  ): customer_aggregate!

  """
  fetch data from the table: "email"
  """
  email(
    """distinct select on columns"""
    distinct_on: [email_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [email_order_by!]

    """filter the rows returned"""
    where: email_bool_exp
  ): [email!]!

  """
  fetch aggregated fields from the table: "email"
  """
  email_aggregate(
    """distinct select on columns"""
    distinct_on: [email_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [email_order_by!]

    """filter the rows returned"""
    where: email_bool_exp
  ): email_aggregate!

  """
  fetch data from the table: "emailtransaction"
  """
  emailtransaction(
    """distinct select on columns"""
    distinct_on: [emailtransaction_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [emailtransaction_order_by!]

    """filter the rows returned"""
    where: emailtransaction_bool_exp
  ): [emailtransaction!]!

  """
  fetch aggregated fields from the table: "emailtransaction"
  """
  emailtransaction_aggregate(
    """distinct select on columns"""
    distinct_on: [emailtransaction_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [emailtransaction_order_by!]

    """filter the rows returned"""
    where: emailtransaction_bool_exp
  ): emailtransaction_aggregate!
}

"""subscription root"""
type subscription_root {
  """
  fetch data from the table: "customer"
  """
  customer(
    """distinct select on columns"""
    distinct_on: [customer_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [customer_order_by!]

    """filter the rows returned"""
    where: customer_bool_exp
  ): [customer!]!

  """
  fetch aggregated fields from the table: "customer"
  """
  customer_aggregate(
    """distinct select on columns"""
    distinct_on: [customer_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [customer_order_by!]

    """filter the rows returned"""
    where: customer_bool_exp
  ): customer_aggregate!

  """
  fetch data from the table: "email"
  """
  email(
    """distinct select on columns"""
    distinct_on: [email_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [email_order_by!]

    """filter the rows returned"""
    where: email_bool_exp
  ): [email!]!

  """
  fetch aggregated fields from the table: "email"
  """
  email_aggregate(
    """distinct select on columns"""
    distinct_on: [email_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [email_order_by!]

    """filter the rows returned"""
    where: email_bool_exp
  ): email_aggregate!

  """
  fetch data from the table: "emailtransaction"
  """
  emailtransaction(
    """distinct select on columns"""
    distinct_on: [emailtransaction_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [emailtransaction_order_by!]

    """filter the rows returned"""
    where: emailtransaction_bool_exp
  ): [emailtransaction!]!

  """
  fetch aggregated fields from the table: "emailtransaction"
  """
  emailtransaction_aggregate(
    """distinct select on columns"""
    distinct_on: [emailtransaction_select_column!]

    """limit the nuber of rows returned"""
    limit: Int

    """skip the first n rows. Use only with order_by"""
    offset: Int

    """sort the rows by one or more columns"""
    order_by: [emailtransaction_order_by!]

    """filter the rows returned"""
    where: emailtransaction_bool_exp
  ): emailtransaction_aggregate!
}

"""
expression to compare columns of type text. All fields are combined with logical 'AND'.
"""
input text_comparison_exp {
  _eq: String
  _gt: String
  _gte: String
  _ilike: String
  _in: [String]
  _is_null: Boolean
  _like: String
  _lt: String
  _lte: String
  _neq: String
  _nilike: String
  _nin: [String]
  _nlike: String
  _nsimilar: String
  _similar: String
}

scalar timestamp

"""
expression to compare columns of type timestamp. All fields are combined with logical 'AND'.
"""
input timestamp_comparison_exp {
  _eq: timestamp
  _gt: timestamp
  _gte: timestamp
  _in: [timestamp]
  _is_null: Boolean
  _lt: timestamp
  _lte: timestamp
  _neq: timestamp
  _nin: [timestamp]
}

scalar uuid

"""
expression to compare columns of type uuid. All fields are combined with logical 'AND'.
"""
input uuid_comparison_exp {
  _eq: uuid
  _gt: uuid
  _gte: uuid
  _in: [uuid]
  _is_null: Boolean
  _lt: uuid
  _lte: uuid
  _neq: uuid
  _nin: [uuid]
}

"""
expression to compare columns of type varchar. All fields are combined with logical 'AND'.
"""
input varchar_comparison_exp {
  _eq: String
  _gt: String
  _gte: String
  _ilike: String
  _in: [String]
  _is_null: Boolean
  _like: String
  _lt: String
  _lte: String
  _neq: String
  _nilike: String
  _nin: [String]
  _nlike: String
  _nsimilar: String
  _similar: String
}