Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: arsip_surat
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
arsip_surat.tbl_bidang
arsip_surat.tbl_fa
arsip_surat.tbl_nav
arsip_surat.tbl_online
arsip_surat.tbl_permissions
arsip_surat.tbl_privilages
arsip_surat.tbl_scan_sulur
arsip_surat.tbl_scan_suma
arsip_surat.tbl_suma
arsip_surat.tbl_surat_keluar
arsip_surat.tbl_user
arsip_surat.tbl_user_desc
arsip_surat.tbl_user_log
Number of tables: 13
v arsip_surat tbl_bidang
* id_bidang : int
* nama_bidang : varchar(128)
v arsip_surat tbl_fa
* id_font : int
* font : varchar(32)
v arsip_surat tbl_nav
* id_nav : int
* desc_nav : varchar(32)
* fa : varchar(32)
v arsip_surat tbl_online
* id_user : char(36)
* session : char(36)
* date_time : datetime
v arsip_surat tbl_permissions
* id_permissions : int
* priv_permissions : int
* nav_permissions : int
* create_permissions : char(1)
* read_permissions : char(1)
* update_permissions : char(1)
* delete_permissions : char(1)
v arsip_surat tbl_privilages
* id_priv : int
* desc_priv : varchar(32)
* desc_priv_more : varchar(64)
v arsip_surat tbl_scan_sulur
* id : bigint
* id_sulur : int
* path : varchar(256)
* tgl : timestamp
* deskripsi : varchar(128)
v arsip_surat tbl_scan_suma
* id : bigint
* id_suma : int
* path : varchar(256)
* tgl : timestamp
* deskripsi : varchar(128)
v arsip_surat tbl_suma
* id_suma : bigint unsigned
* no_suma : char(128)
* pengirim_suma : varchar(256)
* perihal_suma : varchar(256)
* diterima_suma : date
* tgl_entri_suma : timestamp
* disposisi : text
* bidang : int
* tgl_suma : date
v arsip_surat tbl_surat_keluar
* id_sulur : bigint unsigned
* nomer_sulur : int
* kode_sulur : char(32)
* kepada_sulur : varchar(256)
* perihal_sulur : varchar(256)
* tanggal_sulur : date
* pengolah_sulur : int
* tgl_entri_sulur : timestamp
v arsip_surat tbl_user
* id_user : char(36)
* username : varchar(32)
* password : varchar(255)
* privilages_user : int
* create_at : datetime
* flag : char(2)
v arsip_surat tbl_user_desc
* id_user : char(36)
* user_fullname : varchar(64)
* user_email : varchar(64)
* user_address : text
* photo : varchar(255)
v arsip_surat tbl_user_log
* number : int
* id_user : char(36)
* date_and_time : datetime
* user_agents : varchar(255)
* ip_address : int
* log : varchar(64)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship