This document shows how the various keys of the MySQL database of my website is organized into categories

IndieMendable Database Structure.txt

//////////////////////////////////////////            New Database          //////////////////////////////////////////

/* 
 * General database key names.
 */
 
 Identification:    (id,)
 Environment:        domain, type, place,( category, tags,)
 Time:               posted(/registered/added), edited/updated, state_updated,
 Author:             author(/friend1/sent_from) (+ IP),
                     
 Attributes:         content/value(/body/overall_rating),
                        name(/title/subject), description, category, tags,
                        picture, theme, mood(/emotion), header_picture.
 Appearence:         color, skin,
                     
 Action:             info/action/relation,
 Object:             object(/friend2/sent_to),
 
 State:              state, processed, featured, visibility,
                        ordinal, version, stage,
                        seen.
                     
(Statistics:)        featured,
                        (number of ...; passive) downloads(/plays), views,
                        (number of ...; active) reviews, comments, ratings,
 Reception:          rating, favorites, likes.

/* 
 * Users table.
 */
 
 Environment:        domain,
 
 Attributes:         username, email, password,
                     nicename, firstname, lastname, date_of_birth,
                     signature, location,

 Session:            last_active, stay_logged_in_ip, -_cookie, -_expire,
 Regional info:      time_offset, -_zone, -_zone_id, -_zone_autodetect.

/* 
 * Games table.
 */

// Structure details (29 columns). //
Identification (1):
    id
Environment (2):
    category
    tags
Time (3):
    posted
    edited
    state_updated
Author (2):
    author
    ip
Attributes (7):
    content
    name
    description
    picture
    theme
    mood
    header_picture
Appearence (2):
    color
    skin

+ Action/Object +

State (7):
    state
    processed
    featured
    visibility
    ordinal
    version
    stage
Statistics (2):
    plays
    views
Reception (3):
    rating
    favorites
    likes

/* 
 * Messages table.
 */
 
 Attributes:         seen.

/* 
 * Reviews table.
 */
 
 Attributes:         pros, cons.

/* 
 * Expiring links table.
 */
 
 Time:               expiration.