schema COAPayload {
  id_header number
  kode string required
  nama string required
  deskripsi string
  aktif boolean required
}


schema JurnalPayload {
  deskripsi string
  nomor_referensi string

  // ISO 8601
  tanggal string required

  list_item array schema ItemJurnalPayload {
    id_coa number required
    nomor_referensi string
    debit number required
    kredit number required
    deskripsi string
  } required
}


table COA {
  id bigint pk inc notnull
  id_header COA.id
  kode varchar(15) notnull
  nama varchar(255) notnull
  deksripsi text
  aktif boolean notnull default=true
}

table Jurnal {
  id bigint pk inc notnull
  deskripsi text
  nomor_referensi varchar(255)
  tanggal date notnull
  created_at timestamp notnull
}

table ItemJurnal {
  id bigint pk inc notnull
  id_coa COA.id notnull
  id_jurnal Jurnal.id notnull
  nomor_referensi varchar(255)
  debit bigint notnull default=0
  kredit bigint notnull default=0
  deskripsi text
}


// >>> COA
api get /coa {
  description data coa
  headers {
    authorization string required
  }
  query {
    q string
    limit number
    offset number
  }
  return schema GetCOAData {
    total number required
    data array table.COA required
  } required
}

api post /coa {
  description tambah coa
  headers {
    authorization string required
  }
  body {
    data schema.COAPayload required
  }
  return table.COA required
}

api get /coa/:kode {
  description detail coa
  headers {
    authorization string required
  }
  path {
    kode string required
  }
  return table.COA required
}

api put /coa/:kode {
  description update coa
  headers {
    authorization string required
  }
  path {
    kode string required
  }
  body {
    data schema.COAPayload required
  }
  return table.COA required
}

api delete /coa/:kode {
  description hapus coa
  headers {
    authorization string required
  }
  path {
    kode string required
  }
  return table.COA required
}

// >>> Jurnal
api get /jurnal {
  description data jurnal
  headers {
    authorization string required
  }
  query {
    q string
    limit number
    offset number
  }
  return schema GetJurnalData {
    total number required
    data array table.Jurnal required
  } required
}

api post /jurnal {
  description tambah jurnal
  headers {
    authorization string required
  }
  body {
    data schema.JurnalPayload required
  }
  return table.Jurnal required
}

api get /jurnal/:id {
  description detail jurnal
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Jurnal required
}

api put /jurnal/:id {
  description update jurnal
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.JurnalPayload required
  }
  return table.Jurnal required
}

api delete /jurnal/:id {
  description hapus jurnal
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Jurnal required
}
