Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling 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
Number of tables: 0
v dbfederation agenda
* id : int(11)
* org_id : int(11)
* trans_date : datetime
* end_date : datetime
* session_name : varchar(225)
* agenda_name : text
* user_id : int(11)
* stataus : varchar(225)
v dbfederation agenda_attend
* id : int(11)
* agenda_id : int(11)
* user_id : int(11)
* org_id : int(11)
* attend : int(11)
* ts : timestamp
v dbfederation agenda_minutes_agenda
* id : int(11)
* agenda_id : int(11)
* agenda : text
* ts : timestamp
v dbfederation agenda_minutes_attendance
* id : int(11)
* agenda_id : int(11)
* uid : int(11)
* ts : timestamp
v dbfederation agenda_minutes_docs
* id : int(11)
* agenda_id : int(11)
* minutes_id : int(11)
* file_name : varchar(100)
* path_name : varchar(100)
* stat : int(1)
v dbfederation agenda_minutes_main
* id : int(11)
* agenda_id : int(11)
* ref_no : varchar(225)
* trans_date : date
* start : time
* end : time
* held : text
* call_order_uid : int(11)
* invocated_uid : int(11)
* adjourned_uid : int(11)
* status : int(1)
* docs : longtext
v dbfederation agenda_resolution_ord_details
* id : int(11)
* agenda_id : int(11)
* res_id : int(11)
* uid : int(11)
* att : varchar(1)
* sponsor : varchar(1)
* co_sponsor : varchar(1)
* trans_type : varchar(20)
v dbfederation agenda_resolution_ord_docs
* id : int(11)
* agenda_id : int(11)
* file_name : varchar(225)
* path_name : varchar(225)
* trans_type : varchar(20)
v dbfederation agenda_resolution_ord_main
* id : int(11)
* agenda_id : int(11)
* ref_no : varchar(20)
* trans_date : date
* effective_date : date
* approved_date : date
* place_held : varchar(200)
* title : text
* trans_type : varchar(20)
* status : varchar(20)
* docs : longtext
v dbfederation failed_jobs
* id : bigint(20) unsigned
* connection : text
* queue : text
* payload : longtext
* exception : longtext
* failed_at : timestamp
v dbfederation menutes_main
* id : int(11)
* agenda_id : int(11)
v dbfederation migrations
* id : int(10) unsigned
* migration : varchar(255)
* batch : int(11)
v dbfederation model_has_permissions
* permission_id : int(10) unsigned
* model_type : varchar(255)
* model_id : bigint(20) unsigned
v dbfederation model_has_roles
* role_id : int(10) unsigned
* model_type : varchar(255)
* model_id : bigint(20) unsigned
v dbfederation oauth_access_tokens
* id : varchar(100)
* user_id : bigint(20) unsigned
* client_id : bigint(20) unsigned
* name : varchar(255)
* scopes : text
* revoked : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
* expires_at : datetime
v dbfederation oauth_auth_codes
* id : varchar(100)
* user_id : bigint(20) unsigned
* client_id : bigint(20) unsigned
* scopes : text
* revoked : tinyint(1)
* expires_at : datetime
v dbfederation oauth_clients
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* name : varchar(255)
* secret : varchar(100)
* redirect : text
* personal_access_client : tinyint(1)
* password_client : tinyint(1)
* revoked : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v dbfederation oauth_personal_access_clients
* id : bigint(20) unsigned
* client_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v dbfederation oauth_refresh_tokens
* id : varchar(100)
* access_token_id : varchar(100)
* revoked : tinyint(1)
* expires_at : datetime
v dbfederation password_resets
* email : varchar(255)
* token : varchar(255)
* created_at : timestamp
v dbfederation permissions
* id : int(10) unsigned
* name : varchar(255)
* guard_name : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v dbfederation personal_access_tokens
* id : bigint(20) unsigned
* tokenable_type : varchar(255)
* tokenable_id : bigint(20) unsigned
* name : varchar(255)
* token : varchar(64)
* abilities : text
* last_used_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v dbfederation refbrgy
* id : int(11)
* brgyCode : varchar(255)
* brgyDesc : text
* regCode : varchar(255)
* provCode : varchar(255)
* citymunCode : varchar(255)
v dbfederation refcitymun
* id : int(255)
* psgcCode : varchar(255)
* citymunDesc : text
* regDesc : varchar(255)
* provCode : varchar(255)
* citymunCode : varchar(255)
v dbfederation refprovince
* id : int(11)
* psgcCode : varchar(255)
* provDesc : text
* regCode : varchar(255)
* provCode : varchar(255)
v dbfederation refregion
* id : int(11)
* psgcCode : varchar(255)
* regDesc : text
* regCode : varchar(255)
v dbfederation roles
* id : int(10) unsigned
* name : varchar(255)
* guard_name : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v dbfederation role_has_permissions
* permission_id : int(10) unsigned
* role_id : int(10) unsigned
v dbfederation setup
* id : int(11)
* transDate : date
* groupType : varchar(11)
* description : varchar(255)
* remarks : varchar(255)
* transStat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_brgy_setup
* SysPK_Brgy : int(11)
* city_mun_id : int(11)
* brgy_id : int(11)
* brgy_name : varchar(255)
* checker : int(11)
* brgy_code : varchar(155)
* URBAN_RURAL : varchar(55)
* POPULATION : double
* CITY : varchar(155)
* PROVINCE : varchar(155)
* REGION : varchar(155)
* person_code : varchar(20)
* stat : varchar(10)
* brgy_code1 : varchar(55)
v dbfederation tbl_education
* id : int(11)
* education : varchar(155)
* trans_stat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_educ_info
* id : int(11)
* pkID : int(11)
* educ_type : varchar(55)
* school_name : varchar(255)
* school_addr : varchar(255)
* inclusive_yr : varchar(55)
* grad_type : varchar(55)
* honors_received : varchar(255)
* degree_received : varchar(255)
* title_received : varchar(255)
* trans_stat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_graduate
* id : int(11)
* graduate : varchar(155)
* trans_stat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_member_info
* id : int(11)
* trans_no : varchar(55)
* trans_date : date
* pkID : int(11)
* orgID : int(11)
* org_name : varchar(255)
* chapter : varchar(255)
* posID : int(11)
* position : varchar(55)
* year_affiliated : varchar(55)
* memberID : varchar(55)
* sector_id : int(11)
* dateSigned : date
* dateReceived : date
* dateRegistered : date
* trans_stat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_official_info
* id : int(11)
* posID : int(11)
* position : varchar(255)
* orgID : int(11)
* organization : varchar(255)
* pkID : int(11)
* personName : varchar(255)
* termFrom : varchar(55)
* termTo : varchar(55)
* effectivity : date
* trans_stat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_organization_advocacies
* id : int(11)
* org_prof_id : int(11)
* org_adv_dtl_id : int(11)
v dbfederation tbl_organization_advocacies_dtls_setup
* id : int(11)
* main_id : int(11)
* description : varchar(255)
* type : varchar(20)
v dbfederation tbl_organization_advocacies_setup
* id : int(11)
* description : varchar(255)
* type : varchar(20)
v dbfederation tbl_organization_level
* id : int(11)
* org_prof_id : int(11)
* level_setup_id : int(11)
v dbfederation tbl_organization_level_setup
* id : int(11)
* description : varchar(255)
v dbfederation tbl_organization_major_class
* id : int(11)
* org_prof_id : int(11)
* major_class_setup_id : int(11)
v dbfederation tbl_organization_major_class_setup
* id : int(11)
* description : varchar(255)
v dbfederation tbl_organization_profile
* id : int(11)
* organization_name : varchar(255)
* chapter : varchar(255)
* registered_members : varchar(50)
* date_registration : date
* date_estatblished : date
* room_floor : varchar(255)
* block_lot : varchar(255)
* street : varchar(255)
* barangay : varchar(255)
* city_mun_town : varchar(255)
* provice : varchar(255)
* zip_code : varchar(255)
* mobile_no : varchar(255)
* tel_no : varchar(255)
* office_email_add : varchar(255)
* office_mailing_add : varchar(255)
* description_remarks : text
* vision_statement : text
* mission_statement : text
* status : varchar(20)
* save_date : timestamp
v dbfederation tbl_organization_structure
* id : int(11)
* emp_id : int(11)
* brgy_id : int(11)
* postion_id : int(11)
* barangay_name : varchar(200)
* name : varchar(200)
* position : varchar(200)
* priority : int(11)
v dbfederation tbl_organization_sub_class
* id : int(11)
* org_prof_id : int(11)
* sub_class_setup_id : int(11)
v dbfederation tbl_organization_sub_class_setup
* id : int(11)
* description : varchar(255)
v dbfederation tbl_org_info
* id : int(11)
* pkID : int(11)
* orgID : int(11)
* org_name : varchar(255)
* chapter : varchar(255)
* posID : int(11)
* position : varchar(55)
* year_affiliated : varchar(100)
* trans_stat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_other_info
* id : int(11)
* pkID : int(11)
* lastName : varchar(255)
* middleName : varchar(255)
* firstName : varchar(255)
* fullname : varchar(255)
* relation : varchar(255)
* occupation : varchar(255)
* mobileNo : varchar(55)
* trans_stat : varchar(11)
v dbfederation tbl_person_setup
* pkID : int(11)
* user_id : int(11)
* prefix : varchar(55)
* fname : varchar(255)
* mname : varchar(255)
* lname : varchar(255)
* suffix : varchar(55)
* nickname : varchar(255)
* dob : date
* pob : varchar(255)
* gender : varchar(55)
* civilStatus : varchar(55)
* citizenship : varchar(55)
* height : varchar(55)
* weight : varchar(55)
* religion : varchar(55)
* occupation : varchar(155)
* bloodType : varchar(55)
* address1 : varchar(155)
* address2 : varchar(155)
* street : varchar(155)
* barangay_id : varchar(20)
* barangay : varchar(155)
* cityMun_id : varchar(20)
* cityMun : varchar(155)
* province_id : varchar(20)
* province : varchar(155)
* region : varchar(155)
* zipcode : varchar(155)
* address1_ : varchar(155)
* address2_ : varchar(155)
* street_ : varchar(155)
* barangay_id_ : varchar(20)
* barangay_ : varchar(155)
* cityMun_id_ : varchar(20)
* cityMun_ : varchar(155)
* province_id_ : varchar(20)
* province_ : varchar(155)
* region_ : varchar(155)
* zipcode_ : varchar(155)
* telNo : varchar(155)
* cellNo : varchar(155)
* emailAdd : varchar(155)
* facebook : varchar(200)
* twitter : varchar(200)
* instagram : varchar(200)
* trans_stat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_position_info
* id : int(11)
* orgID : int(11)
* posID : int(11)
* pos_count : int(11)
* position : varchar(55)
* remarks : varchar(255)
* effectivity : date
* transStat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation tbl_postion_setup
* id : int(11)
* description : varchar(200)
* remarks : varchar(255)
v dbfederation tbl_relation
* id : int(11)
* relation : varchar(155)
* trans_stat : varchar(11)
* created_at : timestamp
* updated_at : timestamp
v dbfederation users
* id : bigint(20) unsigned
* name : varchar(255)
* email : varchar(255)
* email_verified_at : timestamp
* password : varchar(255)
* verified : tinyint(1)
* Employee_id : int(11)
* remember_token : varchar(100)
* status : varchar(11)
* created_at : timestamp
* updated_at : timestamp
* image_path : varchar(100)
v dbfederation verify_users
* user_id : int(11)
* token : varchar(255)
* created_at : timestamp
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship