test
Tables (17)
cpt_course
- post_id — bigint — Foreign key → wp_posts.ID — NOT NULL
cpt_experience
- post_id — bigint — Foreign key → wp_posts.ID — NOT NULL
cpt_recurring_assignment
- post_id — bigint — Foreign key → wp_posts.ID — NOT NULL
cpt_registration
- post_id — bigint — Foreign key → wp_posts.ID — NOT NULL
cpt_submission
- post_id — bigint — Foreign key → wp_posts.ID — NOT NULL
meta_registration_core
- post_id — bigint — Foreign key → wp_posts.ID — NOT NULL
- experience_id — bigint — Foreign key → wp_posts.ID
- user_id — bigint
- required_points — int
- user_points_at_registration — int
- assigned_teacher — bigint
- registration_date — datetime
- registration_uuid — char(36)
- status — varchar(32)
- approved_date — datetime
- rejected_date — datetime
meta_submission_core
- post_id — bigint — Foreign key → wp_posts.ID — NOT NULL
- linked_post — bigint — Foreign key → wp_posts.ID
- teacher_id — bigint
- status — varchar(32)
- points_awarded — int
- submission_uuid — char(36)
- approved_date — datetime
- was_rejected — tinyint(1)
tax_course_subject
- term_taxonomy_id — bigint — Foreign key → wp_term_taxonomy.term_taxonomy_id — NOT NULL
tax_experience_category
- term_taxonomy_id — bigint — Foreign key → wp_term_taxonomy.term_taxonomy_id — NOT NULL
tax_grade
- term_taxonomy_id — bigint — Foreign key → wp_term_taxonomy.term_taxonomy_id — NOT NULL
tax_modul
- term_taxonomy_id — bigint — Foreign key → wp_term_taxonomy.term_taxonomy_id — NOT NULL
tax_module
- term_taxonomy_id — bigint — Foreign key → wp_term_taxonomy.term_taxonomy_id — NOT NULL
wp_postmeta
- meta_id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → wp_posts.ID — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
wp_posts
- ID — bigint — Primary key — NOT NULL
- post_author — bigint — NOT NULL
- post_date — datetime — NOT NULL
- post_content — longtext — NOT NULL
- post_title — text — NOT NULL
- post_status — varchar(20) — NOT NULL
- post_name — varchar(200) — NOT NULL
- post_type — varchar(20) — NOT NULL
wp_term_relationships
- object_id — bigint — Primary key — NOT NULL
- term_taxonomy_id — bigint — Foreign key → wp_term_taxonomy.term_taxonomy_id — NOT NULL
- term_order — int — NOT NULL
wp_term_taxonomy
- term_taxonomy_id — bigint — Primary key — NOT NULL
- term_id — bigint — Foreign key → wp_terms.term_id — NOT NULL
- taxonomy — varchar(32) — NOT NULL
- description — longtext
- parent — bigint — NOT NULL
wp_terms
- term_id — bigint — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- slug — varchar(200) — NOT NULL