$ rails g scaffold Provinsi provinsi_nama:string

$ rails g scaffold Kabupaten provinsi_id:integer kabupaten_nama:string

$ rails g model Provinsi provinsi_nama:string

$ rails g model Kabkot provinsi_id:integer kabkot_id:integer kabkot_nama:string

$ rails g migration CreateVKabkots

class CreateVKabkots < ActiveRecord::Migration
	def change 
		self.connection.execute %Q(
			create view v_kabkots as

		select
			kabkots.id, --------------> read: table: kabkots, field: id
			kabkots.provinsi_id, -----> read: table:kabkots, field: provinsi_id
			provinsis.provinsi_nama, -> join table provinsis, field: provinsi_nama
			kabkots.kabkot_id, -------> still no idea why need generate this field?
			kabkots.kabkot_nama ------> read: table kabkots, field: kabkot_nama
		from
			kabkots
			left join provinsis on kabkots.provinsi_id = provinsis.id
		)
	end
end