In the attached files, you will find a detailed description of the database tables pgdating_db_connections and the connections between them pgdating_db_structure.mwb
Product Structure
Overview:
Section | Description |
| Main configuration file defining constants. |
| General site settings. |
| Settings for module installation. |
| Library managing routing for the application. |
| Theme configurations and styles. |
Technical documentation (2012)
A prefix is added to the name of each table during the installation process.
General settings
Basic settings
settings: Contains all the primary settings of the website.elements: Fields and settings for the form builder.maintenance: Pages for server warnings and maintenance notices.language: Installed site languages and their parameters.menu: Website menu configurations.distance_spr: Reference table for search distances.cron: Cron job schedules. Scripts executed before the scheduled time will not run.ip_country: IP addresses associated with countries.block_ip: List of IP addresses or countries blocked from accessing the site.ip_cache: Cache for IP addresses.server_errors: Pages displaying server errors.servers: List of site servers and domains.seo_files_assoc: SEO page names for different languages.metatags: Metadata for site pages (title, keywords, description).
Design and Templates
special_logotype: Special and holiday logos.templates: Site templates.themes: Site themes.color_theme: Color themes for the site.slider_picture: Images for the slider on the index page.video_site: Videos for the index page.carousel: Carousel with user photos.
Users
User tables
user: Table containing basic user data (name, surname, login, password, email, etc.).mailbox: User mailbox.mailbox_attaches: Files attached to user emails.user_mailbox_settings: Settings for cleaning up user mailboxes.shoutbox_messages: User messages in the shoutbox.account_alerts: Messages sent by the site administrator to users.kisslist: Virtual kisses between users.kisslist_spr: Reference table for types of kisses.blacklist: User's blacklist.hotlist: User's friends list.hotlist_spr: Reference table for types of friends.user_upload: Table for user-uploaded files (photos, audio, video).audio_files_info: Information about uploaded audio files.servers: Main server parameters, including file upload configurations.user_albums: User multimedia albums.country_spr: Country reference table.region_spr: Region reference table.city_spr: City reference table.profile_visit: Table for user profile visit statistics.subscribe_user: User subscriptions to notifications.subscribe_system: Types of notifications.user_voip: Information on user VOIP calls.user_rating: User ratings.user_pair: ID of the user's pair for partner profiles.user_ip: Visitor IP addresses.active_sessions: Information on current user sessions.user_topten: Top users.user_percent: Information on profile completion percentages.user_vkontakte_connect: Settings for the VKontakte Connect application.user_facebook_connect: Settings for the Facebook Connect application.user_match: Desired partner attributes for users.org_user_site_profiles: User profiles on other sites (organizer).org_user_home_options: User page settings (organizer).org_user_layouts: Color and design settings for the user page (organizer).org_user_bookmarks: User bookmarks (organizer).org_user_calendar_actions: Events in the user's calendar (organizer).notifications_user: User notifications.notifications: Reference table for notification types.
Authentication and permissions
Authentication and group permissions
active_sessions: Stores user session information.groups: User groups on the site.group_period: Periods for user groups.billing_user_period: User's association with a group period.modules: Contains information about modules.module_file: Information about module files.group_module: Stores module associations with groups.user_group: Stores user group associations.groups_permissions: Quantitative values of permissions for groups.permissions: List of permission values for groups.
Wall and Events
Wall and Event tables
events: Table for user wall events.comments: Comments on walls and user photos.comment_type: Types of comments.comment_count: Comment statistics.likes: Likes on user photos in galleries and walls.
Payment systems
Payment configuration
billing_systems: Service table storing general payment system settings.billing_sys_*: Tables for individual payment system settings.Examples:
billing_sys_2checkout: 2Checkout payment system settings.billing_sys_paypal: PayPal payment system settings.billing_sys_webmoney: WebMoney payment system settings.
billing_periods_ccbill: Period settings for the CCBill payment system.billing_user_account: Current account balance of the user.billing_send_requests: List of payment attempts (successful and unsuccessful).billing_entry: User payment statistics.billing_unit: Payment currency.payment_services_settings: Settings for paid site services.
Geographic data
Location reference tables
country_spr: Reference table for countries.region_spr: Reference table for regions.city_spr: Reference table for cities.zip_codes: Postal codes.country_codes: International country codes.
Directories
User and attribute references
descr_spr: General user information reference table.personality_spr: Reference for personal user attributes.portrait_spr: Reference for user portraits.interests_spr: Reference for user interests.user_spr: Reference for dynamic fields.relationship_spr: Reference for relationship types.nationality_spr: Reference for nationalities.weight_spr: Reference for weights.reference_lang_spr: Multi-language reference table.
Banners
Banner management
banners_table: Banner table with main parameters.banners_sizes: Banner sizes.banners_area: Locations for banners.banners_global_statistics: Banner view statistics.
Events
Event configuration
event_descr: Table with event descriptions.event_comments: User comments on events.event_users: Users participating in events.event_uploads: Files uploaded to events.event_types: Event types.event_invites: User invitations to events.
Polls
Poll configuration
poll_polls: Table containing polls.poll_poll_answers: Answer options for polls.poll_user_answers: User responses to polls.poll_categories: Poll categories.
Informational pages
Content and Help pages
addition_info_content: Informational pages of the site.addition_info_lang_content: Help and informational pages in multiple languages.












