api get /admin/jenis-kendaraan {
  headers {
    authorization string required
  }
  return schema AdminJenisKendaraanResult {
    total number required
    data array table.JenisKendaraan required
  } required
}

api get /admin/jenis-kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.JenisKendaraan required
}

api post /admin/jenis-kendaraan {
  headers {
    authorization string required
  }
  body {
    data schema AdminJenisKendaraanPayload {
      label string required
    } required
  }
  return table.JenisKendaraan required
}

api put /admin/jenis-kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminJenisKendaraanPayload required
  }
  return table.JenisKendaraan required
}

api delete /admin/jenis-kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.JenisKendaraan required
}


api get /admin/merk {
  headers {
    authorization string required
  }
  return schema AdminMerkResult {
    total number required
    data array table.Merk required
  } required
}

api get /admin/merk/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Merk required
}

api post /admin/merk {
  headers {
    authorization string required
  }
  body {
    data schema AdminMerkPayload {
      nama string required
    } required
  }
  return table.Merk required
}

api put /admin/merk/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminMerkPayload required
  }
  return table.Merk required
}

api delete /admin/merk/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Merk required
}


api get /admin/jenis-warna {
  headers {
    authorization string required
  }
  return schema AdminJenisWarnaResult {
    total number required
    data array table.JenisWarna required
  } required
}

api get /admin/jenis-warna/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.JenisWarna required
}

api post /admin/jenis-warna {
  headers {
    authorization string required
  }
  body {
    data schema AdminJenisWarnaPayload {
      nama string required
      deskripsi string
    } required
  }
  return table.JenisWarna required
}

api put /admin/jenis-warna/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminJenisWarnaPayload required
  }
  return table.JenisWarna required
}

api delete /admin/jenis-warna/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.JenisWarna required
}


api get /admin/transmisi {
  headers {
    authorization string required
  }
  return schema AdminTransmisiResult {
    total number required
    data array table.Transmisi required
  } required
}

api get /admin/transmisi/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Transmisi required
}

api post /admin/transmisi {
  headers {
    authorization string required
  }
  body {
    data schema AdminTransmisiPayload {
      label string required
      deskripsi string
    } required
  }
  return table.Transmisi required
}

api put /admin/transmisi/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminTransmisiPayload required
  }
  return table.Transmisi required
}

api delete /admin/transmisi/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Transmisi required
}


schema DataKendaraan {
  kendaraan table.Kendaraan required
  list_media array table.MediaKendaraan required
  list_warna_tersedia array table.WarnaTersedia required
}


api get /admin/kendaraan {
  headers {
    authorization string required
  }
  query {
    id_varian_jenis number
    id_merk number
    q string
  }
  return schema AdminKendaraanResult {
    total number required
    data array schema.DataKendaraan required
  } required
}

api get /admin/kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return schema.DataKendaraan required
}

api post /admin/kendaraan {
  headers {
    authorization string required
  }
  body {
    data schema AdminKendaraanPayload {
      id_varian_jenis number required
      id_merk number required
      nama string required
      deskripsi string
      list_media array schema AdminMediaKendaraanPayload {
        jenis string required
        url string required
      } required
      list_warna_tersedia array schema AdminWarnaTersediaPayload {
        label string required
        kode_warna_hex string required
      } required
    } required
  }
  return table.Kendaraan required
}

api put /admin/kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminKendaraanPayload required
  }
  return table.Kendaraan required
}

api delete /admin/kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Kendaraan required
}


api get /admin/variasi-kendaraan {
  headers {
    authorization string required
  }
  query {
    id_kendaraan number
    id_jenis_warna number
    id_transmisi number
    tahun number
    q string
  }
  return schema AdminVariasiKendaraanResult {
    total number required
    data array table.VariasiKendaraan required
  } required
}

api get /admin/variasi-kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.VariasiKendaraan required
}

api post /admin/variasi-kendaraan {
  headers {
    authorization string required
  }
  body {
    data schema AdminVariasiKendaraanPayload {
      id_kendaraan number required
      id_jenis_warna number required
      id_transmisi number required
      tahun number required
      label string required
      thumbnail string required
      deskripsi string
    } required
  }
  return table.VariasiKendaraan required
}

api put /admin/variasi-kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminVariasiKendaraanPayload required
  }
  return table.VariasiKendaraan required
}

api delete /admin/variasi-kendaraan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.VariasiKendaraan required
}


api get /admin/varian-jenis {
  headers {
    authorization string required
  }
  query {
    id_jenis_kendaraan number
    q string
  }
  return schema AdminVarianJenisResult {
    total number required
    data array table.VarianJenis required
  } required
}

api get /admin/varian-jenis/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.VarianJenis required
}

api post /admin/varian-jenis {
  headers {
    authorization string required
  }
  body {
    data schema AdminVarianJenisPayload {
      id_jenis_kendaraan number required
      label string required
    } required
  }
  return table.VarianJenis required
}

api put /admin/varian-jenis/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminVarianJenisPayload required
  }
  return table.VarianJenis required
}

api delete /admin/varian-jenis/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.VarianJenis required
}


// misal: mobil, sepeda motor
table JenisKendaraan {
  id bigint pk notnull inc
  label varchar(200) notnull
}

// misal untuk mobil: suv, hatchback, mpv, sedan
table VarianJenis {
  id bigint pk notnull inc
  id_jenis_kendaraan JenisKendaraan.id notnull
  label varchar(200) notnull
}

// misal Toyota, Honda, BMW
table Merk {
  id bigint pk notnull inc
  nama varchar(200) notnull
}

// misal Honda Brio, Toyota Fortuner
table Kendaraan {
  id bigint pk notnull inc
  id_varian_jenis VarianJenis.id notnull
  id_merk Merk.id notnull
  nama varchar(200) notnull
  deskripsi text
}

enum JenisMedia {
  VIDEO
  GAMBAR
  DOKUMEN
}

table MediaKendaraan {
  id bigint pk notnull
  id_kendaraan Kendaraan.id notnull
  jenis JenisMedia notnull
  url varchar(200) notnull
}

// misal Merah, Biru, Cokelat
table WarnaTersedia {
  id bigint pk notnull inc
  id_kendaraan Kendaraan.id
  label varchar(200) notnull
  kode_warna_hex varchar(9) notnull
}

// misal Standard, Metallic, Vinyl
table JenisWarna {
  id bigint pk notnull inc
  nama varchar(200) notnull
  deskripsi text
}

table Transmisi {
  id bigint pk notnull inc
  label varchar(200) notnull
  deskripsi text
}

// misal:
// - Toyota Fortuner 2024 metallic manual 4X4 GR Sport
// - Toyota Fortuner 2024 standard cvt 4X4 GR Sport
// 2024 -> tahun keluaran
// metallic, standard -> jenis warna
// manual, cvt -> transmisi
// 4x4 GR Sport -> variasi
table VariasiKendaraan {
  id bigint pk notnull
  id_kendaraan Kendaraan.id notnull
  id_jenis_warna JenisWarna.id notnull
  id_transmisi Transmisi.id notnull
  tahun int notnull
  label varchar(200) notnull
  thumbnail varchar(200) notnull
  deskripsi text
}


api get /jenis-kendaraan {
  return array table.JenisKendaraan required
}

api get /varian-jenis {
  query {
    id_jenis_kendaraan number required
  }
  return array table.VarianJenis required
}

api get /merk {
  query {
    q string
  }
  return array table.Merk required
}

api get /kendaraan {
  query {
    q string
    id_varian_jenis number
    id_merk number
    limit number
    offset number
  }
  return schema KendaraanResult {
    total number required
    data array schema.DataKendaraan required
  } required
}

api get /jenis-warna {
  return array table.JenisWarna required
}

api get /transmisi {
  return array table.Transmisi required
}

api get /variasi-kendaraan {
  query {
    id_kendaraan number
    id_jenis_warna number
    id_tranmisi number
    tahun number
    q string
    limit number
    offset number
  }
  return schema VariasiKendaraanResult {
    total number required
    data array table.VariasiKendaraan required
  } required
}


// misal: mobil, sepeda motor
table JenisKendaraan {
  id bigint pk notnull inc
  label varchar(200) notnull
}

// misal untuk mobil: suv, hatchback, mpv, sedan
table VarianJenis {
  id bigint pk notnull inc
  id_jenis_kendaraan JenisKendaraan.id notnull
  label varchar(200) notnull
}

// misal Toyota, Honda, BMW
table Merk {
  id bigint pk notnull inc
  nama varchar(200) notnull
}

// misal Honda Brio, Toyota Fortuner
table Kendaraan {
  id bigint pk notnull inc
  id_varian_jenis VarianJenis.id notnull
  id_merk Merk.id notnull
  nama varchar(200) notnull
  deskripsi text
}

// misal Merah, Biru, Cokelat
table WarnaTersedia {
  id bigint pk notnull inc
  id_kendaraan Kendaraan.id
  label varchar(200) notnull
  kode_warna_hex varchar(9) notnull
}

// misal Standard, Metallic, Vinyl
table JenisWarna {
  id bigint pk notnull inc
  nama varchar(200) notnull
  deskripsi text
}

table Transmisi {
  id bigint pk notnull inc
  label varchar(200) notnull
  deskripsi text
}

// misal:
// - Toyota Fortuner 2024 metallic manual 4X4 GR Sport
// - Toyota Fortuner 2024 standard cvt 4X4 GR Sport
// 2024 -> tahun keluaran
// metallic, standard -> jenis warna
// manual, cvt -> transmisi
// 4x4 GR Sport -> variasi
table VariasiKendaraan {
  id bigint pk notnull
  id_kendaraan Kendaraan.id notnull
  id_jenis_warna JenisWarna.id notnull
  id_transmisi Transmisi.id notnull
  tahun int notnull
  label varchar(200) notnull
  thumbnail varchar(200) notnull
  deskripsi text
}
