TDD

(TECHNICAL DATA DOCUMENT)

DPPM

DOCUMENT NO. : DPPM-TDD-191202-0001-0002

DOCUMENT TITLE: TECHNICAL DATA DOCUMENT
VERSION: 1.0

PT. Citraweb Digital Multisolusi

Jalan Petung NO 31, Papringan, Yogyakarta, Indonesia 55281
P : +62 274 554 444
F : +62 274 554 444
W : http://www.citra.web.id
Document No.: DPPM - TDD

JUDUL DOKUMEN
Nama Project : DPPM

Nama Client : Dinas Perizinan dan Penaman Modal DIY

No. Contract :-

No. Amendment :-

Project Manager : Andayani Mustikawati Marhaendra Puteri (PT. Citraweb Digital Multisolusi)

Project Contact : Andayani Mustikawati Marhaendra Puteri (PT. Citraweb Digital Multisolusi)

Nama Dokumen : Technical Data Document

Tanggal Publikasi : 02 Desember 2019

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 2
Document No.: DPPM - TDD

PERSETUJUAN DOKUMEN
Ulasan dan Penerimaan
Otorisasi:

Diketahui Oleh:

Project Manager

Pihak DPPM Pihak DPPM

NIK : NIK :
Date : Date :

CITRAWEB

Project Manager Account Manager

Andayani Mustikawati Marhaendra Putri Aditya Prakoso

Manager Produksi Deputy Teknis

Rizaldi Mulyatno Urip Tri Prastowo

Mangetahui,
Direktur

Ronal Rivandy

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 3
Document No.: DPPM - TDD

REVISI
Date Author Version Change Description

Desember 02, 2019 Citraweb 1.0 Dokumen Pertama

Team

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 4
Document No.: DPPM - TDD

DAFTAR ISI
JUDUL DOKUMEN ............................................................................................................................. 2
PERSETUJUAN DOKUMEN ................................................................................................................. 3
REVISI ............................................................................................................................................... 4
DAFTAR ISI ........................................................................................................................................ 5
1 PROJECT OVERVIEW................................................................................................................... 7
1.1 Preface ............................................................................................................................................. 7
1.2 Purpose ............................................................................................................................................ 7
2 SYSTEM ENVIRONMENT............................................................................................................. 8
2.1 Application Architecture.................................................................................................................... 8
2.2 Machine Specification ....................................................................................................................... 8
2.3 Interaction with Other System........................................................................................................... 9
3 OBJECT LIST .............................................................................................................................. 10
4 DATA FILE FORMAT .................................................................................................................. 11
4.1 ER Diagram ..................................................................................................................................... 11
4.2 RDBMS............................................................................................................................................ 11
4.2.1 MySql Table Structure .............................................................................................................. 12
4.2.1.1 CNI_AGENDA ......................................................................................................................................12
4.2.1.2 CNI_BANNER ......................................................................................................................................13
4.2.1.3 CNI_BLOCKS .......................................................................................................................................13
4.2.1.4 CNI_COMMENTS ................................................................................................................................14
4.2.1.5 CNI_CONFIG .......................................................................................................................................14
4.2.1.6 CNI_CONTACT ....................................................................................................................................15
4.2.1.7 CNI_DOWNLOAD ................................................................................................................................16
4.2.1.8 CNI_ EMAIL_TEMPLATE ......................................................................................................................16
4.2.1.9 CNI_ GALLERY_IMAGE.........................................................................................................................16
4.2.1.10 CNI_LANDING .................................................................................................................................17
4.2.1.11 CNI_LINKS ......................................................................................................................................17
4.2.1.12 CNI_MENU .....................................................................................................................................17
4.2.1.13 CNI_MODULES ...............................................................................................................................18
4.2.1.14 CNI_MEMBER .................................................................................................................................18
4.2.1.15 CNI_MENU .....................................................................................................................................18
4.2.1.16 CNI_MODULES ...............................................................................................................................18
4.2.1.17 CNI_NO_COUNTRY .........................................................................................................................19
4.2.1.18 CNI_PAGES .....................................................................................................................................19
4.2.1.19 CNI_PAGES_CONTENT ....................................................................................................................20
4.2.1.20 CNI_PARAMS ..................................................................................................................................20
4.2.1.21 CNI_PERIZINAN...............................................................................................................................21
4.2.1.22 CNI_PHONEBOOK ...........................................................................................................................21
4.2.1.23 CNI_POSTS .....................................................................................................................................21
4.2.1.24 CNI_RUNNING_TEXT .......................................................................................................................22
4.2.1.25 CNI_SLIDER.....................................................................................................................................22
4.2.1.26 CNI_STATISTIK ................................................................................................................................23
4.2.1.27 CNI_TEAM ......................................................................................................................................23
4.2.1.28 CNI_TRACEY ...................................................................................................................................23
4.2.1.29 CNI_USER .......................................................................................................................................24
4.2.1.30 CNI_USER_GROUP ..........................................................................................................................24
4.2.1.31 CNI_USER_LOG ...............................................................................................................................24
4.2.1.32 CNI_VIDEO .....................................................................................................................................24

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 5
Document No.: DPPM - TDD

4.2.1.33 CNI_VISITOR ...................................................................................................................................25

