PM

Database Diagnostic & Schema Verification

Official Srikrishna Padmashali Parinaya Vedika • Diagnostic Engine v2.4

🟢 MySQL Connected
MySQL Host & Port:
localhost:3306
Database Name:
srimiwin9_smct_db
Database User:
srimiwin9_smct_user
MySQL Tables Status:
17 Tables in MySQL

🛡️ Profiles Table & Schema Diagnostic

Verifies table existence, column schema, and 'Pending' state moderation support.

🟢 Schema 100% Compliant
Table Existence
profiles Table Found
Total profiles: 7
Column: status
Present (Pending/Approved)
Controls public filtering & moderation
Column: verification_status
Present (Pending/Verified)
Controls KYC & trust badges
Profile Moderation Queue Breakdown:
5
Approved & Public
2
Pending Moderation
0
Rejected / Suspended
7
Total in Database
🔍 Inspect All Columns in profiles table (52 columns)
Column Field Type Null Key Default Status
id varchar(64) NO PRI NULL -
user_id varchar(64) NO UNI NULL -
profile_id varchar(32) NO - NULL -
full_name varchar(128) NO - NULL -
gender enum('Male','Female') NO MUL NULL -
dob date NO - NULL -
age int(11) NO - NULL -
height varchar(32) NO - NULL -
weight varchar(32) YES - NULL -
marital_status varchar(64) NO - Never Married -
mother_tongue varchar(64) NO - Telugu -
community varchar(64) NO - Padmashali -
sub_community varchar(64) YES - Padmasali -
gothram varchar(64) NO MUL NULL -
native_place varchar(128) NO - NULL -
current_city varchar(64) NO MUL NULL -
current_state varchar(64) NO - NULL -
current_country varchar(64) NO - India -
education varchar(128) NO - NULL -
education_detail text YES - NULL -
occupation varchar(128) NO - NULL -
company varchar(128) YES - NULL -
annual_income varchar(64) NO - NULL -
work_location varchar(128) NO - NULL -
father_name varchar(128) NO - NULL -
father_occupation varchar(128) NO - NULL -
mother_name varchar(128) NO - NULL -
mother_occupation varchar(128) NO - NULL -
siblings varchar(128) YES - NULL -
family_type varchar(32) YES - Nuclear -
family_values varchar(32) YES - Traditional -
family_location varchar(128) NO - NULL -
family_background text YES - NULL -
rashi varchar(64) YES - NULL -
nakshatra varchar(64) YES - NULL -
pada varchar(32) YES - NULL -
birth_time varchar(32) YES - NULL -
birth_place varchar(64) YES - NULL -
dosham varchar(64) YES - No Dosham -
food_preference varchar(32) NO - Vegetarian -
smoking varchar(32) NO - No -
drinking varchar(32) NO - No -
about_me text NO - NULL -
main_photo text NO - NULL -
additional_photos text YES - NULL -
special_reference_code varchar(64) YES - NULL -
badges text YES - NULL -
custom_field_values text YES - NULL -
status varchar(32) NO MUL Pending ✓ Pending/Approved State
verification_status varchar(32) NO MUL Pending ✓ Verification State
created_at datetime NO - current_timestamp() -
updated_at datetime NO - current_timestamp() -

Database Tables (17):

admins applicants audit_logs dynamic_fields interests kyc_documents membership_plans notifications partner_preferences payments profiles settings site_content site_settings site_sliders special_references users

⚡ 1-Click Database Table Initializer & Re-seeder

Auto-imports database.sql with full schema, indexes, and initial verified profiles.

Initialize MySQL Database
Default Master Admin: admin@padmashali.org / admin123