/*
 Navicat Premium Data Transfer

 Source Server         : ilusiprima
 Source Server Type    : MySQL
 Source Server Version : 50651
 Source Host           : ilusiprima.com:3306
 Source Schema         : ilusipri_vaterinar

 Target Server Type    : MySQL
 Target Server Version : 50651
 File Encoding         : 65001

 Date: 24/10/2022 23:50:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for m_ladang
-- ----------------------------
DROP TABLE IF EXISTS `m_ladang`;
CREATE TABLE `m_ladang`  (
  `id_ladang` int(11) NOT NULL AUTO_INCREMENT,
  `id_pemilik` int(11) NULL DEFAULT NULL,
  `nama_penternak` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `id_premis` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `alamat_ladang` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `gps_ladang_lat` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `gps_ladang_long` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `id_negeri` int(11) NULL DEFAULT NULL,
  `id_daerah` int(11) NULL DEFAULT NULL,
  `id_mukim` int(11) NULL DEFAULT NULL,
  `id_parlimen` int(11) NULL DEFAULT NULL,
  `id_dun` int(11) NULL DEFAULT NULL,
  `id_status_ladang` int(11) NULL DEFAULT NULL,
  `id_projek_kerajaan` int(11) NULL DEFAULT NULL,
  `id_katpemilik` int(11) NULL DEFAULT NULL,
  `id_status_lesen` int(11) NULL DEFAULT NULL,
  `id_sistem_pemeliharaan` int(11) NULL DEFAULT NULL,
  `id_hakmilik` int(11) NULL DEFAULT NULL,
  `id_kategori_tanah` int(11) NULL DEFAULT NULL,
  `id_syarat_nyata_tanah` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id_ladang`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for m_ladang_aneka
-- ----------------------------
DROP TABLE IF EXISTS `m_ladang_aneka`;
CREATE TABLE `m_ladang_aneka`  (
  `id_ladang_aneka` int(11) NOT NULL AUTO_INCREMENT,
  `id_ladang` int(11) NULL DEFAULT NULL,
  `bil_kandang` int(11) NULL DEFAULT NULL,
  `kapasiti_kandang` int(11) NULL DEFAULT NULL,
  `luas_pengeluaran` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `luas_ladang` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_arnab_pedaging` int(11) NULL DEFAULT NULL,
  `bt_arnab_pet` int(11) NULL DEFAULT NULL,
  `bt_rusa_pedaging_j` int(11) NULL DEFAULT NULL,
  `bt_rusa_pedaging_b` int(11) NULL DEFAULT NULL,
  `bt_rusa_rekreasi_j` int(11) NULL DEFAULT NULL,
  `bt_rusa_rekreasi_b` int(11) NULL DEFAULT NULL,
  `bt_kuda_pembiakan_j` int(11) NULL DEFAULT NULL,
  `bt_kuda_pembiakan_b` int(11) NULL DEFAULT NULL,
  `bt_kuda_rekreasi_j` int(11) NULL DEFAULT NULL,
  `bt_kuda_rekreasi_g` int(11) NULL DEFAULT NULL,
  `bt_kuda_rekreasi_b` int(11) NULL DEFAULT NULL,
  `bt_katak` int(11) NULL DEFAULT NULL,
  `bt_angsa` int(11) NULL DEFAULT NULL,
  `bt_piru` int(11) NULL DEFAULT NULL,
  `bt_ostrich` int(11) NULL DEFAULT NULL,
  `bt_selasih` int(11) NULL DEFAULT NULL,
  `bt_mutiara` int(11) NULL DEFAULT NULL,
  `bt_parrot` int(11) NULL DEFAULT NULL,
  `bil_jualan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `nilai_jualan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id_ladang_aneka`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for m_ladang_babi
-- ----------------------------
DROP TABLE IF EXISTS `m_ladang_babi`;
CREATE TABLE `m_ladang_babi`  (
  `id_ladang_babi` int(11) NOT NULL AUTO_INCREMENT,
  `id_ladang` int(11) NULL DEFAULT NULL,
  `luas_ladang` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `kapasiti_ladang` int(11) NULL DEFAULT NULL,
  `baka_babi` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bil_kandang_tertutup` int(11) NULL DEFAULT NULL,
  `bil_kandang_semi_terbuka` int(11) NULL DEFAULT NULL,
  `bil_kandang_terbuka` int(11) NULL DEFAULT NULL,
  `bil_sisa_kumbahan` int(11) NULL DEFAULT NULL,
  `id_pengolahan_sisa_kumbahan` int(11) NULL DEFAULT NULL,
  `exist_zon_penampan` int(2) NULL DEFAULT NULL,
  `exist_gahp` int(2) NULL DEFAULT NULL,
  `exist_homemixer` int(11) NULL DEFAULT NULL,
  `jumlah_spesis_boar` int(11) NULL DEFAULT NULL,
  `jumlah_spesis_induk` int(11) NULL DEFAULT NULL,
  `jumlah_spesis_lain` int(11) NULL DEFAULT NULL,
  `jumlah_spesis_spp` int(11) NULL DEFAULT NULL,
  `bil_jualan` int(11) NULL DEFAULT NULL,
  `nilai_jualan` int(11) NULL DEFAULT NULL,
  `jumlah_jualan` int(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id_ladang_babi`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for m_ladang_ruminan
-- ----------------------------
DROP TABLE IF EXISTS `m_ladang_ruminan`;
CREATE TABLE `m_ladang_ruminan`  (
  `id_ladang_ruminan` int(11) NOT NULL AUTO_INCREMENT,
  `id_ladang` int(11) NULL DEFAULT NULL,
  `luas_kandang` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `luas_fodder` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `luas_ragutan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `kapasiti_pedaging` int(11) NULL DEFAULT NULL,
  `kapasiti_fidlot` int(11) NULL DEFAULT NULL,
  `kapasiti_kambing` int(11) NULL DEFAULT NULL,
  `kapasiti_bebiri` int(11) NULL DEFAULT NULL,
  `kapasiti_kerbau` int(11) NULL DEFAULT NULL,
  `id_kategori_ladang_lembu` int(11) NULL DEFAULT NULL,
  `id_kategori_ladang_kambing` int(11) NULL DEFAULT NULL,
  `id_kategori_ladang_kerbau` int(11) NULL DEFAULT NULL,
  `bt_lembu_kk_baka` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_lembu_kk_jurusan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_lembu_kk_j1` int(11) NULL DEFAULT NULL,
  `bt_lembu_kk_j2` int(11) NULL DEFAULT NULL,
  `bt_lembu_kk_j3` int(11) NULL DEFAULT NULL,
  `bt_lembu_kk_b1` int(11) NULL DEFAULT NULL,
  `bt_lembu_kk_b2` int(11) NULL DEFAULT NULL,
  `bt_lembu_kk_b3` int(11) NULL DEFAULT NULL,
  `bt_lembu_kacukan_baka` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_lembu_kacukan_jurusan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_lembu_kacukan_j1` int(11) NULL DEFAULT NULL,
  `bt_lembu_kacukan_j2` int(11) NULL DEFAULT NULL,
  `bt_lembu_kacukan_j3` int(11) NULL DEFAULT NULL,
  `bt_lembu_kacukan_b1` int(11) NULL DEFAULT NULL,
  `bt_lembu_kacukan_b2` int(11) NULL DEFAULT NULL,
  `bt_lembu_kacukan_b3` int(11) NULL DEFAULT NULL,
  `bt_kerbau_baka` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_kerbau_jurusan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_kerbau_j1` int(11) NULL DEFAULT NULL,
  `bt_kerbau_j2` int(11) NULL DEFAULT NULL,
  `bt_kerbau_j3` int(11) NULL DEFAULT NULL,
  `bt_kerbau_b1` int(11) NULL DEFAULT NULL,
  `bt_kerbau_b2` int(11) NULL DEFAULT NULL,
  `bt_kerbau_b3` int(11) NULL DEFAULT NULL,
  `bt_kambing_baka` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_kambing_jurusan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_kambing_j1` int(11) NULL DEFAULT NULL,
  `bt_kambing_j2` int(11) NULL DEFAULT NULL,
  `bt_kambing_b1` int(11) NULL DEFAULT NULL,
  `bt_kambing_b2` int(11) NULL DEFAULT NULL,
  `bt_bebiri_baka` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_bebiri_jurusan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_bebiri_j1` int(11) NULL DEFAULT NULL,
  `bt_bebiri_j2` int(11) NULL DEFAULT NULL,
  `bt_bebiri_b1` int(11) NULL DEFAULT NULL,
  `bt_bebiri_b2` int(11) NULL DEFAULT NULL,
  `bil_jual_lembu` int(11) NULL DEFAULT NULL,
  `nilai_jualan_lembu` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bil_jual_kerbau` int(11) NULL DEFAULT NULL,
  `nilai_jualan_kerbau` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bil_jual_kambing` int(11) NULL DEFAULT NULL,
  `nilai_jualan_kambing` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bil_jual_bebiri` int(11) NULL DEFAULT NULL,
  `nilai_jualan_bebiri` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id_ladang_ruminan`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for m_ladang_tenusu
-- ----------------------------
DROP TABLE IF EXISTS `m_ladang_tenusu`;
CREATE TABLE `m_ladang_tenusu`  (
  `id_ladang_tenusu` int(11) NOT NULL AUTO_INCREMENT,
  `id_ladang` int(11) NULL DEFAULT NULL,
  `luas_kandang` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `luas_fodder` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `luas_ragutan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `kapasiti_lembu` int(11) NULL DEFAULT NULL,
  `kapasiti_kerbau` int(11) NULL DEFAULT NULL,
  `kapasiti_kambing` int(11) NULL DEFAULT NULL,
  `kapasiti_bebiri` int(11) NULL DEFAULT NULL,
  `id_kategori_ladang_tenusu` int(11) NULL DEFAULT NULL,
  `bt_lembu_baka` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_lembu_j1` int(11) NULL DEFAULT NULL,
  `bt_lembu_j2` int(11) NULL DEFAULT NULL,
  `bt_lembu_j3` int(11) NULL DEFAULT NULL,
  `bt_lembu_b1` int(11) NULL DEFAULT NULL,
  `bt_lembu_b2` int(11) NULL DEFAULT NULL,
  `bt_lembu_b3` int(11) NULL DEFAULT NULL,
  `bt_kerbau_baka` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_kerbau_j1` int(11) NULL DEFAULT NULL,
  `bt_kerbau_j2` int(11) NULL DEFAULT NULL,
  `bt_kerbau_j3` int(11) NULL DEFAULT NULL,
  `bt_kerbau_b1` int(11) NULL DEFAULT NULL,
  `bt_kerbau_b2` int(11) NULL DEFAULT NULL,
  `bt_kerbau_b3` int(11) NULL DEFAULT NULL,
  `bt_kambing_baka` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bt_kambing_j1` int(11) NULL DEFAULT NULL,
  `bt_kambing_j2` int(11) NULL DEFAULT NULL,
  `bt_kambing_b1` int(11) NULL DEFAULT NULL,
  `bt_kambing_b2` int(11) NULL DEFAULT NULL,
  `bil_jual_ternakan` int(11) NULL DEFAULT NULL,
  `nilai_jualan_ternakan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `nilai_jualan_ternakan_tahunan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `jumlah_susu_sehari_lembu` int(11) NULL DEFAULT NULL,
  `nilai_jualan_susu_lembu` int(11) NULL DEFAULT NULL,
  `nilai_jualan_susu_tahunan_lembu` int(20) NULL DEFAULT NULL,
  `jumlah_susu_sehari_kambing` int(11) NULL DEFAULT NULL,
  `nilai_jualan_susu_kambing` int(11) NULL DEFAULT NULL,
  `nilai_jualan_susu_tahunan_kambing` int(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id_ladang_tenusu`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
