Completed
CodeIgniter 4 Training for Beginner
Kementerian Dalam Negeri
Date
26 – 30 Sep 2022
Organised by
Favourite Trainer Sdn Bhd
Trainer
Azman Zakaria
Attendees
7
Tag: Codeigniter 4 Training
Training Date : 26 - 30 September 2022
Location: Kementerian Dalam Negeri, Putrajaya
Introduction :
CodeIgniter is an Application Development Framework - a toolkit - for people who build websites using PHP. Its goal is to enable you to develop projects much faster than you could if you were writing code from scratch, by providing a rich set of libraries for commonly needed tasks, as well as a simple interface and logical structure to access these libraries. CodeIgniter lets you creatively focus on your project by minimizing the amount of code needed for a given task.
This course is designed for students with knowledge of the previous Codeigniter version (version 3,2,1). Those who are new to Codeigniter are welcome to join but must expect a challenging journey in order to grasp the whole content of the training.
Tools that will be used in this class are as follows:-
- Laragon (PHP, Apache, MySQL)
- Visual Studio Code
- Windows 10 / 11
- SQL Yog
- Terminal / Command Line
Each student should have the following minimum PC / Notebook specification recommendation:
- Window 10 with 8 GB RAM
- 45 GB Free Storage
Syllabus
|
|
Trainer Profile
 |
Nama : Azman bin Zakaria
|
|
Azman merupakan senior programmer yang passionate dalam bidang pengaturcaraan komputer dari awal mulai beliau bekerja pada tahun 2000 sehingga hari ini. Beliau mempunyai pengalaman bekerja yang luas di agensi kerajaan, swasta dan sebagai freelancer.
|
|
Notes
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="ThemeMakker">
<link rel="icon" href="favicon.ico" type="image/x-icon">
<title>:: BigBucket :: Blank Page</title>
<link rel="stylesheet" href="<?= base_url('assets/vendor/themify-icons/themify-icons.css') ?>">
<link rel="stylesheet" href="<?= base_url('assets/vendor/fontawesome/css/font-awesome.min.css') ?>">
<link rel="stylesheet" href="<?= base_url('assets/css/main.css') ?>" type="text/css">
</head>
<body class="theme-indigo">
<!-- Page Loader -->
<div class="page-loader-wrapper">
<div class="loader">
<div class="m-t-30"><img src="<?= base_url('assets/images/brand/icon_black.svg') ?>" width="48" height="48" alt="ArrOw"></div>
<p>Please wait...</p>
</div>
</div>
<nav class="navbar custom-navbar navbar-expand-lg py-2">
<div class="container-fluid px-0">
<a href="javascript:void(0);" class="menu_toggle"><i class="fa fa-align-left"></i></a>
<a href="index.html" class="navbar-brand"><img src="<?= base_url('assets/images/brand/icon.svg') ?>" alt="BigBucket" />
<strong>Big</strong> Bucket</a>
<div id="navbar_main">
<ul class="navbar-nav mr-auto hidden-xs">
<li class="nav-item page-header">
<ul class="breadcrumb">
<li class="breadcrumb-item"><a href="index.html"><i class="fa fa-home"></i></a></li>
<li class="breadcrumb-item active">Stater Page</li>
</ul>
</li>
</ul>
<ul class="navbar-nav ml-auto">
<li class="nav-item hidden-xs">
<form class="form-inline main_search">
<input class="form-control form-control-sm mr-sm-2" type="search" placeholder="Search..."
aria-label="Search">
</form>
</li>
<li class="nav-item"><a class="nav-link nav-link-icon" href="javascript:void(0);"><i class="fa fa-cogs"></i></a></li>
<li class="nav-item dropdown">
<a class="nav-link nav-link-icon" href="javascript:void(0);" id="navbar_1_dropdown_2" role="button"
data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><i
class="fa fa-bell"></i></a>
<div class="dropdown-menu dropdown-menu-right dropdown-menu-xl py-0">
<div class="py-3 px-3">
<h5 class="heading h6 mb-0">Notifications <span
class="badge badge-pill badge-primary text-uppercase float-right">3</span></h5>
</div>
<div class="list-group">
<a href="javascript:void(0);" class="list-group-item list-group-item-action d-flex">
<div class="list-group-img"><span class="avatar bg-purple">JD</span></div>
<div class="list-group-content">
<div class="list-group-heading">Johnyy Depp <small>10:05 PM</small></div>
<p class="text-sm">Lorem ipsum dolor consectetur adipiscing eiusmod tempor</p>
</div>
</a>
<a href="javascript:void(0);" class="list-group-item list-group-item-action d-flex">
<div class="list-group-img"><span class="avatar bg-pink">TC</span></div>
<div class="list-group-content">
<div class="list-group-heading">Tom Cruise <small>10:05 PM</small></div>
<p class="text-sm">Lorem ipsum dolor sit amet consectetur eiusmod tempor</p>
</div>
</a>
<a href="javascript:void(0);" class="list-group-item list-group-item-action d-flex">
<div class="list-group-img"><span class="avatar bg-blue">WS</span></div>
<div class="list-group-content">
<div class="list-group-heading">Will Smith <small>10:05 PM</small></div>
<p class="text-sm">Lorem sit amet consectetur adipiscing eiusmod tempor</p>
</div>
</a>
</div>
<div class="py-3 text-center">
<a href="javascript:void(0);" class="link link-sm link--style-3">View all notifications</a>
</div>
</div>
</li>
<li class="nav-item dropdown">
<a class="nav-link nav-link-icon" href="javascript:void(0);" id="navbar_1_dropdown_3" role="button"
data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><i
class="fa fa-list"></i></a>
<div class="dropdown-menu dropdown-menu-right">
<h6 class="dropdown-header">User menu</h6>
<a class="dropdown-item" href="javascript:void(0);"><i class="fa fa-user text-primary"></i>My Profile</a>
<a class="dropdown-item" href="javascript:void(0);"><span
class="float-right badge badge-success">$50K</span><i
class="fa fa-briefcase text-primary"></i>My Balance</a>
<a class="dropdown-item" href="javascript:void(0);"><span class="float-right badge badge-warning">4</span><i
class="fa fa-envelope text-primary"></i>Inbox</a>
<a class="dropdown-item" href="javascript:void(0);"><i class="fa fa-cog text-primary"></i>Settings</a>
<div class="dropdown-divider" role="presentation"></div>
<a class="dropdown-item" href="javascript:void(0);"><i class="fa fa-sign-out text-primary"></i>Sign
out</a>
</div>
</li>
</ul>
</div>
</div>
</nav>
<div class="main_content" id="main-content">
<div class="left_sidebar">
<nav class="sidebar">
<div class="user-info">
<div class="image"><a href="javascript:void(0);"><img src="<?= base_url('assets/images/user.png') ?>" alt="User"></a></div>
<div class="detail mt-3">
<h5 class="mb-0">Mike Thomas</h5>
<small>Admin</small>
</div>
<div class="social">
<a href="javascript:void(0);" title="facebook"><i class="ti-twitter-alt"></i></a>
<a href="javascript:void(0);" title="twitter"><i class="ti-linkedin"></i></a>
<a href="javascript:void(0);" title="instagram"><i class="ti-facebook"></i></a>
</div>
</div>
<ul id="main-menu" class="metismenu">
<li class="g_heading">Main</li>
<li><a href="index.html"><i class="ti-home"></i><span>Dashboard</span></a></li>
<li><a href="ui-elements.html"><i class="ti-vector"></i><span>UI Elements</span></a></li>
<li class="g_heading">Application</li>
<li><a href="app-calendar.html"><i class="ti-calendar"></i><span>Calendar</span></a></li>
<li><a href="app-taskboard.html"><i class="ti-notepad"></i><span>TaskBoard</span></a></li>
<li><a href="app-inbox.html"><i class="ti-email"></i><span>Inbox</span></a></li>
<li><a href="app-chat.html"><i class="ti-comments"></i><span>Chat Apps</span></a></li>
<li><a href="app-contact.html"><i class="ti-id-badge"></i><span>Contact List</span></a></li>
<li><a href="widgets.html"><i class="ti-widget"></i><span>Widgets</span></a></li>
<li class="g_heading">Chart, Froms & Elements</li>
<li>
<a href="javascript:void(0)" class="has-arrow"><i class="ti-pie-chart"></i><span>Charts</span></a>
<ul>
<li><a href="chart-c3.html">C3 Chart</a></li>
<li><a href="chartsjs.html">Charts JS</a></li>
<li><a href="chart-flot.html">Flot Chart</a></li>
<li><a href="chart-knob.html">JQuery Knob</a></li>
<li><a href="chart-morris.html">Morris Chart</a></li>
<li><a href="chart-sparkline.html">Sparkline Chart</a></li>
</ul>
</li>
<li>
<a href="javascript:void(0)" class="has-arrow"><i class="ti-pencil-alt"></i><span>Forms</span></a>
<ul>
<li><a href="form-elements.html">Basic Elements</a></li>
<li><a href="form-advanced.html">Advanced Elements</a></li>
<li><a href="form-validation.html">Form Validation</a></li>
<li><a href="form-wizard.html">Form Wizard</a></li>
<li><a href="form-summernote.html">Summernote</a></li>
<li><a href="form-markdown.html">Markdown</a></li>
</ul>
</li>
<li>
<a href="javascript:void(0)" class="has-arrow"><i class="ti-view-list"></i><span>Tables</span></a>
<ul>
<li><a href="table-basic.html">Table Example</a></li>
<li><a href="table-normal.html">Table Normal</a></li>
<li><a href="table-datatable.html">Jquery Datatable</a></li>
<li><a href="table-editable.html">Table Editable</a></li>
<li><a href="table-foo.html">Table Foo</a></li>
</ul>
</li>
<li class="g_heading">Users</li>
<li><a href="page-profile.html"><i class="ti-user"></i><span>Profile</span></a></li>
<li><a href="page-timeline.html"><i class="ti-menu-alt"></i><span>Timeline</span></a></li>
<li><a href="page-invoices.html"><i class="ti-file"></i><span>Invoices</span></a>
</li>
<li class="g_heading">Authentication</li>
<li>
<a href="javascript:void(0)" class="has-arrow"><i class="ti-lock"></i><span>Authentication</span></a>
<ul>
<li><a class="dropdown-item" href="auth-login.html">Login</a></li>
<li><a class="dropdown-item" href="auth-register.html">Register</a></li>
<li><a class="dropdown-item" href="auth-forgot-password.html">Forgot password</a></li>
<li><a class="dropdown-item" href="auth-lock-screen.html">Lock Screen</a></li>
</ul>
</li>
<li>
<a href="javascript:void(0)" class="has-arrow"><i class="ti-na"></i><span>Error Pages</span></a>
<ul>
<li><a class="dropdown-item" href="error-400.html">400 error</a></li>
<li><a class="dropdown-item" href="error-401.html">401 error</a></li>
<li><a class="dropdown-item" href="error-403.html">403 error</a></li>
<li><a class="dropdown-item" href="error-404.html">404 error</a></li>
<li><a class="dropdown-item" href="error-500.html">500 error</a></li>
<li><a class="dropdown-item" href="error-503.html">503 error</a></li>
</ul>
</li>
<li class="g_heading">Extra</li>
<li class="active">
<a href="javascript:void(0)" class="has-arrow"><i class="ti-clipboard"></i><span>Pages</span></a>
<ul>
<li class="active"><a href="page-empty.html">Empty page</a></li>
<li><a href="page-pricing.html">Pricing cards</a>
<li><a href="page-search.html">Search Results</a></li>
<li><a href="page-testimonials.html">Testimonials</a></li>
<li><a href="page-icons.html">Icons</a></li>
<li><a href="page-gallery.html">Gallery</a></li>
</ul>
</li>
<li><a href="docs/introduction.html"><i class="ti-file"></i><span>Documentation</span></a></li>
</ul>
</nav>
</div>
<div class="right_sidebar">
<div class="setting_div">
<a href="javascript:void(0);" class="rightbar_btn"><i class="fa fa-cog fa-spin"></i></a>
</div>
<ul class="nav nav-pills nav-fill flex-column flex-sm-row mx-3 my-3" id="myTab" role="tablist">
<li class="nav-item"><a class="nav-link active" id="Settings-tab" data-toggle="tab" href="#Settings"
role="tab" aria-controls="Settings" aria-selected="true">Settings</a></li>
<li class="nav-item"><a class="nav-link" id="Contact-tab" data-toggle="tab" href="#Contact" role="tab"
aria-controls="Contact" aria-selected="false">Contact</a></li>
</ul>
<hr>
<div class="tab-content" id="myTabContent">
<div class="tab-pane show active" id="Settings" role="tabpanel" aria-labelledby="Settings-tab">
<div class="sidebar-scroll">
<div class="sidebar-widget px-3">
<h5>Theme Setting</h5>
<ul class="choose-skin list-unstyled">
<li data-theme="black">
<div class="black"></div>
</li>
<li data-theme="azure">
<div class="azure"></div>
</li>
<li data-theme="indigo" class="active">
<div class="indigo"></div>
</li>
<li data-theme="purple">
<div class="purple"></div>
</li>
<li data-theme="orange">
<div class="orange"></div>
</li>
<li data-theme="green">
<div class="green"></div>
</li>
<li data-theme="cyan">
<div class="cyan"></div>
</li>
<li data-theme="blush">
<div class="blush"></div>
</li>
</ul>
<ul class="setting-list list-unstyled mt-3">
<li>
<label class="custom-switch">
<span class="custom-switch-description">Dark Sidebar</span>
<label class="toggle-switch switch-sm mb-0">
<input type="checkbox" class="switch-dark">
<span class="toggle-switch-slider"></span>
</label>
</label>
</li>
<li>
<label class="custom-switch">
<span class="custom-switch-description">Mini Sidebar</span>
<label class="toggle-switch switch-sm mb-0">
<input type="checkbox" class="switch-sidebar">
<span class="toggle-switch-slider"></span>
</label>
</label>
</li>
</ul>
<hr>
</div>
<div class="sidebar-widget px-3">
<h5>Language Setting</h5>
<select class="selectpicker" title="Select language">
<option>English</option>
<option>Spanish</option>
<option>Chinese</option>
<option>Hindi</option>
<option>Arabic</option>
</select>
<hr>
</div>
<div class="sidebar-widget px-3">
<h5>General Setting</h5>
<ul class="setting-list list-unstyled mt-3">
<li>
<label class="custom-switch">
<span class="custom-switch-description">Report Panel Usage</span>
<label class="toggle-switch switch-sm mb-0">
<input type="checkbox" checked>
<span class="toggle-switch-slider"></span>
</label>
</label>
</li>
<li>
<label class="custom-switch">
<span class="custom-switch-description">Email Redirect</span>
<label class="toggle-switch switch-sm mb-0">
<input type="checkbox" checked>
<span class="toggle-switch-slider"></span>
</label>
</label>
</li>
<li>
<label class="custom-switch">
<span class="custom-switch-description">Notifications</span>
<label class="toggle-switch switch-sm mb-0">
<input type="checkbox">
<span class="toggle-switch-slider"></span>
</label>
</label>
</li>
<li>
<label class="custom-switch">
<span class="custom-switch-description">Location Permission</span>
<label class="toggle-switch switch-sm mb-0">
<input type="checkbox" checked>
<span class="toggle-switch-slider"></span>
</label>
</label>
</li>
</ul>
<hr>
</div>
<div class="sidebar-widget px-3">
<div class="progress-wrapper">
<h4 class="progress-label text-uppercase">New Project</h4>
<h4 class="progress-percentage text-uppercase">$950</h4>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-purple" role="progressbar" aria-valuenow="40"
aria-valuemin="0" aria-valuemax="100" style="width: 40%;"></div>
</div>
</div>
<div class="progress-wrapper">
<h4 class="progress-label text-uppercase"> Admin</h4>
<h4 class="progress-percentage text-uppercase">$10k</h4>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-orange" role="progressbar" aria-valuenow="78"
aria-valuemin="0" aria-valuemax="100" style="width: 78%;"></div>
</div>
</div>
<div class="progress-wrapper">
<h4 class="progress-label text-uppercase">Balance</h4>
<h4 class="progress-percentage text-uppercase">$50k</h4>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-green" role="progressbar" aria-valuenow="55"
aria-valuemin="0" aria-valuemax="100" style="width: 55%;"></div>
</div>
</div>
<hr>
<div class="progress-wrapper">
<h4 class="progress-label text-uppercase">Storage</h4>
<h4 class="progress-percentage text-uppercase">35GB</h4>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-red" role="progressbar" aria-valuenow="89"
aria-valuemin="0" aria-valuemax="100" style="width: 89%;"></div>
</div>
</div>
<button type="button" class="btn btn-primary btn-block btn-animated btn-animated-x">
<span class="btn-inner--visible">Upgrade Now</span>
<span class="btn-inner--hidden"><i class="fas fa-arrow-right"></i></span>
</button>
</div>
</div>
</div>
<div class="tab-pane" id="Contact" role="tabpanel" aria-labelledby="Contact-tab">
<div class="sidebar-widget px-3">
<ul class="list-unstyled contact-list">
<li class="d-flex align-items-center">
<span class="contact-img">
<img src="<?= base_url('assets/images/xs/avatar1.jpg') ?>" class="rounded" alt="">
</span>
<h4 class="contact-name">Vincent Porter <span class="d-block">London UK</span></h4>
<div class="action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i class="fab fa-skype"></i></a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i
class="fa fa-envelope"></i></a>
</div>
</li>
<li class="d-flex align-items-center">
<span class="contact-img">
<img src="<?= base_url('assets/images/xs/avatar2.jpg') ?>" class="rounded" alt="">
</span>
<h4 class="contact-name">Mike Thomas <span class="d-block">London UK</span></h4>
<div class="action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i class="fab fa-skype"></i></a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i
class="fa fa-envelope"></i></a>
</div>
</li>
<li class="d-flex align-items-center">
<span class="contact-img">
<img src="<?= base_url('assets/images/xs/avatar3.jpg') ?>" class="rounded" alt="">
</span>
<h4 class="contact-name">Aiden Chavaz</h4>
<div class="action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i class="fab fa-skype"></i></a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i
class="fa fa-envelope"></i></a>
</div>
</li>
<li class="d-flex align-items-center">
<span class="contact-img">
<img src="<?= base_url('assets/images/xs/avatar4.jpg') ?>" class="rounded" alt="">
</span>
<h4 class="contact-name">Vincent Porter <span class="d-block">Miami USA</span></h4>
<div class="action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i class="fab fa-skype"></i></a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i
class="fa fa-envelope"></i></a>
</div>
</li>
<li class="d-flex align-items-center">
<span class="contact-img">
<img src="<?= base_url('assets/images/xs/avatar5.jpg') ?>" class="rounded" alt="">
</span>
<h4 class="contact-name">Mike Thomas <span class="d-block">Neyyork USA</span></h4>
<div class="action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i class="fab fa-skype"></i></a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i
class="fa fa-envelope"></i></a>
</div>
</li>
<li class="d-flex align-items-center">
<span class="contact-img">
<img src="<?= base_url('assets/images/xs/avatar6.jpg') ?>" class="rounded" alt="">
</span>
<h4 class="contact-name">Aiden Chavaz</h4>
<div class="action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i class="fab fa-skype"></i></a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i
class="fa fa-envelope"></i></a>
</div>
</li>
<li class="d-flex align-items-center">
<span class="contact-img">
<img src="<?= base_url('assets/images/xs/avatar7.jpg') ?>" class="rounded" alt="">
</span>
<h4 class="contact-name">Mike Thomas <span class="d-block">New Delhi IND</span></h4>
<div class="action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i class="fab fa-skype"></i></a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i
class="fa fa-envelope"></i></a>
</div>
</li>
<li class="d-flex align-items-center">
<span class="contact-img">
<img src="<?= base_url('assets/images/xs/avatar8.jpg') ?>" class="rounded" alt="">
</span>
<h4 class="contact-name">Aiden Chavaz</h4>
<div class="action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i class="fab fa-skype"></i></a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary"><i
class="fa fa-envelope"></i></a>
</div>
</li>
</ul>
</div>
</div>
</div>
</div>
<div class="page">
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<a class="navbar-brand" href="javascript:void(0);">Stater page</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
<i class="fa fa-align-justify"></i>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav mr-auto">
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="javascript:void(0);" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Application</a>
<div class="dropdown-menu">
<a class="dropdown-item" href="javascript:void(0);">Inbox</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item" href="javascript:void(0);">Calendar</a>
<a class="dropdown-item" href="javascript:void(0);">TaskBoard</a>
<a class="dropdown-item" href="javascript:void(0);">Chat App</a>
<a class="dropdown-item" href="javascript:void(0);">Contacts</a>
</div>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="javascript:void(0);" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Users</a>
<div class="dropdown-menu">
<a class="dropdown-item" href="javascript:void(0);">Profile</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item" href="javascript:void(0);">Timeline</a>
<a class="dropdown-item" href="javascript:void(0);">Invoices</a>
</div>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="javascript:void(0);" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Pages</a>
<div class="dropdown-menu">
<a class="dropdown-item" href="javascript:void(0);">Stater page</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item" href="javascript:void(0);">Pricing</a>
<a class="dropdown-item" href="javascript:void(0);">Search</a>
<a class="dropdown-item" href="javascript:void(0);">Testimonials</a>
<a class="dropdown-item" href="javascript:void(0);">Map</a>
<a class="dropdown-item" href="javascript:void(0);">Icon</a>
<a class="dropdown-item" href="javascript:void(0);">Carousel</a>
<a class="dropdown-item" href="javascript:void(0);">Gallery</a>
<a class="dropdown-item" href="javascript:void(0);">Lookup</a>
</div>
</li>
</ul>
<form class="form-inline my-2 my-lg-0">
<button type="button" class="btn btn-primary">Add</button>
<a href="https://themeforest.net/user/wrraptheme/portfolio" title="Portfolio" class="btn btn-success ml-2">Portfolio</a>
</form>
</div>
</nav>
<div class="container-fluid">
<div class="row clearfix">
<div class="col-lg-12 col-md-12">
<div class="card planned_task">
<div class="header">
<h2>Stater Page</h2>
</div>
<div class="body">
<h4>Stater Page</h4>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Javascript -->
<script src="<?= base_url('assets/bundles/libscripts.bundle.js') ?>"></script>
<script src="<?= base_url('assets/bundles/vendorscripts.bundle.js') ?>"></script>
<script src="<?= base_url('assets/js/theme.js') ?>"></script>
</body>
</html>
/*
Navicat Premium Data Transfer
Source Server : 10.21.72.156 MAPO
Source Server Type : MySQL
Source Server Version : 80026
Source Host : 10.21.72.156:3306
Source Schema : mids
Target Server Type : MySQL
Target Server Version : 80026
File Encoding : 65001
Date: 26/09/2022 15:17:18
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for adm_agama
-- ----------------------------
DROP TABLE IF EXISTS `adm_agama`;
CREATE TABLE `adm_agama` (
`id_agama` tinyint NOT NULL AUTO_INCREMENT,
`agama` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_agama`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Menyimpan senarai agama' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_agama
-- ----------------------------
INSERT INTO `adm_agama` VALUES (1, 'Islam');
INSERT INTO `adm_agama` VALUES (2, 'Kristian');
INSERT INTO `adm_agama` VALUES (3, 'Buddha');
INSERT INTO `adm_agama` VALUES (4, 'Hindu');
INSERT INTO `adm_agama` VALUES (5, 'Sikhism');
INSERT INTO `adm_agama` VALUES (6, 'Tao');
INSERT INTO `adm_agama` VALUES (7, 'Konfusianisma');
INSERT INTO `adm_agama` VALUES (8, 'Bahai');
INSERT INTO `adm_agama` VALUES (9, 'Judaism');
INSERT INTO `adm_agama` VALUES (10, 'Tiada Agama');
INSERT INTO `adm_agama` VALUES (11, 'Lain Agama');
-- ----------------------------
-- Table structure for adm_agensi
-- ----------------------------
DROP TABLE IF EXISTS `adm_agensi`;
CREATE TABLE `adm_agensi` (
`id_agensi` tinyint NOT NULL AUTO_INCREMENT,
`nama_agensi` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`kod_agensi` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`id_peranan` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_peranan',
`aktif` tinyint NULL DEFAULT NULL COMMENT '0=Tidak Aktif, 1=Aktif',
PRIMARY KEY (`id_agensi`) USING BTREE,
INDEX `id_peranan`(`id_peranan` ASC) USING BTREE,
CONSTRAINT `adm_agensi_ibfk_1` FOREIGN KEY (`id_peranan`) REFERENCES `adm_peranan` (`id_peranan`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai agensi' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_agensi
-- ----------------------------
INSERT INTO `adm_agensi` VALUES (1, 'Pejabat Strategik Nasional Majlis Antipemerdagangan Orang dan Antipenyeludupan Migran', 'NSO MAPO', 1, 1);
INSERT INTO `adm_agensi` VALUES (2, 'Bahagian Pengurusan Teknologi Maklumat', 'IT', 2, 1);
INSERT INTO `adm_agensi` VALUES (3, 'Polis Diraja Malaysia', 'PDRM', 3, 1);
INSERT INTO `adm_agensi` VALUES (4, 'Jabatan Imigresen Malaysia', 'JIM', 3, 1);
INSERT INTO `adm_agensi` VALUES (5, 'Agensi Penguatkuasan Maritim Malaysia', 'APMM', 3, 1);
INSERT INTO `adm_agensi` VALUES (6, 'Jabatan Kastam Diraja Malaysia', 'JKDM', 3, 1);
INSERT INTO `adm_agensi` VALUES (7, 'Jabatan Tenaga Kerja Sabah', 'JTK Sabah', 3, 1);
INSERT INTO `adm_agensi` VALUES (8, 'Jabatan Tenaga Kerja Sarawak', 'JTK Sarawak', 3, 1);
INSERT INTO `adm_agensi` VALUES (9, 'Jabatan Tenaga Kerja Semenanjung', 'JTKSM ', 3, 1);
INSERT INTO `adm_agensi` VALUES (10, 'Jabatan Peguam Negara', 'AGC', 4, 1);
INSERT INTO `adm_agensi` VALUES (11, 'Mahkamah Seksyen', 'Mahkamah Seksyen', 5, 1);
INSERT INTO `adm_agensi` VALUES (12, 'Mahkamah Majistret', 'Mahkamah Majistret', 5, 1);
INSERT INTO `adm_agensi` VALUES (13, 'Mahkamah Tinggi', 'Mahkamah Tinggi', 5, 1);
INSERT INTO `adm_agensi` VALUES (14, 'Mahkamah Buruh', 'Mahkamah Buruh', 5, 1);
INSERT INTO `adm_agensi` VALUES (15, 'Mahkamah TIP', 'Mahkamah TIP', 5, 1);
INSERT INTO `adm_agensi` VALUES (16, 'Rumah Perlindungan Wanita Kuala Lumpur', 'RPKL', 6, 1);
INSERT INTO `adm_agensi` VALUES (17, 'Rumah Perlindungan Wanita Zon Tengah', 'RPZT', 6, 1);
INSERT INTO `adm_agensi` VALUES (18, 'Rumah Perlindungan Khas Wanita Kelantan', 'RPKEL', 6, 1);
INSERT INTO `adm_agensi` VALUES (19, 'Rumah Perlindungan Khas Wanita Johor', 'RPWJ', 6, 1);
INSERT INTO `adm_agensi` VALUES (20, 'Rumah Perlindungan Kanak-Kanak Lelaki Bukit Senyum', 'RP2', 6, 1);
INSERT INTO `adm_agensi` VALUES (21, 'Rumah Perlindungan Lelaki', 'RP4', 6, 1);
INSERT INTO `adm_agensi` VALUES (22, 'Rumah Perlindungan Kanak-Kanak Perempuan Rembau', 'RP REMBAU', 6, 1);
INSERT INTO `adm_agensi` VALUES (23, 'Rumah Perlindungan Wanita Tenaganita', 'RP TENAGANITA', 6, 1);
INSERT INTO `adm_agensi` VALUES (24, 'Rumah Perlindungan Wanita Global Shepherds', 'RPGS', 6, 1);
INSERT INTO `adm_agensi` VALUES (25, 'Kementerian Komunikasi dan Multimedia', 'K-KOM', 7, 1);
-- ----------------------------
-- Table structure for adm_akses
-- ----------------------------
DROP TABLE IF EXISTS `adm_akses`;
CREATE TABLE `adm_akses` (
`id_akses` tinyint NOT NULL AUTO_INCREMENT,
`akses` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_akses`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai akses yang dibenarkan' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_akses
-- ----------------------------
INSERT INTO `adm_akses` VALUES (1, 'Lihat Sahaja');
INSERT INTO `adm_akses` VALUES (2, 'Kemaskini & Lihat');
-- ----------------------------
-- Table structure for adm_akta
-- ----------------------------
DROP TABLE IF EXISTS `adm_akta`;
CREATE TABLE `adm_akta` (
`id_akta` tinyint NOT NULL AUTO_INCREMENT,
`akta` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_akta`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai akta' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_akta
-- ----------------------------
-- ----------------------------
-- Table structure for adm_depoh
-- ----------------------------
DROP TABLE IF EXISTS `adm_depoh`;
CREATE TABLE `adm_depoh` (
`id_depoh` tinyint NOT NULL AUTO_INCREMENT,
`depoh` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`alamat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`no_telefon` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`no_faks` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`emel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_depoh`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Menyimpan senarai depot imigresen' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_depoh
-- ----------------------------
INSERT INTO `adm_depoh` VALUES (1, 'Depot Imigresen Pekan Nanas', 'Depot Tahanan PATI, Pekan Nenas, 81500, Pontian, Johor', '07-6993540', '07-6994691 / 07-6993588', NULL);
INSERT INTO `adm_depoh` VALUES (2, 'Depot Imigresen Belantik', '08210, Sik, Kedah', '04-7404444', '04-7404400 / 04-7404500', NULL);
INSERT INTO `adm_depoh` VALUES (3, 'Depot Imigresen Tanah Merah', 'Jalan Sultan Ismail Petra, 17500, Tanah Merah, Kelantan', '09-9502140 / 09-9551120', '09-9502141 / 09-9553924', NULL);
INSERT INTO `adm_depoh` VALUES (4, 'Depot Tahanan Machap Umboo', '78000, Alor Gajah, Melaka', '06-5562078', '06-5567598', NULL);
INSERT INTO `adm_depoh` VALUES (5, 'Depot Imigresen Lenggeng', 'Jalan Besar Ulu Beranang, 71750, Lenggeng, Negeri Sembilan', '03-87610051', '03-87610125', NULL);
INSERT INTO `adm_depoh` VALUES (6, 'Depot Tahanan Kemayan', 'Pejabat Imigresen Depot Kemayan Triang,, 28380, Temerloh, Pahang', '09-2409706', '09-2409705', NULL);
INSERT INTO `adm_depoh` VALUES (7, 'Depot Tahanan Imigresen Langkap', 'Jalan Chui Chak, 36700, Langkap, Perak', '05-659 9200', '05-659 9212', NULL);
INSERT INTO `adm_depoh` VALUES (8, 'Depot Imigresen Juru', '14000, Bukit Mertajam, Pulau Pinang', '04-5023905', '04-5023815', NULL);
INSERT INTO `adm_depoh` VALUES (9, 'Depot Imigresen Sementara Sungai Bakap, Kem PLKN Sri Impian', 'Lot 1064, Jalan Baru, Relau Sungai Bakap, Seberang Prai Selatan, 14200, Pulau Pinang', '04-5828858 / 04-5829858', '04-5828858', NULL);
INSERT INTO `adm_depoh` VALUES (10, 'Depot Imigresen Semenyih', 'Taman Bunga Raya , Semenyih, 43500, Kajang, Selangor', '03-87238151', '03-87236764', NULL);
INSERT INTO `adm_depoh` VALUES (11, 'Depot Tahanan Imigresen Ajil', '23400, Hulu Terengganu, Terengganu', '09-6863040 / 41 / 50 / 52', '09-6863042', 'komandan_trg@imi.gov.my');
INSERT INTO `adm_depoh` VALUES (12, 'Depot Tahanan Imigresen Bukit Jalil', 'Jabatan Imigresen Wilayah Persekutuan Kuala Lumpur, Bukit Jalil, 57000, WP Kuala Lumpur', '03-89941096', '03-89941701', NULL);
INSERT INTO `adm_depoh` VALUES (13, 'Depot Imigresen KLIA', 'Jalan Pekeliling 4, KLIA, 64050, Sepang, Lapangan Terbang Antarabangsa Kuala Lumpur (KLIA)', '03-87766920', '03-87766913', NULL);
-- ----------------------------
-- Table structure for adm_jantina
-- ----------------------------
DROP TABLE IF EXISTS `adm_jantina`;
CREATE TABLE `adm_jantina` (
`id_jantina` tinyint NOT NULL AUTO_INCREMENT,
`jantina` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`kategori` tinyint NULL DEFAULT NULL COMMENT '1=Mangsa, 2=OKT',
PRIMARY KEY (`id_jantina`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Menyimpan senarai jantina' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_jantina
-- ----------------------------
INSERT INTO `adm_jantina` VALUES (1, 'Lelaki', 2);
INSERT INTO `adm_jantina` VALUES (2, 'Perempuan', 2);
INSERT INTO `adm_jantina` VALUES (3, 'Lelaki Dewasa', 1);
INSERT INTO `adm_jantina` VALUES (4, 'Perempuan Dewasa', 1);
INSERT INTO `adm_jantina` VALUES (5, 'Kanak-kanak Lelaki', 1);
INSERT INTO `adm_jantina` VALUES (6, 'Kanak-kanak Perempuan', 1);
-- ----------------------------
-- Table structure for adm_jenis_kempen
-- ----------------------------
DROP TABLE IF EXISTS `adm_jenis_kempen`;
CREATE TABLE `adm_jenis_kempen` (
`id_jenis_kempen` tinyint NOT NULL AUTO_INCREMENT,
`kempen` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_jenis_kempen`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai jenis kempen' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_jenis_kempen
-- ----------------------------
INSERT INTO `adm_jenis_kempen` VALUES (1, 'Radio');
INSERT INTO `adm_jenis_kempen` VALUES (2, 'TV');
INSERT INTO `adm_jenis_kempen` VALUES (3, 'Risalah');
INSERT INTO `adm_jenis_kempen` VALUES (4, 'Surat Khabar');
INSERT INTO `adm_jenis_kempen` VALUES (5, 'Berita Dalam Talian');
INSERT INTO `adm_jenis_kempen` VALUES (6, 'Program Kesedaran');
-- ----------------------------
-- Table structure for adm_jenis_kes
-- ----------------------------
DROP TABLE IF EXISTS `adm_jenis_kes`;
CREATE TABLE `adm_jenis_kes` (
`id_jenis_kes` tinyint(1) NOT NULL AUTO_INCREMENT,
`jenis_kes` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_jenis_kes`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai jenis kes/eksploitasi' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_jenis_kes
-- ----------------------------
INSERT INTO `adm_jenis_kes` VALUES (1, 'Seksual');
INSERT INTO `adm_jenis_kes` VALUES (2, 'Penjualan Organ');
INSERT INTO `adm_jenis_kes` VALUES (3, 'Penjualan Bayi');
INSERT INTO `adm_jenis_kes` VALUES (4, 'Buruh/Kerja Paksa (Ladang)');
INSERT INTO `adm_jenis_kes` VALUES (5, 'Buruh/Kerja Paksa (Kilang)');
INSERT INTO `adm_jenis_kes` VALUES (6, 'Buruh/Kerja Paksa (Domestik)');
-- ----------------------------
-- Table structure for adm_mahkamah
-- ----------------------------
DROP TABLE IF EXISTS `adm_mahkamah`;
CREATE TABLE `adm_mahkamah` (
`id_mahkamah` int NOT NULL AUTO_INCREMENT,
`mahkamah` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`id_negeri` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_negeri',
PRIMARY KEY (`id_mahkamah`) USING BTREE,
INDEX `id_negeri`(`id_negeri` ASC) USING BTREE,
CONSTRAINT `adm_mahkamah_ibfk_1` FOREIGN KEY (`id_negeri`) REFERENCES `adm_negeri` (`id_negeri`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 232 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Menyimpan senarai mahkamah' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_mahkamah
-- ----------------------------
INSERT INTO `adm_mahkamah` VALUES (1, 'Mahkamah Tinggi Johor Bahru', 1);
INSERT INTO `adm_mahkamah` VALUES (2, 'Mahkamah Tinggi Muar', 1);
INSERT INTO `adm_mahkamah` VALUES (3, 'Mahkamah Seksyen Johor Bahru', 1);
INSERT INTO `adm_mahkamah` VALUES (4, 'Mahkamah Seksyen Kota Tinggi', 1);
INSERT INTO `adm_mahkamah` VALUES (5, 'Mahkamah Seksyen Kluang', 1);
INSERT INTO `adm_mahkamah` VALUES (6, 'Mahkamah Seksyen Batu Pahat', 1);
INSERT INTO `adm_mahkamah` VALUES (7, 'Mahkamah Seksyen Segamat', 1);
INSERT INTO `adm_mahkamah` VALUES (8, 'Mahkamah Seksyen Muar', 1);
INSERT INTO `adm_mahkamah` VALUES (9, 'Mahkamah Majistret Johor Bahru', 1);
INSERT INTO `adm_mahkamah` VALUES (10, 'Mahkamah Majistret Kota Tinggi', 1);
INSERT INTO `adm_mahkamah` VALUES (11, 'Mahkamah Majistret Kluang', 1);
INSERT INTO `adm_mahkamah` VALUES (12, 'Mahkamah Majistret Batu Pahat', 1);
INSERT INTO `adm_mahkamah` VALUES (13, 'Mahkamah Majistret Mersing', 1);
INSERT INTO `adm_mahkamah` VALUES (14, 'Mahkamah Majistret Segamat', 1);
INSERT INTO `adm_mahkamah` VALUES (15, 'Mahkamah Majistret Muar', 1);
INSERT INTO `adm_mahkamah` VALUES (16, 'Mahkamah Majistret Tangkak', 1);
INSERT INTO `adm_mahkamah` VALUES (17, 'Mahkamah Majistret Pontian', 1);
INSERT INTO `adm_mahkamah` VALUES (18, 'Mahkamah Majistret Yong Peng', 1);
INSERT INTO `adm_mahkamah` VALUES (19, 'Mahkamah Majistret Kulai', 1);
INSERT INTO `adm_mahkamah` VALUES (20, 'Mahkamah Tinggi Alor Star', 2);
INSERT INTO `adm_mahkamah` VALUES (21, 'Mahkamah Tinggi Sungai Petani', 2);
INSERT INTO `adm_mahkamah` VALUES (22, 'Mahkamah Seksyen Alor Star', 2);
INSERT INTO `adm_mahkamah` VALUES (23, 'Mahkamah Seksyen Sungai Petani', 2);
INSERT INTO `adm_mahkamah` VALUES (24, 'Mahkamah Seksyen Kulim', 2);
INSERT INTO `adm_mahkamah` VALUES (25, 'Mahkamah Seksyen Langkawi', 2);
INSERT INTO `adm_mahkamah` VALUES (26, 'Mahkamah Majistret Alor Star', 2);
INSERT INTO `adm_mahkamah` VALUES (27, 'Mahkamah Majistret Sungai Petani', 2);
INSERT INTO `adm_mahkamah` VALUES (28, 'Mahkamah Majistret Kulim', 2);
INSERT INTO `adm_mahkamah` VALUES (29, 'Mahkamah Majistret Langkawi', 2);
INSERT INTO `adm_mahkamah` VALUES (30, 'Mahkamah Majistret Jitra', 2);
INSERT INTO `adm_mahkamah` VALUES (31, 'Mahkamah Majistret Kualang Nerang', 2);
INSERT INTO `adm_mahkamah` VALUES (32, 'Mahkamah Majistret Yan', 2);
INSERT INTO `adm_mahkamah` VALUES (33, 'Mahkamah Majistret Gurun', 2);
INSERT INTO `adm_mahkamah` VALUES (34, 'Mahkamah Majistret Baling', 2);
INSERT INTO `adm_mahkamah` VALUES (35, 'Mahkamah Majistret Bandar Baharu', 2);
INSERT INTO `adm_mahkamah` VALUES (36, 'Mahkamah Majistret Sik ', 2);
INSERT INTO `adm_mahkamah` VALUES (37, 'Mahkamah Tinggi Kota Bharu', 3);
INSERT INTO `adm_mahkamah` VALUES (38, 'Mahkamah Seksyen Kota Bahru', 3);
INSERT INTO `adm_mahkamah` VALUES (39, 'Mahkamah Seksyen Gua Musang', 3);
INSERT INTO `adm_mahkamah` VALUES (40, 'Mahkamah Seksyen (Pati) Tanah Merah', 3);
INSERT INTO `adm_mahkamah` VALUES (41, 'Mahkamah Seksyen Pasir Mas', 3);
INSERT INTO `adm_mahkamah` VALUES (42, 'Mahkamah Majistret Kota Bahru', 3);
INSERT INTO `adm_mahkamah` VALUES (43, 'Mahkamah Majistret Gua Musang', 3);
INSERT INTO `adm_mahkamah` VALUES (44, 'Mahkamah Majistret Tanah Merah', 3);
INSERT INTO `adm_mahkamah` VALUES (45, 'Mahkamah Majistret Pasir Mas', 3);
INSERT INTO `adm_mahkamah` VALUES (46, 'Mahkamah Majistret Jeli', 3);
INSERT INTO `adm_mahkamah` VALUES (47, 'Mahkamah Majistret Kuala Krai', 3);
INSERT INTO `adm_mahkamah` VALUES (48, 'Mahkamah Majistret Bachok', 3);
INSERT INTO `adm_mahkamah` VALUES (49, 'Mahkamah Majistret Machang', 3);
INSERT INTO `adm_mahkamah` VALUES (50, 'Mahkamah Majistret Tumpat', 3);
INSERT INTO `adm_mahkamah` VALUES (51, 'Mahkamah Majistret Pasir Puteh', 3);
INSERT INTO `adm_mahkamah` VALUES (52, 'Mahkamah Melaka', 4);
INSERT INTO `adm_mahkamah` VALUES (53, 'Mahkamah Seksyen Alor Gajah', 4);
INSERT INTO `adm_mahkamah` VALUES (54, 'Mahkamah Majistret Alor Gajah', 4);
INSERT INTO `adm_mahkamah` VALUES (55, 'Mahkamah Majistret Jasin', 4);
INSERT INTO `adm_mahkamah` VALUES (56, 'Mahkamah Tinggi Seremban', 5);
INSERT INTO `adm_mahkamah` VALUES (57, 'Mahkamah Seksyen Seremban', 5);
INSERT INTO `adm_mahkamah` VALUES (58, 'Mahkamah Seksyen Kuala Pilah', 5);
INSERT INTO `adm_mahkamah` VALUES (59, 'Mahkamah Majistret Seremban', 5);
INSERT INTO `adm_mahkamah` VALUES (60, 'Mahkamah Majistret Bahau', 5);
INSERT INTO `adm_mahkamah` VALUES (61, 'Mahkamah Majistret Gemas', 5);
INSERT INTO `adm_mahkamah` VALUES (62, 'Mahkamah Majistret Jelebu', 5);
INSERT INTO `adm_mahkamah` VALUES (63, 'Mahkamah Majistret Kuala Pilah', 5);
INSERT INTO `adm_mahkamah` VALUES (64, 'Mahkamah Majistret Port Dickson', 5);
INSERT INTO `adm_mahkamah` VALUES (65, 'Mahkamah Majistret Rembau', 5);
INSERT INTO `adm_mahkamah` VALUES (66, 'Mahkamah Majistret Tampin', 5);
INSERT INTO `adm_mahkamah` VALUES (67, 'Mahkamah Tinggi Kuantan', 6);
INSERT INTO `adm_mahkamah` VALUES (68, 'Mahkamah Tinggi Temerloh', 6);
INSERT INTO `adm_mahkamah` VALUES (69, 'Mahkamah Seksyen Temerloh', 6);
INSERT INTO `adm_mahkamah` VALUES (70, 'Mahkamah Seksyen Kuantan', 6);
INSERT INTO `adm_mahkamah` VALUES (71, 'Mahkamah Seksyen Raub', 6);
INSERT INTO `adm_mahkamah` VALUES (72, 'Mahkamah Sesyen Khas Pati Kemayan', 6);
INSERT INTO `adm_mahkamah` VALUES (73, 'Mahkamah Majistret Kuantan', 6);
INSERT INTO `adm_mahkamah` VALUES (74, 'Mahkamah Majistret Temerloh', 6);
INSERT INTO `adm_mahkamah` VALUES (75, 'Mahkamah Majistret Raub', 6);
INSERT INTO `adm_mahkamah` VALUES (76, 'Mahkamah Majistret Pekan', 6);
INSERT INTO `adm_mahkamah` VALUES (77, 'Mahkamah Majistret Rompin', 6);
INSERT INTO `adm_mahkamah` VALUES (78, 'Mahkamah Majistret Maran', 6);
INSERT INTO `adm_mahkamah` VALUES (79, 'Mahkamah Majistret Bentong', 6);
INSERT INTO `adm_mahkamah` VALUES (80, 'Mahkamah Majistret Jerantut', 6);
INSERT INTO `adm_mahkamah` VALUES (81, 'Mahkamah Majistret Kuala Lipis', 6);
INSERT INTO `adm_mahkamah` VALUES (82, 'Mahkamah Majistret Cameron', 6);
INSERT INTO `adm_mahkamah` VALUES (83, 'Mahkamah Tinggi Georgetown', 7);
INSERT INTO `adm_mahkamah` VALUES (84, 'Mahkamah Tinggi Butterworth', 7);
INSERT INTO `adm_mahkamah` VALUES (85, 'Mahkamah Seksyen Georgetown', 7);
INSERT INTO `adm_mahkamah` VALUES (86, 'Mahkamah Seksyen Butterworth', 7);
INSERT INTO `adm_mahkamah` VALUES (87, 'Mahkamah Seksyen Seberang Prai', 7);
INSERT INTO `adm_mahkamah` VALUES (88, 'Mahkamah Majistret Georgetown', 7);
INSERT INTO `adm_mahkamah` VALUES (89, 'Mahkamah Majistret Butterworth', 7);
INSERT INTO `adm_mahkamah` VALUES (90, 'Mahkamah Majistret Seberang Prai', 7);
INSERT INTO `adm_mahkamah` VALUES (91, 'Mahkamah Majistret Balik Pulau', 7);
INSERT INTO `adm_mahkamah` VALUES (92, 'Mahkamah Majistret Jawi', 7);
INSERT INTO `adm_mahkamah` VALUES (93, 'Mahkamah Majistret Bukit Mertajam', 7);
INSERT INTO `adm_mahkamah` VALUES (94, 'Mahkamah Tinggi Ipoh', 8);
INSERT INTO `adm_mahkamah` VALUES (95, 'Mahkamah Tinggi Taiping', 8);
INSERT INTO `adm_mahkamah` VALUES (96, 'Mahkamah Seksyen Ipoh', 8);
INSERT INTO `adm_mahkamah` VALUES (97, 'Mahkamah Seksyen Taiping', 8);
INSERT INTO `adm_mahkamah` VALUES (98, 'Mahkamah Seksyen Teluk Intan', 8);
INSERT INTO `adm_mahkamah` VALUES (99, 'Mahkamah Seksyen Langkap (PATI)', 8);
INSERT INTO `adm_mahkamah` VALUES (100, 'Mahkamah Seksyen Kuala Kangsar', 8);
INSERT INTO `adm_mahkamah` VALUES (101, 'Mahkamah Majistret Ipoh', 8);
INSERT INTO `adm_mahkamah` VALUES (102, 'Mahkamah Majistret Taiping', 8);
INSERT INTO `adm_mahkamah` VALUES (103, 'Mahkamah Majistret Teluk Intan', 8);
INSERT INTO `adm_mahkamah` VALUES (104, 'Mahkamah Majistret Kuala Kangsar', 8);
INSERT INTO `adm_mahkamah` VALUES (105, 'Mahkamah Majistret Batu Gajah', 8);
INSERT INTO `adm_mahkamah` VALUES (106, 'Mahkamah Majistret Kampar', 8);
INSERT INTO `adm_mahkamah` VALUES (107, 'Mahkamah Majistret Tapah', 8);
INSERT INTO `adm_mahkamah` VALUES (108, 'Mahkamah Majistret Parit Buntar', 8);
INSERT INTO `adm_mahkamah` VALUES (109, 'Mahkamah Majistret Sungai Siput', 8);
INSERT INTO `adm_mahkamah` VALUES (110, 'Mahkamah Majistret Selama', 8);
INSERT INTO `adm_mahkamah` VALUES (111, 'Mahkamah Majistret Manjung', 8);
INSERT INTO `adm_mahkamah` VALUES (112, 'Mahkamah Majistret Slim River', 8);
INSERT INTO `adm_mahkamah` VALUES (113, 'Mahkamah Majistret Gerik', 8);
INSERT INTO `adm_mahkamah` VALUES (114, 'Mahkamah Majistret Lenggong', 8);
INSERT INTO `adm_mahkamah` VALUES (115, 'Mahkamah Majistret Pengkalan Hulu', 8);
INSERT INTO `adm_mahkamah` VALUES (116, 'Mahkamah Majistret Parit', 8);
INSERT INTO `adm_mahkamah` VALUES (117, 'Mahkamah Majistret Pantai Remis', 8);
INSERT INTO `adm_mahkamah` VALUES (118, 'Mahkamah Majistret Tanjung Malim', 8);
INSERT INTO `adm_mahkamah` VALUES (119, 'Mahkamah Tinggi Kangar', 9);
INSERT INTO `adm_mahkamah` VALUES (120, 'Mahkamah Tinggi Kota Kinabalu', 10);
INSERT INTO `adm_mahkamah` VALUES (121, 'Mahkamah Tinggi Sandakan', 10);
INSERT INTO `adm_mahkamah` VALUES (122, 'Mahkamah Tinggi Tawau', 10);
INSERT INTO `adm_mahkamah` VALUES (123, 'Mahkamah Tinggi Labuan', 10);
INSERT INTO `adm_mahkamah` VALUES (124, 'Mahkamah Seksyen Kota Kinabalu ', 10);
INSERT INTO `adm_mahkamah` VALUES (125, 'Mahkamah Seksyen Sandakan', 10);
INSERT INTO `adm_mahkamah` VALUES (126, 'Mahkamah Seksyen Tawau', 10);
INSERT INTO `adm_mahkamah` VALUES (127, 'Mahkamah Seksyen Labuan', 10);
INSERT INTO `adm_mahkamah` VALUES (128, 'Mahkamah Seksyen Semporna', 10);
INSERT INTO `adm_mahkamah` VALUES (129, 'Mahkamah Seksyen Kudat', 10);
INSERT INTO `adm_mahkamah` VALUES (130, 'Mahkamah Seksyen Kota Marudu', 10);
INSERT INTO `adm_mahkamah` VALUES (131, 'Mahkamah Seksyen Pitas', 10);
INSERT INTO `adm_mahkamah` VALUES (132, 'Mahkamah Seksyen Kota Belud', 10);
INSERT INTO `adm_mahkamah` VALUES (133, 'Mahkamah Seksyen Keningau', 10);
INSERT INTO `adm_mahkamah` VALUES (134, 'Mahkamah Seksyen Nabawan', 10);
INSERT INTO `adm_mahkamah` VALUES (135, 'Mahkamah Seksyen Tambunan', 10);
INSERT INTO `adm_mahkamah` VALUES (136, 'Mahkamah Seksyen Sook', 10);
INSERT INTO `adm_mahkamah` VALUES (137, 'Mahkamah Seksyen Tenom', 10);
INSERT INTO `adm_mahkamah` VALUES (138, 'Mahkamah Seksyen Beaufort', 10);
INSERT INTO `adm_mahkamah` VALUES (139, 'Mahkamah Seksyen Kuala Penyu', 10);
INSERT INTO `adm_mahkamah` VALUES (140, 'Mahkamah Seksyen Sipitang', 10);
INSERT INTO `adm_mahkamah` VALUES (141, 'Mahkamah Seksyen Papar', 10);
INSERT INTO `adm_mahkamah` VALUES (142, 'Mahkamah Seksyen Ranau', 10);
INSERT INTO `adm_mahkamah` VALUES (143, 'Mahkamah Seksyen Tuaran', 10);
INSERT INTO `adm_mahkamah` VALUES (144, 'Mahkamah Sesyen Lahad Datu', 10);
INSERT INTO `adm_mahkamah` VALUES (145, 'Mahkamah Majistret Kota Kinabalu ', 10);
INSERT INTO `adm_mahkamah` VALUES (146, 'Mahkamah Majistret Sandakan', 10);
INSERT INTO `adm_mahkamah` VALUES (147, 'Mahkamah Majistret Tawau', 10);
INSERT INTO `adm_mahkamah` VALUES (148, 'Mahkamah Majistret Labuan', 10);
INSERT INTO `adm_mahkamah` VALUES (149, 'Mahkamah Majistret Semporna', 10);
INSERT INTO `adm_mahkamah` VALUES (150, 'Mahkamah Majistret Kudat', 10);
INSERT INTO `adm_mahkamah` VALUES (151, 'Mahkamah Majistret Kota Marudu', 10);
INSERT INTO `adm_mahkamah` VALUES (152, 'Mahkamah Majistret Pitas', 10);
INSERT INTO `adm_mahkamah` VALUES (153, 'Mahkamah Majistret Kota Belud', 10);
INSERT INTO `adm_mahkamah` VALUES (154, 'Mahkamah Majistret Keningau', 10);
INSERT INTO `adm_mahkamah` VALUES (155, 'Mahkamah Majistret Nabawan', 10);
INSERT INTO `adm_mahkamah` VALUES (156, 'Mahkamah Majistret Tambunan', 10);
INSERT INTO `adm_mahkamah` VALUES (157, 'Mahkamah Majistret Sook', 10);
INSERT INTO `adm_mahkamah` VALUES (158, 'Mahkamah Majistret Tenom', 10);
INSERT INTO `adm_mahkamah` VALUES (159, 'Mahkamah Majistret Beaufort', 10);
INSERT INTO `adm_mahkamah` VALUES (160, 'Mahkamah Majistretn Kuala Penyu', 10);
INSERT INTO `adm_mahkamah` VALUES (161, 'Mahkamah Majistret Sipitang', 10);
INSERT INTO `adm_mahkamah` VALUES (162, 'Mahkamah Majistret Papar', 10);
INSERT INTO `adm_mahkamah` VALUES (163, 'Mahkamah Majistret Ranau', 10);
INSERT INTO `adm_mahkamah` VALUES (164, 'Mahkamah Majistret Tuaran', 10);
INSERT INTO `adm_mahkamah` VALUES (165, 'Mahkamah Majistret Lahad Datu', 10);
INSERT INTO `adm_mahkamah` VALUES (166, 'Mahkamah Majistret Beluran', 10);
INSERT INTO `adm_mahkamah` VALUES (167, 'Mahkamah Majistret Kinabatangan ', 10);
INSERT INTO `adm_mahkamah` VALUES (168, 'Mahkamah Majistret Kunak ', 10);
INSERT INTO `adm_mahkamah` VALUES (169, 'Mahkamah Majistret Paitan ', 10);
INSERT INTO `adm_mahkamah` VALUES (170, 'Mahkamah Majistret Tongod', 10);
INSERT INTO `adm_mahkamah` VALUES (171, 'Mahkamah Majistret Telupid', 10);
INSERT INTO `adm_mahkamah` VALUES (172, 'Mahkamah Tinggi Kuching', 11);
INSERT INTO `adm_mahkamah` VALUES (173, 'Mahkamah Tinggi Sibu', 11);
INSERT INTO `adm_mahkamah` VALUES (174, 'Mahkamah Tinggi Miri', 11);
INSERT INTO `adm_mahkamah` VALUES (175, 'Mahkamah Tinggi Sri Aman', 11);
INSERT INTO `adm_mahkamah` VALUES (176, 'Mahkamah Tinggi Bintulu', 11);
INSERT INTO `adm_mahkamah` VALUES (177, 'Mahkamah Tinggi Limbang', 11);
INSERT INTO `adm_mahkamah` VALUES (178, 'Mahkamah Seksyen Kuching', 11);
INSERT INTO `adm_mahkamah` VALUES (179, 'Mahkamah Seksyen Kota Samarahan', 11);
INSERT INTO `adm_mahkamah` VALUES (180, 'Mahkamah Seksyen Sibu', 11);
INSERT INTO `adm_mahkamah` VALUES (181, 'Mahkamah Seksyen Miri ', 11);
INSERT INTO `adm_mahkamah` VALUES (182, 'Mahkamah Seksyen Bintulu', 11);
INSERT INTO `adm_mahkamah` VALUES (183, 'Mahkamah Seksyen Sri Aman', 11);
INSERT INTO `adm_mahkamah` VALUES (184, 'Mahkamah Seksyen Bintulu', 11);
INSERT INTO `adm_mahkamah` VALUES (185, 'Mahkamah Seksyen Limbang', 11);
INSERT INTO `adm_mahkamah` VALUES (186, 'Mahkamah Majistret Kuching', 11);
INSERT INTO `adm_mahkamah` VALUES (187, 'Mahkamah Majistret Sibu', 11);
INSERT INTO `adm_mahkamah` VALUES (188, 'Mahkamah Majistret Miri', 11);
INSERT INTO `adm_mahkamah` VALUES (189, 'Mahkamah Majistret Sri Aman', 11);
INSERT INTO `adm_mahkamah` VALUES (190, 'Mahkamah Majistret Bintulu', 11);
INSERT INTO `adm_mahkamah` VALUES (191, 'Mahkamah Majistret Limbang', 11);
INSERT INTO `adm_mahkamah` VALUES (192, 'Mahkamah Majistret Kota Samarahan', 11);
INSERT INTO `adm_mahkamah` VALUES (193, 'Mahkamah Tinggi Shah Alam', 12);
INSERT INTO `adm_mahkamah` VALUES (194, 'Mahkamah Tinggi Klang', 12);
INSERT INTO `adm_mahkamah` VALUES (195, 'Mahkamah Seksyen Klang', 12);
INSERT INTO `adm_mahkamah` VALUES (196, 'Mahkamah Seksyen Klang (ATIP)', 12);
INSERT INTO `adm_mahkamah` VALUES (197, 'Mahkamah Seksyen Shah Alam', 12);
INSERT INTO `adm_mahkamah` VALUES (198, 'Mahkamah Seksyen Petaling Jaya', 12);
INSERT INTO `adm_mahkamah` VALUES (199, 'Mahkamah Seksyen Ampang', 12);
INSERT INTO `adm_mahkamah` VALUES (200, 'Mahkamah Seksyen Bangi', 12);
INSERT INTO `adm_mahkamah` VALUES (201, 'Mahkamah Seksyen Kajang', 12);
INSERT INTO `adm_mahkamah` VALUES (202, 'Mahkamah Seksyen Sepang', 12);
INSERT INTO `adm_mahkamah` VALUES (203, 'Mahkamah Seksyen Selayang', 12);
INSERT INTO `adm_mahkamah` VALUES (204, 'Mahkamah Seksyen Kuala Kubu Baru', 12);
INSERT INTO `adm_mahkamah` VALUES (205, 'Mahkamah Seksyen Semenyih', 12);
INSERT INTO `adm_mahkamah` VALUES (206, 'Mahkamah Majistret Telok Datok', 12);
INSERT INTO `adm_mahkamah` VALUES (207, 'Mahkamah Majistret Kuala Selangor', 12);
INSERT INTO `adm_mahkamah` VALUES (208, 'Mahkamah Majistret Sungai Besar', 12);
INSERT INTO `adm_mahkamah` VALUES (209, 'Mahkamah Majistret Shah Alam ', 12);
INSERT INTO `adm_mahkamah` VALUES (210, 'Mahkamah Majistret Klang', 12);
INSERT INTO `adm_mahkamah` VALUES (211, 'Mahkamah Majistret Petaling Jaya', 12);
INSERT INTO `adm_mahkamah` VALUES (212, 'Mahkamah Majistret Ampang', 12);
INSERT INTO `adm_mahkamah` VALUES (213, 'Mahkamah Majistret Bangi', 12);
INSERT INTO `adm_mahkamah` VALUES (214, 'Mahkamah Majistret Kajang', 12);
INSERT INTO `adm_mahkamah` VALUES (215, 'Mahkamah Majistret Sepang', 12);
INSERT INTO `adm_mahkamah` VALUES (216, 'Mahkamah Majistret Selayang', 12);
INSERT INTO `adm_mahkamah` VALUES (217, 'Mahkamah Majistret Kuala Kubu Baru', 12);
INSERT INTO `adm_mahkamah` VALUES (218, 'Mahkamah Majistret Semenyih', 12);
INSERT INTO `adm_mahkamah` VALUES (219, 'Mahkamah Tinggi Terengganu', 13);
INSERT INTO `adm_mahkamah` VALUES (220, 'Mahkamah Sesyen Kemaman', 13);
INSERT INTO `adm_mahkamah` VALUES (221, 'Mahkamah Sesyen Setiu', 13);
INSERT INTO `adm_mahkamah` VALUES (222, 'Mahkamah Majistret Kemaman', 13);
INSERT INTO `adm_mahkamah` VALUES (223, 'Mahkamah Majistret Setiu', 13);
INSERT INTO `adm_mahkamah` VALUES (224, 'Mahkamah Majistret Besut', 13);
INSERT INTO `adm_mahkamah` VALUES (225, 'Mahkamah Majistret Dungun', 13);
INSERT INTO `adm_mahkamah` VALUES (226, 'Mahkamah Majistret Kuala Berang', 13);
INSERT INTO `adm_mahkamah` VALUES (227, 'Mahkamah Majistret Marang', 13);
INSERT INTO `adm_mahkamah` VALUES (228, 'Mahkamah Tinggi Kuala Lumpur', 14);
INSERT INTO `adm_mahkamah` VALUES (229, 'Mahkamah Seksyen Kuala Lumpur', 14);
INSERT INTO `adm_mahkamah` VALUES (230, 'Mahkamah Majistret Kuala Lumpur', 14);
INSERT INTO `adm_mahkamah` VALUES (231, 'Mahkamah Majistret Putrajaya', 15);
-- ----------------------------
-- Table structure for adm_modul
-- ----------------------------
DROP TABLE IF EXISTS `adm_modul`;
CREATE TABLE `adm_modul` (
`id_modul` tinyint NOT NULL AUTO_INCREMENT,
`modul` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_modul`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai modul' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_modul
-- ----------------------------
INSERT INTO `adm_modul` VALUES (1, 'Modul Pemerdagangan Orang (TIP)');
INSERT INTO `adm_modul` VALUES (2, 'Modul Penyeludupan Migran (SOM)');
INSERT INTO `adm_modul` VALUES (3, 'Modul Kempen MAPO');
INSERT INTO `adm_modul` VALUES (4, 'Modul Monitoring & Evaluation (M&E)');
INSERT INTO `adm_modul` VALUES (5, 'Modul Pentadbir');
INSERT INTO `adm_modul` VALUES (6, 'Modul Permohonan Online');
INSERT INTO `adm_modul` VALUES (7, 'Modul Monitoring & Evaluation (M&E)');
-- ----------------------------
-- Table structure for adm_negeri
-- ----------------------------
DROP TABLE IF EXISTS `adm_negeri`;
CREATE TABLE `adm_negeri` (
`id_negeri` tinyint NOT NULL AUTO_INCREMENT,
`negeri` varchar(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_negeri`) USING BTREE,
INDEX `id_adm_state`(`id_negeri` ASC) USING BTREE,
INDEX `state_description`(`negeri` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai negeri' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_negeri
-- ----------------------------
INSERT INTO `adm_negeri` VALUES (1, 'Johor');
INSERT INTO `adm_negeri` VALUES (2, 'Kedah');
INSERT INTO `adm_negeri` VALUES (3, 'Kelantan');
INSERT INTO `adm_negeri` VALUES (4, 'Melaka');
INSERT INTO `adm_negeri` VALUES (5, 'Negeri Sembilan');
INSERT INTO `adm_negeri` VALUES (6, 'Pahang');
INSERT INTO `adm_negeri` VALUES (8, 'Perak');
INSERT INTO `adm_negeri` VALUES (9, 'Perlis');
INSERT INTO `adm_negeri` VALUES (7, 'Pulau Pinang');
INSERT INTO `adm_negeri` VALUES (10, 'Sabah');
INSERT INTO `adm_negeri` VALUES (11, 'Sarawak');
INSERT INTO `adm_negeri` VALUES (12, 'Selangor');
INSERT INTO `adm_negeri` VALUES (13, 'Terengganu');
INSERT INTO `adm_negeri` VALUES (14, 'Wilayah Persekutuan Kuala Lumpur');
INSERT INTO `adm_negeri` VALUES (15, 'Wilayah Persekutuan Labuan');
INSERT INTO `adm_negeri` VALUES (16, 'Wilayah Persekutuan Putrajaya');
-- ----------------------------
-- Table structure for adm_organisasi
-- ----------------------------
DROP TABLE IF EXISTS `adm_organisasi`;
CREATE TABLE `adm_organisasi` (
`id_organisasi` tinyint NOT NULL AUTO_INCREMENT,
`organisasi` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_organisasi`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai organisasi' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_organisasi
-- ----------------------------
INSERT INTO `adm_organisasi` VALUES (1, 'Kerajaan');
INSERT INTO `adm_organisasi` VALUES (2, 'NGO');
-- ----------------------------
-- Table structure for adm_peranan
-- ----------------------------
DROP TABLE IF EXISTS `adm_peranan`;
CREATE TABLE `adm_peranan` (
`id_peranan` tinyint NOT NULL AUTO_INCREMENT,
`peranan` varchar(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_peranan`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai peranan' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_peranan
-- ----------------------------
INSERT INTO `adm_peranan` VALUES (1, 'Pentadbir Sistem Bahagian NSO MAPO');
INSERT INTO `adm_peranan` VALUES (2, 'Pentadbir Sistem Bahagian IT');
INSERT INTO `adm_peranan` VALUES (3, 'Pengguna Agensi Penguatkuasaan');
INSERT INTO `adm_peranan` VALUES (4, 'Pengguna AGC');
INSERT INTO `adm_peranan` VALUES (5, 'Pengguna Mahkamah');
INSERT INTO `adm_peranan` VALUES (6, 'Pengguna Rumah Perlindungan');
INSERT INTO `adm_peranan` VALUES (7, 'Pengguna K-KOM');
-- ----------------------------
-- Table structure for adm_seksyen
-- ----------------------------
DROP TABLE IF EXISTS `adm_seksyen`;
CREATE TABLE `adm_seksyen` (
`id_seksyen` tinyint NOT NULL AUTO_INCREMENT,
`seksyen` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_seksyen`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan senarai seksyen' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_seksyen
-- ----------------------------
-- ----------------------------
-- Table structure for adm_status_kes
-- ----------------------------
DROP TABLE IF EXISTS `adm_status_kes`;
CREATE TABLE `adm_status_kes` (
`id_status_kes` tinyint NOT NULL AUTO_INCREMENT,
`status_kes` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_status_kes`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Menyimpan senarai status kes' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of adm_status_kes
-- ----------------------------
INSERT INTO `adm_status_kes` VALUES (1, 'Dalam Siasatan');
INSERT INTO `adm_status_kes` VALUES (2, 'Perbicaraan');
INSERT INTO `adm_status_kes` VALUES (3, 'Selesai');
-- ----------------------------
-- Table structure for akses_modul
-- ----------------------------
DROP TABLE IF EXISTS `akses_modul`;
CREATE TABLE `akses_modul` (
`id_akses_modul` tinyint NOT NULL AUTO_INCREMENT,
`id_pengguna` int NULL DEFAULT NULL,
`id_peranan` tinyint NULL DEFAULT NULL,
`id_modul` tinyint NULL DEFAULT NULL,
`id_akses` tinyint NULL DEFAULT NULL,
PRIMARY KEY (`id_akses_modul`) USING BTREE,
INDEX `id_pengguna`(`id_pengguna` ASC) USING BTREE,
INDEX `id_peranan`(`id_peranan` ASC) USING BTREE,
INDEX `id_modul`(`id_modul` ASC) USING BTREE,
INDEX `id_akses`(`id_akses` ASC) USING BTREE,
CONSTRAINT `akses_modul_ibfk_1` FOREIGN KEY (`id_pengguna`) REFERENCES `pengguna` (`id_pengguna`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `akses_modul_ibfk_2` FOREIGN KEY (`id_peranan`) REFERENCES `adm_peranan` (`id_peranan`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `akses_modul_ibfk_3` FOREIGN KEY (`id_modul`) REFERENCES `adm_modul` (`id_modul`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `akses_modul_ibfk_4` FOREIGN KEY (`id_akses`) REFERENCES `adm_akses` (`id_akses`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat akses modul pengguna' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of akses_modul
-- ----------------------------
-- ----------------------------
-- Table structure for audit_trail
-- ----------------------------
DROP TABLE IF EXISTS `audit_trail`;
CREATE TABLE `audit_trail` (
`id_audit_trail` tinyint NOT NULL AUTO_INCREMENT,
`id_pengguna` int NULL DEFAULT NULL,
`id_modul` tinyint NULL DEFAULT NULL,
`aktiviti` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`tarikh_masa` datetime NULL DEFAULT NULL,
`ip_address` varchar(19) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id_audit_trail`) USING BTREE,
INDEX `id_pengguna`(`id_pengguna` ASC) USING BTREE,
INDEX `id_modul`(`id_modul` ASC) USING BTREE,
CONSTRAINT `audit_trail_ibfk_1` FOREIGN KEY (`id_pengguna`) REFERENCES `pengguna` (`id_pengguna`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `audit_trail_ibfk_2` FOREIGN KEY (`id_modul`) REFERENCES `adm_modul` (`id_modul`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat jejak audit sistem' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of audit_trail
-- ----------------------------
-- ----------------------------
-- Table structure for kempen
-- ----------------------------
DROP TABLE IF EXISTS `kempen`;
CREATE TABLE `kempen` (
`id_kempen` int NOT NULL AUTO_INCREMENT,
`id_jenis_kempen` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_jenis_kempen',
`tahun` year NULL DEFAULT NULL,
`bulan` int NULL DEFAULT NULL,
`bilangan` int NULL DEFAULT NULL,
`catatan` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
`upload` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_kempen`) USING BTREE,
INDEX `id_jenis_kempen`(`id_jenis_kempen` ASC) USING BTREE,
CONSTRAINT `kempen_ibfk_1` FOREIGN KEY (`id_jenis_kempen`) REFERENCES `adm_jenis_kempen` (`id_jenis_kempen`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat kempen' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of kempen
-- ----------------------------
-- ----------------------------
-- Table structure for kes_som
-- ----------------------------
DROP TABLE IF EXISTS `kes_som`;
CREATE TABLE `kes_som` (
`id_kes_som` int NOT NULL AUTO_INCREMENT,
`no_laporan_polis` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kertas_siasatan` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kes_mahkamah` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`id_agensi_penguatkuasa` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_agensi, kategori 3',
`nama_peg_penyiasat` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_tel_peg_penyiasat` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`id_depoh` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_depoh',
`id_jenis_kes` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_jenis_kes',
`id_rumah_perlindungan` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_agensi, kategori 6',
`id_mahkamah` int NULL DEFAULT NULL COMMENT 'rujuk table adm_mahkamah',
`tarikh_deposisi` date NULL DEFAULT NULL,
`tarikh_pertuduhan` date NULL DEFAULT NULL,
`tarikh_sebutan` date NULL DEFAULT NULL,
`tarikh_bicara` date NULL DEFAULT NULL,
`tarikh_sambung_bicara` date NULL DEFAULT NULL,
`tarikh_hujahan` date NULL DEFAULT NULL,
`tarikh_keputusan_kes` date NULL DEFAULT NULL,
`kronologi kes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
`id_status_kes` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_status_kes',
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_kes_som`) USING BTREE,
INDEX `id_jenis_kes`(`id_jenis_kes` ASC) USING BTREE,
INDEX `id_agensi_penguatkuasa`(`id_agensi_penguatkuasa` ASC) USING BTREE,
INDEX `id_rumah_perlindungan`(`id_rumah_perlindungan` ASC) USING BTREE,
INDEX `id_mahkamah`(`id_mahkamah` ASC) USING BTREE,
INDEX `id_depoh`(`id_depoh` ASC) USING BTREE,
INDEX `id_status_kes`(`id_status_kes` ASC) USING BTREE,
CONSTRAINT `kes_som_ibfk_1` FOREIGN KEY (`id_jenis_kes`) REFERENCES `adm_jenis_kes` (`id_jenis_kes`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_som_ibfk_2` FOREIGN KEY (`id_agensi_penguatkuasa`) REFERENCES `adm_agensi` (`id_agensi`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_som_ibfk_3` FOREIGN KEY (`id_rumah_perlindungan`) REFERENCES `adm_agensi` (`id_agensi`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_som_ibfk_4` FOREIGN KEY (`id_mahkamah`) REFERENCES `adm_mahkamah` (`id_mahkamah`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_som_ibfk_5` FOREIGN KEY (`id_depoh`) REFERENCES `adm_depoh` (`id_depoh`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_som_ibfk_6` FOREIGN KEY (`id_status_kes`) REFERENCES `adm_status_kes` (`id_status_kes`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Menyimpan maklumat kes Modul Penyeludupan Migran (SOM)' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of kes_som
-- ----------------------------
-- ----------------------------
-- Table structure for kes_tip
-- ----------------------------
DROP TABLE IF EXISTS `kes_tip`;
CREATE TABLE `kes_tip` (
`id_kes_tip` int NOT NULL AUTO_INCREMENT,
`no_laporan_polis` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kertas_siasatan` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kes_mahkamah` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`id_jenis_kes` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_jenis_kes',
`id_agensi_penguatkuasa` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_agensi, kategori 3',
`id_depoh` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_depoh',
`nama_peg_penyiasat` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_tel_peg_penyiasat` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`id_rumah_perlindungan` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_agensi, kategori 6',
`id_mahkamah` int NULL DEFAULT NULL COMMENT 'rujuk table adm_mahkamah',
`tarikh_deposisi` date NULL DEFAULT NULL,
`tarikh_pertuduhan` date NULL DEFAULT NULL,
`tarikh_sebutan` date NULL DEFAULT NULL,
`tarikh_bicara` date NULL DEFAULT NULL,
`tarikh_sambung_bicara` date NULL DEFAULT NULL,
`tarikh_hujahan` date NULL DEFAULT NULL,
`tarikh_keputusan_kes` date NULL DEFAULT NULL,
`kronologi kes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
`id_status_kes` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_status_kes',
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_kes_tip`) USING BTREE,
INDEX `id_jenis_kes`(`id_jenis_kes` ASC) USING BTREE,
INDEX `id_agensi_penguatkuasa`(`id_agensi_penguatkuasa` ASC) USING BTREE,
INDEX `id_rumah_perlindungan`(`id_rumah_perlindungan` ASC) USING BTREE,
INDEX `id_mahkamah`(`id_mahkamah` ASC) USING BTREE,
INDEX `id_depoh`(`id_depoh` ASC) USING BTREE,
INDEX `id_status_kes`(`id_status_kes` ASC) USING BTREE,
CONSTRAINT `kes_tip_ibfk_1` FOREIGN KEY (`id_jenis_kes`) REFERENCES `adm_jenis_kes` (`id_jenis_kes`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_tip_ibfk_2` FOREIGN KEY (`id_agensi_penguatkuasa`) REFERENCES `adm_agensi` (`id_agensi`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_tip_ibfk_3` FOREIGN KEY (`id_rumah_perlindungan`) REFERENCES `adm_agensi` (`id_agensi`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_tip_ibfk_4` FOREIGN KEY (`id_mahkamah`) REFERENCES `adm_mahkamah` (`id_mahkamah`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_tip_ibfk_5` FOREIGN KEY (`id_depoh`) REFERENCES `adm_depoh` (`id_depoh`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `kes_tip_ibfk_6` FOREIGN KEY (`id_status_kes`) REFERENCES `adm_status_kes` (`id_status_kes`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Menyimpan maklumat kes Modul Pemerdaganagan Orang (TIP)' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of kes_tip
-- ----------------------------
-- ----------------------------
-- Table structure for laporan_polis_som
-- ----------------------------
DROP TABLE IF EXISTS `laporan_polis_som`;
CREATE TABLE `laporan_polis_som` (
`id_laporan_polis` tinyint NOT NULL AUTO_INCREMENT,
`id_kes_som` int NULL DEFAULT NULL COMMENT 'rujuk table kes',
`no_laporan_polis` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`laporan_polis` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_laporan_polis`) USING BTREE,
INDEX `id_kes`(`id_kes_som` ASC) USING BTREE,
CONSTRAINT `laporan_polis_som_ibfk_1` FOREIGN KEY (`id_kes_som`) REFERENCES `kes_som` (`id_kes_som`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat laporan polis kes SOM' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of laporan_polis_som
-- ----------------------------
-- ----------------------------
-- Table structure for laporan_polis_tip
-- ----------------------------
DROP TABLE IF EXISTS `laporan_polis_tip`;
CREATE TABLE `laporan_polis_tip` (
`id_laporan_polis` tinyint NOT NULL AUTO_INCREMENT,
`id_kes_tip` int NULL DEFAULT NULL COMMENT 'rujuk table kes',
`no_laporan_polis` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`laporan_polis` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_laporan_polis`) USING BTREE,
INDEX `id_kes`(`id_kes_tip` ASC) USING BTREE,
CONSTRAINT `laporan_polis_tip_ibfk_1` FOREIGN KEY (`id_kes_tip`) REFERENCES `kes_tip` (`id_kes_tip`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat laporan polis kes TIP' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of laporan_polis_tip
-- ----------------------------
-- ----------------------------
-- Table structure for latihan
-- ----------------------------
DROP TABLE IF EXISTS `latihan`;
CREATE TABLE `latihan` (
`id_latihan` int NOT NULL AUTO_INCREMENT,
`id_agensi` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_agensi',
`jenis_latihan` tinyint NULL DEFAULT NULL COMMENT '1=Individu, 2=Berkumpulan',
`tajuk_latihan` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`tarikh_mula_latihan` date NULL DEFAULT NULL,
`tarikh_akhir_latihan` date NULL DEFAULT NULL,
`lokasi` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`anjuran` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_latihan`) USING BTREE,
INDEX `id_agensi`(`id_agensi` ASC) USING BTREE,
CONSTRAINT `latihan_ibfk_1` FOREIGN KEY (`id_agensi`) REFERENCES `adm_agensi` (`id_agensi`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat latihan' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of latihan
-- ----------------------------
-- ----------------------------
-- Table structure for mangsa
-- ----------------------------
DROP TABLE IF EXISTS `mangsa`;
CREATE TABLE `mangsa` (
`id_mangsa` int NOT NULL AUTO_INCREMENT,
`id_kes_tip` int NULL DEFAULT NULL COMMENT 'rujuk table kes',
`id_rp` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm agensi, kategori 6',
`tarikh_masuk_rp` date NULL DEFAULT NULL,
`tarikh_keluar_rp` date NULL DEFAULT NULL,
`nama` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kp_pasport` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`tarikh_lahir` date NULL DEFAULT NULL,
`warganegara` tinyint NULL DEFAULT NULL COMMENT '1=Warganegara, 2=Bukan Warganegara',
`id_jantina` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_jantina',
`id_agama` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_agama',
`gambar` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`id_pegawai_pelindung` tinyint NULL DEFAULT NULL COMMENT 'rujuk table pegawai_pelindung',
`jurubahasa` tinyint NULL DEFAULT NULL COMMENT '1=Ya, 2=Tidak',
`vas` tinyint NULL DEFAULT NULL COMMENT '1=Ya, 2=Tidak',
`tempat` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_mangsa`) USING BTREE,
INDEX `id_kes`(`id_kes_tip` ASC) USING BTREE,
INDEX `id_rumah_perlindungan`(`id_rp` ASC) USING BTREE,
INDEX `id_pegawai_pelindung`(`id_pegawai_pelindung` ASC) USING BTREE,
INDEX `mangsa_ibfk_3`(`id_agama` ASC) USING BTREE,
INDEX `id_jantina`(`id_jantina` ASC) USING BTREE,
CONSTRAINT `mangsa_ibfk_1` FOREIGN KEY (`id_kes_tip`) REFERENCES `kes_tip` (`id_kes_tip`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `mangsa_ibfk_2` FOREIGN KEY (`id_rp`) REFERENCES `adm_agensi` (`id_agensi`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `mangsa_ibfk_3` FOREIGN KEY (`id_agama`) REFERENCES `adm_agama` (`id_agama`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `mangsa_ibfk_4` FOREIGN KEY (`id_pegawai_pelindung`) REFERENCES `pegawai_pelindung` (`id_pegawai_pelindung`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `mangsa_ibfk_5` FOREIGN KEY (`id_jantina`) REFERENCES `adm_jantina` (`id_jantina`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat mangsa' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of mangsa
-- ----------------------------
-- ----------------------------
-- Table structure for mangsa_ipo
-- ----------------------------
DROP TABLE IF EXISTS `mangsa_ipo`;
CREATE TABLE `mangsa_ipo` (
`id_mangsa_po` int NOT NULL AUTO_INCREMENT,
`id_mangsa` int NULL DEFAULT NULL COMMENT 'rujuk table mangsa',
`tarikh_mula_perintah` date NULL DEFAULT NULL,
`tarikh_tamat_perintah` date NULL DEFAULT NULL,
`pejabat_pengeluar` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_mangsa_po`) USING BTREE,
INDEX `id_mangsa`(`id_mangsa` ASC) USING BTREE,
CONSTRAINT `mangsa_ipo_ibfk_1` FOREIGN KEY (`id_mangsa`) REFERENCES `mangsa` (`id_mangsa`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat mangsa Interim Protection Order (IPO)' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of mangsa_ipo
-- ----------------------------
-- ----------------------------
-- Table structure for mangsa_kb
-- ----------------------------
DROP TABLE IF EXISTS `mangsa_kb`;
CREATE TABLE `mangsa_kb` (
`id_mangsa_kb` int NOT NULL AUTO_INCREMENT,
`id_mangsa` int NULL DEFAULT NULL COMMENT 'rujuk table magsa',
`tarikh_permohonan` date NULL DEFAULT NULL,
`status` tinyint NULL DEFAULT NULL,
`tarikh_kuatkuasa` date NULL DEFAULT NULL,
`nama_majikan` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`jenis_pekerjaan` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`catatan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`borang_persetujuan_bekerja` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_mangsa_kb`) USING BTREE,
INDEX `id_mangsa`(`id_mangsa` ASC) USING BTREE,
CONSTRAINT `mangsa_kb_ibfk_1` FOREIGN KEY (`id_mangsa`) REFERENCES `mangsa` (`id_mangsa`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat mangsa Kebenaran Bekerja (KB)' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of mangsa_kb
-- ----------------------------
-- ----------------------------
-- Table structure for mangsa_kbb
-- ----------------------------
DROP TABLE IF EXISTS `mangsa_kbb`;
CREATE TABLE `mangsa_kbb` (
`id_mangsa_kbb` int NOT NULL AUTO_INCREMENT,
`id_mangsa` int NULL DEFAULT NULL COMMENT 'rujuk table mangsa',
`tarikh_permohonan` date NULL DEFAULT NULL,
`status` tinyint NULL DEFAULT NULL,
`tarikh_kuatkuasa` date NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_mangsa_kbb`) USING BTREE,
INDEX `id_mangsa`(`id_mangsa` ASC) USING BTREE,
CONSTRAINT `mangsa_kbb_ibfk_1` FOREIGN KEY (`id_mangsa`) REFERENCES `mangsa` (`id_mangsa`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat mangsa Kebenaran Bergerak Bebas (KBB)' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of mangsa_kbb
-- ----------------------------
-- ----------------------------
-- Table structure for mangsa_pjpl
-- ----------------------------
DROP TABLE IF EXISTS `mangsa_pjpl`;
CREATE TABLE `mangsa_pjpl` (
`id_mangsa_pjpl` int NOT NULL AUTO_INCREMENT,
`id_mangsa` int NULL DEFAULT NULL COMMENT 'rujuk table mangsa',
`tarikh_mula_perintah` date NULL DEFAULT NULL,
`tarikh_tamat_perintah` date NULL DEFAULT NULL,
`pejabat_pengeluar` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_mangsa_pjpl`) USING BTREE,
INDEX `id_mangsa`(`id_mangsa` ASC) USING BTREE,
CONSTRAINT `mangsa_pjpl_ibfk_1` FOREIGN KEY (`id_mangsa`) REFERENCES `mangsa` (`id_mangsa`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat mangsa Perintah Jagaan Lanjutan (PJPL)' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of mangsa_pjpl
-- ----------------------------
-- ----------------------------
-- Table structure for mangsa_po
-- ----------------------------
DROP TABLE IF EXISTS `mangsa_po`;
CREATE TABLE `mangsa_po` (
`id_mangsa_po` int NOT NULL AUTO_INCREMENT,
`id_mangsa` int NULL DEFAULT NULL COMMENT 'rujuk table mangsa',
`tarikh_mula_perintah` date NULL DEFAULT NULL,
`tarikh_tamat_perintah` date NULL DEFAULT NULL,
`pejabat_pengeluar` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_mangsa_po`) USING BTREE,
INDEX `id_mangsa`(`id_mangsa` ASC) USING BTREE,
CONSTRAINT `mangsa_po_ibfk_1` FOREIGN KEY (`id_mangsa`) REFERENCES `mangsa` (`id_mangsa`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat mangsa Protection Order (PO)' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of mangsa_po
-- ----------------------------
-- ----------------------------
-- Table structure for okt
-- ----------------------------
DROP TABLE IF EXISTS `okt`;
CREATE TABLE `okt` (
`id_okt` int NOT NULL AUTO_INCREMENT,
`id_kes_tip` int NULL DEFAULT NULL COMMENT 'rujuk table kes',
`no_laporan_polis` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`nama` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kp` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_pasport` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`id_jantina` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_jantina',
`warganegara` tinyint NULL DEFAULT NULL COMMENT '1=Warganegara, 2=Bukan Warganegara',
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_okt`) USING BTREE,
INDEX `id_kes`(`id_kes_tip` ASC) USING BTREE,
INDEX `id_jantina`(`id_jantina` ASC) USING BTREE,
CONSTRAINT `okt_ibfk_1` FOREIGN KEY (`id_kes_tip`) REFERENCES `kes_tip` (`id_kes_tip`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `okt_ibfk_2` FOREIGN KEY (`id_jantina`) REFERENCES `adm_jantina` (`id_jantina`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat OKT' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of okt
-- ----------------------------
-- ----------------------------
-- Table structure for okt_pertuduhan
-- ----------------------------
DROP TABLE IF EXISTS `okt_pertuduhan`;
CREATE TABLE `okt_pertuduhan` (
`id_okt_pertuduhan` int NOT NULL AUTO_INCREMENT,
`id_okt` int NULL DEFAULT NULL COMMENT 'rujuak table okt',
`id_akta` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_akta',
`id_seksyen` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_akta',
`tarikh_pertuduhan` date NULL DEFAULT NULL,
`catatan` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_okt_pertuduhan`) USING BTREE,
INDEX `id_okt`(`id_okt` ASC) USING BTREE,
INDEX `id_seksyen`(`id_seksyen` ASC) USING BTREE,
INDEX `okt_pertuduhan_ibfk_3`(`id_akta` ASC) USING BTREE,
CONSTRAINT `okt_pertuduhan_ibfk_1` FOREIGN KEY (`id_okt`) REFERENCES `okt` (`id_okt`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `okt_pertuduhan_ibfk_2` FOREIGN KEY (`id_akta`) REFERENCES `adm_akta` (`id_akta`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `okt_pertuduhan_ibfk_3` FOREIGN KEY (`id_seksyen`) REFERENCES `adm_seksyen` (`id_seksyen`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat pertuduhan OKT' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of okt_pertuduhan
-- ----------------------------
-- ----------------------------
-- Table structure for okt_sabitan
-- ----------------------------
DROP TABLE IF EXISTS `okt_sabitan`;
CREATE TABLE `okt_sabitan` (
`id_okt_sabitan` int NOT NULL AUTO_INCREMENT,
`id_okt` int NULL DEFAULT NULL COMMENT 'rujuk table okt',
`id_akta` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_akta',
`id_seksyen` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_akta',
`tarikh_sabitan` date NULL DEFAULT NULL,
`hukuman` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`penjara_tahun` int NULL DEFAULT NULL,
`penjara_bulan` int NULL DEFAULT NULL,
`penjara_seumur_hidup` tinyint NULL DEFAULT NULL COMMENT '1=Ya, 2=Tidak',
`denda` decimal(19, 2) NULL DEFAULT NULL,
`sebatan` int NULL DEFAULT NULL,
`bayaran_pampasan` decimal(19, 2) NULL DEFAULT NULL,
`bayaran_tunggakan_gaji` decimal(19, 2) NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_okt_sabitan`) USING BTREE,
INDEX `id_okt`(`id_okt` ASC) USING BTREE,
INDEX `id_akta`(`id_akta` ASC) USING BTREE,
INDEX `okt_sabitan_ibfk_3`(`id_seksyen` ASC) USING BTREE,
CONSTRAINT `okt_sabitan_ibfk_1` FOREIGN KEY (`id_okt`) REFERENCES `okt` (`id_okt`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `okt_sabitan_ibfk_2` FOREIGN KEY (`id_akta`) REFERENCES `adm_akta` (`id_akta`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `okt_sabitan_ibfk_3` FOREIGN KEY (`id_seksyen`) REFERENCES `adm_seksyen` (`id_seksyen`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat sabitan OKT' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of okt_sabitan
-- ----------------------------
-- ----------------------------
-- Table structure for pati
-- ----------------------------
DROP TABLE IF EXISTS `pati`;
CREATE TABLE `pati` (
`id_pati` int NOT NULL AUTO_INCREMENT,
`id_kes_som` int NULL DEFAULT NULL COMMENT 'rujuk table kes',
`nama` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_pasport` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`warganegara` tinyint NULL DEFAULT NULL COMMENT '1=Warganegara, 2=Bukan Warganegara',
`id_jantina` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_jantina',
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_pati`) USING BTREE,
INDEX `id_kes`(`id_kes_som` ASC) USING BTREE,
INDEX `id_jantina`(`id_jantina` ASC) USING BTREE,
CONSTRAINT `pati_ibfk_1` FOREIGN KEY (`id_kes_som`) REFERENCES `kes_som` (`id_kes_som`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `pati_ibfk_5` FOREIGN KEY (`id_jantina`) REFERENCES `adm_jantina` (`id_jantina`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat mangsa' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of pati
-- ----------------------------
-- ----------------------------
-- Table structure for pati_pertuduhan
-- ----------------------------
DROP TABLE IF EXISTS `pati_pertuduhan`;
CREATE TABLE `pati_pertuduhan` (
`id_okt_pertuduhan` int NOT NULL AUTO_INCREMENT,
`id_pati` int NULL DEFAULT NULL COMMENT 'rujuak table okt',
`id_akta` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_akta',
`id_seksyen` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_akta',
`tarikh_pertuduhan` date NULL DEFAULT NULL,
`catatan` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_okt_pertuduhan`) USING BTREE,
INDEX `id_okt`(`id_pati` ASC) USING BTREE,
INDEX `id_seksyen`(`id_seksyen` ASC) USING BTREE,
INDEX `okt_pertuduhan_ibfk_3`(`id_akta` ASC) USING BTREE,
CONSTRAINT `pati_pertuduhan_ibfk_1` FOREIGN KEY (`id_pati`) REFERENCES `pati` (`id_pati`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `pati_pertuduhan_ibfk_2` FOREIGN KEY (`id_akta`) REFERENCES `adm_akta` (`id_akta`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `pati_pertuduhan_ibfk_3` FOREIGN KEY (`id_seksyen`) REFERENCES `adm_seksyen` (`id_seksyen`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat pertuduhan PATI' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of pati_pertuduhan
-- ----------------------------
-- ----------------------------
-- Table structure for pati_sabitan
-- ----------------------------
DROP TABLE IF EXISTS `pati_sabitan`;
CREATE TABLE `pati_sabitan` (
`id_okt_sabitan` int NOT NULL AUTO_INCREMENT,
`id_okt` int NULL DEFAULT NULL COMMENT 'rujuk table okt',
`id_akta` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_akta',
`id_seksyen` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_akta',
`tarikh_sabitan` date NULL DEFAULT NULL,
`hukuman` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`penjara_tahun` int NULL DEFAULT NULL,
`penjara_bulan` int NULL DEFAULT NULL,
`penjara_seumur_hidup` tinyint NULL DEFAULT NULL COMMENT '1=Ya, 2=Tidak',
`denda` decimal(19, 2) NULL DEFAULT NULL,
`sebatan` int NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_okt_sabitan`) USING BTREE,
INDEX `id_okt`(`id_okt` ASC) USING BTREE,
INDEX `id_akta`(`id_akta` ASC) USING BTREE,
INDEX `okt_sabitan_ibfk_3`(`id_seksyen` ASC) USING BTREE,
CONSTRAINT `pati_sabitan_ibfk_1` FOREIGN KEY (`id_okt`) REFERENCES `pati` (`id_pati`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `pati_sabitan_ibfk_2` FOREIGN KEY (`id_akta`) REFERENCES `adm_akta` (`id_akta`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `pati_sabitan_ibfk_3` FOREIGN KEY (`id_seksyen`) REFERENCES `adm_seksyen` (`id_seksyen`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat sabitan PATI' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of pati_sabitan
-- ----------------------------
-- ----------------------------
-- Table structure for pegawai_pelindung
-- ----------------------------
DROP TABLE IF EXISTS `pegawai_pelindung`;
CREATE TABLE `pegawai_pelindung` (
`id_pegawai_pelindung` tinyint NOT NULL AUTO_INCREMENT,
`nama` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kp` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_telefon` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`emel` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`id_organisasi` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_organisasi',
`agensi_jabatan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`negeri_bahagian` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`sijil_lantikan` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`tarikh_lantikan` date NULL DEFAULT NULL,
`tarikh_tamat_lantikan` date NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_pegawai_pelindung`) USING BTREE,
INDEX `id_organisasi`(`id_organisasi` ASC) USING BTREE,
CONSTRAINT `pegawai_pelindung_ibfk_1` FOREIGN KEY (`id_organisasi`) REFERENCES `adm_organisasi` (`id_organisasi`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat pegawai pelindung' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of pegawai_pelindung
-- ----------------------------
-- ----------------------------
-- Table structure for pengguna
-- ----------------------------
DROP TABLE IF EXISTS `pengguna`;
CREATE TABLE `pengguna` (
`id_pengguna` int NOT NULL AUTO_INCREMENT,
`nama` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kp` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT ' ',
`katalaluan` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`emel` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_telefon` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`jawatan` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'rujuk table adm_jawatan',
`id_agensi` tinyint NULL DEFAULT NULL COMMENT 'rujuk table adm_agensi',
`gambar` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`status_pengguna` tinyint NULL DEFAULT 1 COMMENT '0=tidak aktif,1=aktif',
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_pengguna`) USING BTREE,
INDEX `pengguna_fk1`(`id_agensi` ASC) USING BTREE,
CONSTRAINT `pengguna_ibfk_1` FOREIGN KEY (`id_agensi`) REFERENCES `adm_agensi` (`id_agensi`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat pengguna sistem' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of pengguna
-- ----------------------------
-- ----------------------------
-- Table structure for peserta
-- ----------------------------
DROP TABLE IF EXISTS `peserta`;
CREATE TABLE `peserta` (
`id_peserta` int NOT NULL AUTO_INCREMENT,
`nama` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`no_kp` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`cipta_pada` datetime NULL DEFAULT NULL,
`cipta_oleh` int NULL DEFAULT NULL,
`kemaskini_pada` datetime NULL DEFAULT NULL,
`kemaskini_oleh` int NULL DEFAULT NULL,
PRIMARY KEY (`id_peserta`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat peserta' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of peserta
-- ----------------------------
-- ----------------------------
-- Table structure for peserta_latihan
-- ----------------------------
DROP TABLE IF EXISTS `peserta_latihan`;
CREATE TABLE `peserta_latihan` (
`id_peserta_latihan` int NOT NULL AUTO_INCREMENT,
`id_peserta` int NULL DEFAULT NULL,
`id_latihan` int NULL DEFAULT NULL,
PRIMARY KEY (`id_peserta_latihan`) USING BTREE,
INDEX `id_peserta`(`id_peserta` ASC) USING BTREE,
INDEX `id_latihan`(`id_latihan` ASC) USING BTREE,
CONSTRAINT `peserta_latihan_ibfk_1` FOREIGN KEY (`id_peserta`) REFERENCES `peserta` (`id_peserta`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `peserta_latihan_ibfk_2` FOREIGN KEY (`id_latihan`) REFERENCES `latihan` (`id_latihan`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Menyimpan maklumat peserta latihan' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of peserta_latihan
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;
Borang Penilaian Keberkesanan Latihan
Training evaluation · CodeIgniter 4 Training for Beginner
Log in with the account you registered for this training to fill in the survey.
Log in to fill in the surveyAttendance
Registration closed
This training ended on 30 Sep 2022, so new attendance can no longer be registered.
Students (7)
| # | Name |
|---|---|
| 1. | Sharifah Noor Shatila bt Syed Othman |
| 2. | NUR SARINI BINTI ABD RAHIM |
| 3. | Vimalavathy A/P Muthu Krishnan |
| 4. | Nur Shafiliana binti Alias |
| 5. | NUR AZRI BIN ZAKARIA |
| 6. | Noor Faizah Binti zakaria |
| 7. | Aminah Mahmood |