4.3 Format Data Output ........................................................................................................................ 25
5 TECHNICAL DETAIL ................................................................................................................... 26
5.1 Use Case Diagram ........................................................................................................................... 26
5.2 Global Process................................................................................................................................. 27
5.3 FLOW PROCESS ................................................................................................................................... 28
5.4 Class Diagram.................................................................................................................................. 29

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 6
Document No.: DPPM - TDD

1 Project Overview
1.1 Preface
Dinas Perizinan dan Penanaman Modal DIY adalah Perangkat Daerah Provinsi bidang Penanaman Modal yang
merupakan unsur pembantu Gubernur Provinsi DIY dalam rangka penyelenggaraan pemerintahan daerah provinsi dalam
menyelenggarakan fungsi utama perizinan dan koordinasi bidang penanaman modal di Pemerintah Provinsi DIY. DPPM
DIY melaksanakan perencanaan dan promosi penanaman modal, kerjasama penanaman modal, fasilitasi dan perizinan
penanaman modal, dan pengendalian penanaman.

1.2 Purpose
Tujuan dibuatnya proyek ini adalah untuk:
1. Untuk membuat sistem yang yang berguna untuk mensosialisasikan DPPM DIY
2. Untuk membuat sistem yang mampu melakukan interaksi antara DPPM dan masyarakat
3. Untuk membuat sistem untuk mengintegrasikan manual data dengan sistem terkomputerisasi

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 7
Document No.: DPPM - TDD

2 SYSTEM ENVIRONMENT
2.1 Application Architecture
Diagram berikut menggambarkan design arsitektur, implementasi dan skema jaringan dari aplikasi jogjainvest:

Data Data Perizinan

Data Category
Content Data Sub Category
Manual Data Statistik
Data Running Text
Data Pages
Data Post
Data Gallery Image
Data Video
Data Banner
Data Slider
Data Links
Data Download
Data Agenda
Data Slider RDBMS
Data Banner
Data Kontak
Data Statistik

Figure 1. Arsitektur Website DPPM

2.2 Machine Specification

Proyek ini berjalan pada spesifikasi mesin seperti berikut:

No Jenis Software Nama Software

1 File System -
2 No SQL -
3 Database My SQL
4 Data Processing -
5 O/S Windows dan Linux
6 Cluster Management
7 Application Apache web server, Cpanel
Table 1. Spesifikasi Mesin Website DPPM
Spesifikasi Hardware:
-

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 8
Document No.: DPPM - TDD

2.3 Interaction with Other System

There is no interaction to another applications and network elements

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 9
Document No.: DPPM - TDD

3 OBJECT LIST
Tidak berkaitan

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 10
Document No.: DPPM - TDD

4 DATA FILE FORMAT

4.1 ER Diagram

Figure 2. Digram ER – Website DPPM

4.2 RDBMS
RDBMS tables can be accessed directly using SQL*Net, ODBC or JDBC. A valid network connection is the only thing
needed to access these tables, including the valid username, password and the database definition. The tables for the
module is given in the list below:

NEW/
NO NAME DESCRIPTION
EXISTING

MySql

1. Tabel ini digunakan untuk menyimpan data banner yang

CNI_BANNER Baru
akan ditampilkan di web client
2. Tabel ini digunakan untuk menyimpan data agenda yang
CNI_AGENDA
akan ditampilkan di web client
3. Tabel ini digunakan untuk menyimpan data widget yang
CNI_BLOCKS Baru
akan ditampilkan di web client
4. Tabel ini digunakan untuk menyimpan data kategori artikel
CNI_CATEGORY Baru
atau pages
5. Tabel ini digunakan untuk menyimpan data komentar yang
CNI_COMMENTS Baru
masuk dari user
6. Tabel ini digunakan untuk menyimpan data konfigurasi
CNI_CONFIG Baru
sistem website
7. Tabel ini digunakan untuk menyimpan dat contact person
CNI_CONTACT Baru
dari sebuah halaman contact
8. CNI_DOWNLOAD Tabel ini digunakan untuk menyimpan data file download Baru
9. Tabel ini digunakan untuk menyimpan data template email
CNI_EMAIL_TEMPLATE
untuk keperluan balasan kontak
10. Tabel ini digunakan untuk menyimpan data foto gallery
CNI_GALLERY_IMAGE Baru
yang akan ditampilkan di web client

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 11
Document No.: DPPM - TDD

NEW/
NO NAME DESCRIPTION
EXISTING

