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