Database Tables
Here is a sumarry of the tabels D.T uses
wp_posts
D.T records like contacts and groups
The post row contains limited data like: post ID, name, author, creation date
wp_postmeta
Stores field data abot the recod
Example: status, milestones
wp_dt_post_user_meta
D.T custom table
Stores record data that is only visible to one user (private fields)
Example: my favorite contacts
wp_comments
Stores record comments
wp_commentmeta
Stores comment meta like
Example: reactions
wp_dt_share
D.T custom table
Stores who a record is shared with (which users have access to a record)
wp_p2p
Stores connections to other records
Example: contact records that form a group's members
wp_p2pmeta
Stores p2p meta. Currently unused
D.T custom table, stores activity on records
Example: Milestone "praying" selected on July 27 2020 at 7:23pm
wp_dt_location_grid
D.T custom table.
Stores the base location grid project. Used in the location field
Example: Paris, France, grid_id: 100089652, level: admin2
wp_dt_location_grid_meta
D.T custom table
Stores extra geocoding data when using a geocoder from mapbox or google
wp_dt_notifications
D.T custom table
Stores web notifications for user to see when they log in
Example: You were assigned on contact John Doe
wp_dt_reports
D.T custom table
Stores lightweight events
Possible example: meeting times
wp_dt_reportmeta
D.T custom table
Store extra information on a report
wp_dt_movement_log
D.T custom table
Stores geocoded event that can more easily be queried
wp_options
WP table
Stores settings and configurations used by D.T
wp_users
WP table
Each user that user the D.T system has a user record
wp_usermeta
WP table
Stores user information
Example: prefered language
Tables that D.T does not use:
wp_links
wp_term_relationships
wp_term_taxonomy
wp_termmeta
wp_terms
Last updated