11. Tabel ini digunakan untuk menyimpan data link yang akan
CNI_LINKS Baru
ditampilkan di web client
12. Tabel ini digunakan untuk menyimpan data landing page
CNI_LANDING Baru
yang akan ditampilkan di web client
13. Tabel ini digunakan untuk menyimpan data member atau
CNI_MEMBER Baru
pengguna web client
14. Tabel ini digunakan untuk menyimpan data menu pada
CNI_MENU Baru
tampilan web client
15. Tabel ini digunakan untuk menyimpan data modules pada
CNI_MODULES Baru
tampilan web client
16. Tabel ini digunakan untuk menyimpan data nomor atau
CNI_NO_COUNTRY Baru
kode negara
17. Tabel ini digunakan untuk menyimpan data halaman yang
CNI_PAGES Baru
akan ditampilkan
18. Tabel ini digunakan untuk menyimpan data content pada
CNI_PAGES_CONTENT Baru
halaman tertentu di web client
19. Tabel ini digunakan untuk menyimpan data parameter
CNI_PARAMS Baru
yang dibutuhkan
20. Tabel ini digunakan untuk menyimpan data perizinan yang
CNI_PERIZINAN
dibutuhkan
21. Tabel ini digunakan untuk menyimpan data phonebook
CNI_PHONEBOOK
yang dibutuhkan
22. Tabel ini digunakan untuk menyimpan data posts artikel
CNI_POSTS Baru
atau berita
23. Tabel ini digunakan untuk menyimpan data slider yang
CNI_SLIDER Baru
akan ditampilkan di web client
24. CNI_STATISTIK Tabel ini digunakan untuk menyimpan data statistik Baru
25. CNI_TRACEY Tabel ini digunakan untuk menyimpan data tracey
26. CNI_TEAM Tabel ini digunakan untuk menyimpan data team
27. CNI_USER Tabel ini digunakan untuk menyimpan data user Baru
28. CNI_USER_GROUP Tabel ini digunakan untuk menyimpan data group user Baru
29. Tabel ini digunakan untuk menyimpan data log aktivitas
CNI_USER_LOG Baru
user
30. CNI_VIDEO Tabel ini digunakan untuk menyimpan data file video
31. Tabel ini digunakan untuk menyimpan data pengunjung
CNI_VISITORS Baru
website
Table 2. List of Tables

4.2.1 MySql Table Structure

4.2.1.1 CNI_AGENDA
No Field Name Field Type
1. AGENDA_ID INT(11)
2. EVENT VARCHAR(255)
3. EVENT_EN VARCHAR(255)
4. CONTENT TEXT

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 12
Document No.: DPPM - TDD

No Field Name Field Type

5. CONTENT_IN TEXT
6. CONTENT_EN TEXT
7. START_DATE DATETIME
8. END_DATE DATETIME
9. PLACE VARCHAR(150)
10. ADDRESS VARCHAR(255)
11. IMAGE VARCHAR(100)
12. TYPE ENUM('UMUM', 'INTERNAL')
13. PIC VARCHAR(255)
14. BIDANG VARCHAR(255)
15. KATEGORI_KEGIATAN VARCHAR(255)
16. JAM TIME
17. STATUS TINYINT(1)
Table 3. Structure Table of CNI_AGENDA
4.2.1.2 CNI_BANNER
No Field Name Field Type
1. BANNER_ID INT(10)
2. BANNER_TITLE VARCHAR(100)
3. BANNER_LINK VARCHAR(255)
4. BANNER_IMAGE VARCHAR(100)
5. BANNER_ORDER TINYINT(3)
ENUM('TOP', 'LEFT', 'BOTTOM', 'RIGHT',
6. BANNER_POSITION
'POPUP')
7. PUBLISH TINYINT(1)
Table 4. Structure Table of CNI_BANNER

4.2.1.3 CNI_BLOCKS
No Field Name Field Type
1. BLOCK_ID INT(10)
2. BLOCK_THEME VARCHAR(25)
3. BLOCK_NAME VARCHAR(50)
4. BLOCK_TITLE VARCHAR(50)
5. BLOCK_TITLE_IN VARCHAR(50)
6. BLOCK_TITLE_EN VARCHAR(50)
7. BLOCK_TITLE_SHOW TINYINT(1)
8. BLOCK_POSITION VARCHAR(10)
9. BLOCK_ORDER TINYINT(3)
10. BLOCK_PAGE ENUM('HOME', 'HIDEHOME', 'ALL')
11. BLOCK_PARAMS TEXT

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 13
Document No.: DPPM - TDD

No Field Name Field Type

12. ACTIVE TINYINT(1)
Table 5. Structure Table of CNI_BLOCKS

4.2.1.4 CNI_COMMENTS
No Field Name Field Type
1. COMMENT_ID INT(11)

2. COMMENT_POST
INT(11)

3. COMMENT_PARENT
INT(11)
4. COMMENT_FROM VARCHAR(20)
5. COMMENT_EMAIL VARCHAR(50)
6. COMMENT_CONTENT MEDIUMTEXT
7. COMMENT_DATE DATETIME
8. PUBLISH TINYINT
Table 6. Structure Table of CNI_COMMENTS

4.2.1.5 CNI_CONFIG
No Field Name Field Type
1. ID INT(1)
2. SITE_THEME VARCHAR(100)
3. SITE_TITLE VARCHAR(255)
4. SITE_TAGLINE VARCHAR(255)
5. SITE_DESCRIPTION VARCHAR(255)
6. SITE_DESCRIPTION_EN VARCHAR(255)
7. SITE_DESCRIPTION_IN VARCHAR(255)
8. SITE_KEYWORD TEXT
9. SITE_KEYWORD_EN TEXT
10. SITE_KEYWORD_IN TEXT
11. SITE_WELCOME TEXT
12. DEFAULT_IMG VARCHAR(50)
13. COMPANY_NAME VARCHAR(255)
14. COMPANY_ADDRESS TEXT
15. COMPANY_PHONE VARCHAR(255)
16. COMPANY_MOBILE VARCHAR(255)
17. COMPANY_FAX VARCHAR(255)
18. COMPANY_LOGO VARCHAR(255)
19. COMPANY_LOGO_FOOTER VARCHAR(100)
20. SITE_FOOTER TEXT

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 14
Document No.: DPPM - TDD

No Field Name Field Type

21. SOCILA_MEDIA MEDIUMTEXT
22. EMAIL_ACCOUNT VARCHAR(255)
23. ALTERNATE_EMAIL VARCHAR(255)
24. LANG MEDIUMTEXT
25. FAVICON VARCHAR(50)
26. MENU_POSITION MEDIUMTEXT
27. MENU_PUBLIC TINYTEXT
28. MENU_ADMIN TINYTEXT
29. WATERMARK VARCHAR(50)
30. THUMBNAIL VARCHAR(255)
31. OUTKEY VARCHAR(255)
32. SECRETKEY VARCHAR(255)
Table 7. Structure Table of CNI_CONFIG

4.2.1.6 CNI_CONTACT
No Field Name Field Type
1. CONTACT_ID INT(11)
2. CONTACT_NAME VARCHAR(255)
3. CONTACT_EMAIL VARCHAR(255)
4. CONTACT_PHONE VARCHAR(255)
5. CONTACT_COMPANY VARCHAR(255)
6. CONTACT_ADDRESS VARCHAR(255)
7. CONTACT_CITY VARCHAR(255)
8. CONTACT_PROVINCE VARCHAR(255)
9. CONTACT_COUNTRY VARCHAR(255)
10. CONTACT_ZIP VARCHAR(255)
11. CONTACT_HANDPHONE VARCHAR(255)
12. CONTACT_FAX VARCHAR(255)
13. CONTACT_MESSAGE TEXT
14. CONTACT_MESSAGE_EN TEXT
15. CONTACT_MESSAGE_IN TEXT
16. CONTACT_PHOTO VARCHAR(255)
17. CONTACT_POSITION VARCHAR(20)
18. CONTACT_REPLY_MSG VARCHAR(255)
19. CONTACT_REPLY TINYINT(1)
20. CONTACT_DATE DATETIME
21. CONTACT_TYPE ENUM('CONTACT', 'GUESTBOOK', 'TESTIMONIAL')
22. APPROVE TINYINT(1)
23. CONTACT_IP CHAR(20)

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 15
Document No.: DPPM - TDD

Table 8. Structure Table of CNI_CONTACT

