https://alatberatbekasjepang.com/ https://cms.uki.ac.id/pict/spulsa/ https://pmb.takumi.ac.id/file/ https://siparaf.beraukab.go.id/asset/ http://esppd.niasbaratkab.go.id/lib/ygacor/ https://simata.bulelengkab.go.id/application/app/ https://siadik.disdik.jambiprov.go.id/assets/ https://stdb-disbun.kutaitimurkab.go.id/storage/2024/ https://orientasionline.usk.ac.id/osimpus/application/libraries/dompdf_qindsaof/vendor/assets/ https://data.dinaspupr.kalselprov.go.id/lib/
Skema Database

Skema Database

PopojiCMS - CMS Indonesia, Buat Sendiri Rasa Webmu, Karena Kami CMS Gratis Indonesia.

album

Column Type Null Default Comments
id_album int(5) No    
title varchar(255) No    
seotitle varchar(255) No    
active enum('Y', 'N') No Y  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_album 0 A No  

category

Column Type Null Default Comments
id_category int(5) No    
id_parent int(5) No 0  
seotitle varchar(255) No    
picture varchar(255) No    
active enum('Y', 'N') No Y  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_category 3 A No  

category_description

Column Type Null Default Comments
id_category_description int(5) No    
id_category int(5) No    
id_language int(5) No 1  
title varchar(255) No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_category_description 8 A No  

comment

Column Type Null Default Comments
id_comment int(5) No    
id_parent int(5) No 0  
id_post int(5) No    
name varchar(100) No    
email varchar(100) No    
url varchar(255) No    
comment text No    
date date No    
time time No    
active enum('Y', 'N') No N  
status enum('Y', 'N') No N  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_comment 2 A No  

component

Column Type Null Default Comments
id_component int(5) No    
component varchar(100) No    
type enum('component', 'widget') No component  
datetime datetime No    
active enum('Y', 'N') No Y  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_component 2 A No  

contact

Column Type Null Default Comments
id_contact int(5) No    
name varchar(100) No    
email varchar(100) No    
subject varchar(255) No    
message text No    
status enum('Y', 'N') No N  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_contact 0 A No  

gallery

Column Type Null Default Comments
id_gallery int(5) No    
id_album int(5) No    
title varchar(255) No    
content text No    
picture varchar(255) No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_gallery 0 A No  

language

Column Type Null Default Comments
id_language int(5) No    
title varchar(50) No    
code varchar(3) No    
active enum('Y', 'N') No Y  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_language 2 A No  

menu

Column Type Null Default Comments
id tinyint(3) No    
parent_id tinyint(3) No 0  
title varchar(255) No    
url varchar(255) No    
class varchar(255) No    
position tinyint(3) No 0  
group_id tinyint(3) No 1  
active enum('Y', 'N') No Y  
target varchar(10) No none  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 61 A No  

menu_group

Column Type Null Default Comments
id smallint(5) No    
title varchar(255) No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 3 A No  

oauth

Column Type Null Default Comments
id_oauth int(5) No    
oauth_type varchar(10) No    
oauth_key text No    
oauth_secret text No    
oauth_id varchar(100) No    
oauth_user varchar(100) No    
oauth_token1 text No    
oauth_token2 text No    
oauth_fbtype varchar(10) No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_oauth 2 A No  

pages

Column Type Null Default Comments
id_pages int(5) No    
seotitle varchar(255) No    
picture varchar(255) No    
active enum('Y', 'N') No Y  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_pages 19 A No  

pages_description

Column Type Null Default Comments
id_pages_description int(5) No    
id_pages int(5) No    
id_language int(5) No 1  
title varchar(255) No    
content text No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_pages_description 38 A No  

post

Column Type Null Default Comments
id_post int(5) No    
seotitle varchar(255) No    
tag text No    
date date No    
time time No    
publishdate datetime No    
editor int(5) No 1  
active enum('Y', 'N') No Y  
headline enum('Y', 'N') No N  
comment enum('Y', 'N') No Y  
picture varchar(255) No    
picture_description varchar(255) No    
hits int(10) No 1  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_post 11 A No  

post_category

Column Type Null Default Comments
id_post_category int(5) No    
id_post int(5) No    
id_category int(5) No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_post_category 15 A No  

post_description

Column Type Null Default Comments
id_post_description int(5) No    
id_post int(5) No    
id_language int(5) No 1  
title varchar(255) No    
content text No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_post_description 26 A No  

post_gallery

Column Type Null Default Comments
id_post_gallery int(5) No    
id_post int(5) No 0  
picture varchar(255) No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_post_gallery 4 A No  

setting

Column Type Null Default Comments
id_setting int(5) No    
groups varchar(50) No    
options varchar(100) No    
value text No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_setting 28 A No  

subscribe

Column Type Null Default Comments
id_subscribe int(5) No    
email varchar(100) No    
name varchar(255) No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_subscribe 0 A No  

tag

Column Type Null Default Comments
id_tag int(5) No    
title varchar(100) No    
tag_seo varchar(100) No    
count int(5) No    

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_tag 18 A No  

theme

Column Type Null Default Comments
id_theme int(5) No    
title varchar(50) No    
author varchar(50) No    
folder varchar(20) No    
active enum('Y', 'N') No N  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_theme 2 A No  

traffic

Column Type Null Default Comments
ip varchar(20) No    
browser varchar(255) No    
os varchar(255) No    
platform varchar(255) No    
date date No    
hits int(10) No 1  
online varchar(255) No    

user_level

Column Type Null Default Comments
id_level int(5) No    
level varchar(255) No    
title varchar(255) No    
role text No    
menu int(5) No 1  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_level 4 A No  

users

Column Type Null Default Comments
id_user int(5) No    
username varchar(50) No    
password varchar(50) No    
nama_lengkap varchar(255) No    
email varchar(100) No    
no_telp varchar(20) No    
bio text No    
picture varchar(255) No    
level varchar(20) No 2  
block enum('Y', 'N') No N  
id_session varchar(100) No    
tgl_daftar date No    
forget_key varchar(100) Yes NULL  
locktype varchar(1) No 0  

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No username 0 A No