4.2.1.7 CNI_DOWNLOAD
No Field Name Field Type
1. FILE_ID INT(11)
2. FILE_NAME VARCHAR(255)
3. FILE_LABEL VARCHAR(50)
4. FILE_DESCRIPTION VARCHAR(255)
5. DATE_UPLOAD DATE
ENUM('INFO_GRAFIS',
6. TYPE 'DOWNLOAD',
'STATISTIK', 'PELU...
7. PUBLISH TINYINT(1)
8. TAHUN VARCHAR(4)
Table 9. Structure Table of CNI_DOWNLOAD

4.2.1.8 CNI_ EMAIL_TEMPLATE

No Field Name Field Type
1. EMAIL_ID INT(11)
2. EMAIL_NAME VARCHAR(255)
3. EMAIL_SUBJECT VARCHAR(255)
4. EMAIL_CC VARCHAR(100)
5. EMAIL_BCC VARCHAR(100)
6. EMAIL_CONTENT TEXT
7. EMAIL_FROM VARCHAR(255)
8. EMAIL_FROM_NAME VARCHAR(255)
9. EMAIL_DESCRIPTION VARCHAR(255)
Table 10. Structure Table of CNI_EMAIL_TEMPLATE

4.2.1.9 CNI_ GALLERY_IMAGE

No Field Name Field Type
1. GALLERY_ID INT(11)
2. ALBUM_ID INT(11)
3. TITLE VARCHAR(100)
4. DESCRIPTION VARCHAR(700)
5. IMAGE VARCHAR(100)
6. PHOTOGRAPHER VARCHAR(100)
7. AUTHOR VARCHAR(50)
8. UPLOAD_ON DATETIME
9. UPLOAD_BY DATETIME

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 16
Document No.: DPPM - TDD

No Field Name Field Type

10. PUBLISH TINYINT(1)
Table 11. Structure Table of CNI_GALLERY_IMAGE

4.2.1.10 CNI_LANDING

No Field Name Field Type

1. SLIDER_ID INT(3)
ENUM('IMAGE',
2. SLIDER_TYPE
'VIDEO')
3. IMAGE VARCHAR(100)
4. PUBLISH TINYINT(1)
5. SLIDER_YOUTUBE_ID VARCHAR(255)
Table 12. Structure Table of CNI_LANDING

4.2.1.11 CNI_LINKS

No Field Name Field Type

1. LINK_ID INT(10)
2. LINK_TITLE VARCHAR(100)
3. LINK_DESCRIPTION VARCHAR(255)
4. LINK_URL VARCHAR(255)
5. LINK_IMAGE VARCHAR(50)
6. LINK_ICON VARCHAR(20)
7. LINK_ORDER TINYINT(3)
ENUM('LINK',
8. LINK_TYPE
'SERVICE')
9. PUBLISH TINYINT(1)
Table 13. Structure Table of CNI_LINKS

4.2.1.12 CNI_MENU

No Field Name Field Type

1. MENU_ID INT(10)
2. PARENT_ID INT(10)
3. PAGE_ID INT(10)
4. ADMIN_MENU TINYINT(1)
5. POSITION MEDIUMTEXT
6. ICON VARCHAR(50)
7. CUSTOM_LINKS TINYINT(1)
8. CUSTOM_TITLE VARCHAR(50)
9. CUSTOM_URL VARCHAR(100)
10. MENU_ORDER INT(3)

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 17
Document No.: DPPM - TDD

No Field Name Field Type

11. PUBLISH TINYINT(1)
Table 14. Structure Table of CNI_MENU
4.2.1.13 CNI_MODULES

No Field Name Field Type

1. MODULE_ID TINYINT(3)
2. MODULE_NAME VARCHAR(30)
3. STATUS TINYINT(1)
Table 15. Structure Table of CNI_MODULES
4.2.1.14 CNI_MEMBER

No Field Name Field Type

1. MEMBER_ID INT
2. FNAMA VARCHAR
3. TANGGAL DATETIME
4. APPROVE TINYINT
5. PASS TEXT
6. AUTH VARCHAR
7. IMAGE VARCHAR
8. MAILSENT TINYINT
Table 16. Structure Table of CNI_NO_COUNTRY
4.2.1.15 CNI_MENU

No Field Name Field Type

1. MANU_ID INT
2. PARENT_ID INT
3. PAGE_ID INT
4. ADMIN_MENU TINYINT
5. POSITION MEDIUMTEXT
6. ICON VARCHAR
7. CUSTOM_LINKS TINYINT
8. CUSTOME_TITLE VARCHAR
9. CUSTOME_URL VARCHAR
10. MENNU_ORDER TINYINT
11. PUBLISH TINYINT
Table 17. Structure Table of CNI_MENU
4.2.1.16 CNI_MODULES

No Field Name Field Type

1. MODULE_ID TINYINT

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 18
Document No.: DPPM - TDD

No Field Name Field Type

2. MODULE_NAME VARCHAR
3. STATUS TINYINT
Table 18. Structure Table of CNI_MODULES

4.2.1.17 CNI_NO_COUNTRY

No Field Name Field Type

1. ID INT(11)
2. ISO CHAR(2)
3. NAME VARCHAR(80)
4. NICENAME VARCHAR(80)
5. ISO3 CHAR(3)
6. NUMCODE SMALLINT(6)
7. PHONECODE INT(5)
Table 19. Structure Table of CNI_O_COUNTRY

4.2.1.18 CNI_PAGES

No Field Name Field Type

1. PAGE_ID INT(10)
2. PARENT_ID INT(10)
3. MODULE_ID INT(10)
4. CONTENT_ID INT(10)
5. CATEGORY_ID TINYINT(3)
6. PERIZINAN_ID INT(11)
7. PAGE_NAME VARCHAR(255)
8. PAGE_NAME_EN VARCHAR(255)
9. PAGE_NAME_IN VARCHAR(255)
10. PAGE_TAGLINE VARCHAR(255)
11. PAGE_TAGLINE_EN VARCHAR(255)
12. PAGE_TAGLINE_IN VARCHAR(255)
13. PAGE_SWITCH VARCHAR(50)
14. PAGE_URL VARCHAR(255)
15. PAGE_URL_EN VARCHAR(255)
16. PAGE_URL_IN VARCHAR(255)
17. ADMIN_ONLY TINYINT(1)
18. PUBLISH TINYINT(1)
Table 20. Structure Table of CNI_PAGES

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 19
Document No.: DPPM - TDD

4.2.1.19 CNI_PAGES_CONTENT

No Field Name Field Type

1. CONTENT_ID INT(11)
2. CONTENT_TITLE VARCHAR(255)
3. CONTENT_TITLE_EN VARCHAR(255)
4. CONTENT_TITLE_IN VARCHAR(255)
5. CONTENT_TAGLINE VARCHAR(255)
6. CONTENT_TAGLINE_EN VARCHAR(255)
7. CONTENT_TAGLINE_IN VARCHAR(255)
8. CONTENT_DESCRIPTION TINYTEXT
9. CONTENT_DESCRIPTION_EN TINYTEXT
10. CONTENT_DESCRIPTION_IN TINYTEXT
11. CONTENT_TEXT TEXT
12. CONTENT_TEXT_IN TEXT
13. CONTENT_TEXT_EN TEXT
14. CONTENT_TAG TINYTEXT
15. CONTENT_TAG_EN TINYTEXT
16. CONTENT_TAG_IN TINYTEXT
17. CONTENT_IMAGE VARCHAR(255)
18. CONTENT_AUTHOR VARCHAR(100)
19. CONTENT_RATING TINYINT(5)
20. CREATED_DATE DATETIME
21. UPDATED_DATE DATETIME
22. PUBLISH TINYINT(1)

Table 21. Structure Table of CNI_PAGES_CONTENT

4.2.1.20 CNI_PARAMS

No Field Name Field Type

1. PARAMS_ID INT(1)
2. CONTENT MEDIUMTEXT
3. CONTACT MEDIUMTEXT
4. GUESTBOOK MEDIUMTEXT
5. TESTIMONIAL MEDIUMTEXT
6. RUNNING_TEXT VARCHAR(255)
7. LANGTABLE TEXT

Table 22. Structure Table of CNI_PARAMS

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 20
Document No.: DPPM - TDD

4.2.1.21 CNI_PERIZINAN

No Field Name Field Type

1. PERIZINAN_ID INT(11)
2. CATEGORY_ID INT(11)
3. SUBCATEGORY_ID INT(11)
4. TITLE VARCHAR(255)
5. TAGLINE TEXT
6. DISKRIPSI TEXT
7. DASAR_HUKUM TEXT
8. PERSYARATAN TEXT
9. PROSEDUR TEXT
10. DOWNLOAD TEXT
11. BIAYA TEXT
12. PERIZINAN_URL TEXT
13. PUBLISH TINYINT(1)

Table 23. Structure Table of CNI_PERIZINAN

4.2.1.22 CNI_PHONEBOOK

No Field Name Field Type

1. PHONEBOOK_ID INT(11)
2. NAME VARCHAR(50)
3. PHONE VARCHAR(16)
4. CATEGORY_ID INT(11)

Table 24. Structure Table of CNI_PHONEBOOK

4.2.1.23 CNI_POSTS

No Field Name Field Type

1. POST_ID INT(11)
2. POST_CATEGORY TINYTEXT
3. POST_TITLE VARCHAR(255)
4. POST_TAGLINE VARCHAR(255)
5. POST_DESCRIPTION MEDIUMTEXT
6. POST_CONTENT TEXT
7. POST_TAG TINYTEXT
8. POST_IMAGE VARCHAR(255)
9. POSTS_AUTHOR VARCHAR(100)
10. POST_HITS INT(10)
11. POST_RATING TINYINT(5)

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 21
Document No.: DPPM - TDD

No Field Name Field Type

ENUM('POST',
12. POST_TYPE
'PROJECT')
13. CREATED_DATE DATETIME
14. PUBLISHED_DATE DATETIME
15. PUBLISH TINYINT(1)
16. FILE_DOWNLOAD VARCHAR(255)
17. POST_GALERI1 VARCHAR(255)
18. POST_GALERI2 VARCHAR(255)
19. POST_GALERI3 VARCHAR(255)
20. POST_GALERI4 VARCHAR(255)
21. POST_GALERI5 VARCHAR(255)
22. POST_GALERI6 VARCHAR(255)
23. POST_GALERI7 VARCHAR(255)
24. POST_GALERI8 VARCHAR(255)

Table 25. Structure Table of CNI_POSTS

4.2.1.24 CNI_RUNNING_TEXT

No Field Name Field Type

1. RUNNING_ID INT(10)
2. RUNNING_TEXT VARCHAR(255)
3. RUNNING_ORDER INT(5)
4. RUNNING_URL VARCHAR(255)
5. PUBLISH TINYINT(1)

Table 26. Structure Table of CNI_RUNNING_TEXT

4.2.1.25 CNI_SLIDER

No Field Name Field Type

1. SLIDER_ID INT(3)
2. TITLE VARCHAR(100)
3. TAGLINE VARCHAR(100)
4. DESCRIPTION VARCHAR(255)
5. IMAGE VARCHAR(100)
6. BTN_CAPTION VARCHAR(100)
7. URL VARCHAR(255)
8. SLIDER_ORDER TINYINT(3)
ENUM('IMAGE',
9. SLIDER_TYPE
'VIDEO')
10. PUBLISH TINYINT(1)

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 22
Document No.: DPPM - TDD

No Field Name Field Type

11. SLIDER_YOUTUBE_ID VARCHAR(100)

Table 27. Structure Table of CNI_SLIDER

4.2.1.26 CNI_STATISTIK

No Field Name Field Type

1. ID INT(11)
2. TANGGAL DATETIME
3. SUKSES INT(11)
4. SERVER VARCHAR(255)
5. GAGAL INT(10)
6. USER INT(11)

Table 28. Structure Table of CNI_STTAISTIK

4.2.1.27 CNI_TEAM

No Field Name Field Type

1. TEAM_ID INT(12)
2. TEAM_NAME VARCHAR(255)
3. TEAM_NICKNAME VARCHAR(255)
4. TEAM_BORN DATE
5. TEAM_POSITION VARCHAR(255)
6. TEAM_MOTTO VARCHAR(255)
7. TEAM_IMAGE VARCHAR(255)
8. TEAM_ORDER TINYINT(3)
9. TEAM_SOSMED TEXT
10. PUBLISH TINYINT(3)

Table 29. Structure Table of CNI_TEAM

4.2.1.28 CNI_TRACEY

No Field Name Field Type

1. ID_TRACEY INT(11)
2. ID_IDEN INT(11)
3. JWBN_SER MEDIUMTEXT

Table 30. Structure Table of CNI_TRACEY

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 23
Document No.: DPPM - TDD

4.2.1.29 CNI_USER

No Field Name Field Type

1. ID TINYINT(3)
2. GROUP_ID TINYINT(3)
3. NAME VARCHAR(100)
4. USERNAME VARCHAR(50)
5. PASS VARCHAR(255)
6. EMAIL VARCHAR(50)
7. IMAGE VARCHAR(50)
8. ACTIVE VARCHAR(255)
9. AUTHSESSION VARCHAR(50)
10. LASTLOGIN DATETIME
11. LASTLOGINFROM CHAR(20)
12. AUTH_PASS VARCHAR(8)

Table 31. Structure Table of CNI_USER

4.2.1.30 CNI_USER_GROUP

No Field Name Field Type

1. GROUP_ID INT(11)
2. NAME VARCHAR(100)
3. ACCESS LONGTEXT

Table 32. Structure Table of CNI_USER_GROUP

4.2.1.31 CNI_USER_LOG

No Field Name Field Type

1. LOG_ID INT(10)
2. LOG_DATE DATETIME
3. USER_ID TINYINT(3)
4. QUERY TEXT
5. ACTIVITY TINYTEXT
6. ACEESS_PAGE VARCHAR(255)
7. ACCESSIP CHAR(20)

Table 33. Structure Table of CNI_USER_LOG

Table 34.

4.2.1.32 CNI_VIDEO

No Field Name Field Type

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 24
Document No.: DPPM - TDD

No Field Name Field Type

1. VIDEO_ID INT(10)
2. VIDEO_TITLE VARCHAR(250)
3. VIDEO_DESCRIPTION TEXT
4. YOUTUBE_ID VARCHAR(50)
5. PUBLISH TINYINT(1)
6. CREATED_DATE DATETIME

Table 35. Structure Table of CNI_VIDEO

4.2.1.33 CNI_VISITOR

No Field Name Field Type

1. ID INT(11)
2. VISITOR_IP VARCHAR(256)
3. VISITOR_CITY VARCHAR(64)
4. VISITOR_STATE VARCHAR(64)
5. VISITOR_COUNTRY VARCHAR(64)
15. VISITOR_FLAG VARCHAR(256)
7. VISITOR_BROWSER VARCHAR(64)
8. VISITOR_OS VARCHAR(64)
9. VISITOR_DATE TIMESTAMP
10. VISITOR_DAY TINYINT(2)
11. VISITOR_MONTH TINYINT(2)
12. VISITOR_YEAR INT(4)
13. VISITOR_HOUR TINYINT(2)
14. VISITOR_MINUTE TINYINT(2)
15. VISITOR_SECONDS TINYINT(2)
16. VISITOR_REFERER VARCHAR(256)
17. VISITOR_PAGE VARCHAR(256)

Table 36. Structure Table of CNI_VISITORS

Table 37.

4.3 Format Data Output

Tidak tersedia

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 25
Document No.: DPPM - TDD

5 TECHNICAL DETAIL
5.1 Use Case Diagram

Figure 3. Use Case Diagram Website DPPM

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 26
Document No.: DPPM - TDD

5.2 Global Process

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 27
Document No.: DPPM - TDD

5.3 FLOW PROCESS

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 28
Document No.: DPPM - TDD
%3 D% 22 ge om et ry %2 2% 2F %3 E% 3C %2 Fm xC el l% 3E %3 Cm xC el l% 20 id %3 D% 22 73 %2 2% 20 va lu e% 3D %2 2T b% 20 Do wn lo ad %2 2% 20 st yl e% 3D %2 2s ha pe %3 Dp ar ti al Re ct an gl e% 3B wh it eS pa ce %3 Dw ra p% 3B ht ml %3 D1 %3 Bl ef t% 3D 0% 3B ri gh t% 3D 0% 3B fi ll Co lo r% 3D no ne %3 B% 22 %2 0v er te x% 3D %2 21 %2 2% 20 pa re nt %3 D% 22 1% 22 %3 E% 3C mx Ge om et ry %2 0x %3 D% 22 83 0% 22 %2 0y %3 D% 22 -
52 .5 %2 2% 20 wi dt h% 3D %2 21 20 %2 2% 20 he ig ht %3 D% 22 45 %2 2% 20 as %3 D% 22 ge om et ry %2 2% 2F %3 E% 3C %2 Fm xC el l% 3E %3 Cm xC el l% 20 id %3 D% 22 74 %2 2% 20 va lu e% 3D %2 2T b% 20 Ag em da %2 2% 20 st yl e% 3D %2 2s ha pe %3 Dp ar ti al Re ct an gl e% 3B wh it eS pa ce %3 Dw ra p% 3B ht ml %3 D1 %3 Bl ef t% 3D 0% 3B ri gh t% 3D 0% 3B fi ll Co lo r% 3D no ne %3 B% 22 %2 0v er te x% 3D %2 21 %2 2% 20 pa re nt %3 D% 22 1% 22 %3 E% 3C mx Ge om et ry %2 0x %3 D% 22 83 0% 22 %2 0y %3 D% 22 3% 22 %2 0w id th %3 D% 22 12 0% 22 %2 0h ei gh t% 3D %2 24 5% 22 %2 0a s% 3D %2 2g eo me tr y% 22 %2 F %3 E% 3C %2 Fm xC el l% 3E %3 Cm xC el l% 20 id %3 D% 22 75 %2 2% 20 va lu e% 3D %2 2T b% 20 Ko nt ak %2 2% 20 st yl e% 3D %2 2s ha pe %3 Dp ar ti al Re ct an gl e% 3B wh it eS pa ce %3 Dw ra p% 3B ht ml %3 D1 %3 Bl ef t% 3D 0% 3B ri gh t% 3D 0% 3B fi ll Co lo r% 3D no ne %3 B% 22 %2 0v er te x% 3D %2 21 %2 2% 20 pa re nt %3 D% 22 1% 22 %3 E% 3C mx Ge om et ry %2 0x %3 D% 22 83 0% 22 %2 0y %3 D% 22 56 %2 2% 20 wi dt h% 3D %2 21 20 %2 2% 20 he ig ht %3 D% 22 45 %2 2
%2 0a s% 3D %2 2g eo me tr y% 22 %2 F% 3E %3 C% 2F mx Ce ll %3 E% 3C mx Ce ll %2 0i d% 3D %2 27 6% 22 %2 0v al ue %3 D% 22 Tb %2 0S ta ti st ik %2 2% 20 st yl e% 3D %2 2s ha pe %3 Dp ar ti al Re ct an gl e% 3B wh it eS pa ce %3 Dw ra p% 3B ht ml %3 D1 %3 Bl ef t% 3D 0% 3B ri gh t% 3D 0% 3B fi ll Co lo r% 3D no ne %3 B% 22 %2 0v er te x% 3D %2 21 %2 2% 20 pa re nt %3 D% 22 1% 22 %3 E% 3C mx Ge om et ry %2 0x %3 D% 22 83 0% 22 %2 0y %3 D% 22 10 9. 5% 22 %2 0w id th %3 D% 22 12 0% 22 %2 0h ei gh t% 3D %2 24 5% 22 %2 0a s% 3D %2 2g eo me tr y% 22 %2 F% 3E %3 C% 2F mx Ce ll %3 E% 3C mx Ce ll %2 0i d% 3D %2 27 7 %2 2% 20 va lu e% 3D %2 2T b% 20 Me nu %2 2% 20 st yl e% 3D %2 2s ha pe %3 Dp ar ti al Re ct an gl e% 3B wh it eS pa ce %3 Dw ra p% 3B ht ml %3 D1 %3 Bl ef t% 3D 0% 3B ri gh t% 3D 0% 3B fi ll Co lo r% 3D no ne %3 B% 22 %2 0v er te x% 3D %2 21 %2 2% 20 pa re nt %3 D% 22 1% 22 %3 E% 3C mx Ge om et ry %2 0x %3 D% 22 83 0% 22 %2 0y %3 D% 22 15 7% 22 %2 0w id th %3 D% 22 12 0% 22 %2 0h ei gh t% 3D %2 24 5% 22 %2 0a s% 3D %2 2g eo me tr y% 22 %2 F% 3E %3 C% 2F mx Ce ll %
3E %3 Cm xC el l% 20 id %3 D% 22 78 %2 2% 20 st yl e% 3D %2 2e dg eS ty le %3 Do rt ho go na lE dg eS ty le %3 Br ou nd ed %3 D0 %3 Bo rt ho go na lL oo p% 3D 1% 3B je tt yS iz e% 3D au to %3 Bh tm l% 3D 1% 3B ex it X% 3D 1% 3B ex it Y% 3D 0. 5% 3B ex it Dx %3 D0 %3 Be xi tD y% 3D 0% 3B en tr yX %3 D0 %3 Be nt ry Y% 3D 0. 5% 3B en tr yD x% 3D 0% 3B en tr yD y% 3D 0% 3B %2 2% 20 ed ge %3 D% 22 1% 22 %2 0s ou rc e% 3D %2 27 9% 22 %2 0t ar ge t% 3D %2 27 7% 22 %2 0p ar en t% 3D %2 21 %2 2% 3E %3 Cm xG eo me tr y% 20 re la ti ve %3 D% 22 1% 22 %2 0a s% 3D %2 2g eo me tr y% 22 %2 F% 3E %3 C% 2F mx Ce ll %3 E% 3 Cm xC el l% 20 id %3 D% 22 79 %2 2% 20 va lu e% 3D %2 21 7. 0% 26 lt %3 Bb r% 26 gt %3 BM an ag e% 20 Da ta %2 0M en u% 22 %2 0s ty le %3 D% 22 el li ps e% 3B wh it eS pa ce %3 Dw ra p% 3B ht ml %3 D1 %3 Ba sp ec t% 3D fi xe d% 3B %2 2% 20 ve rt ex %3 D% 22 1% 22 %2 0p ar en t% 3D %2 21 %2 2% 3E %3 Cm xG eo me tr y% 20 x% 3D %2 23 93 %2 2% 20 y% 3D %2 21 40 %2 2% 20 wi dt h% 3D %2 28 0% 22 %2 0h ei gh t% 3D %2 28 0% 22 %2 0a s% 3D %2 2g eo me tr y% 22 %2 F% 3E %3 C
%2 Fm xC el l% 3E %3 C% 2F ro ot %3 E% 3C %2 Fm xG ra ph Mo d

5.4 Class Diagram

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 29
Document No.: DPPM - TDD

TECHNICAL DATA Page

DPPM V1.0
DOCUMENT 30