UNESCO_MIGRATE

Tables (19)

audiences (Audiences)

  • id — INT — Primary key — NOT NULL
  • parent_id (parentId) — INT — Foreign key → audiences.id — NOT NULL
  • name — VARCHAR(100)
  • slug — VARCHAR(100)
  • description — VARCHAR(255)
  • count — INT
  • Field

blocked (Blocked)

  • id — INT — Primary key — NOT NULL
  • ip — VARCHAR(100)
  • reason — VARCHAR(255)

cities (Cities)

  • id — INT () — Primary key — NOT NULL
  • country_id (countryId) — INT () — Foreign key → countries.id — NOT NULL
  • name — VARCHAR(255)
  • state_id (stateId) — INT
  • state_code (stateCode) — VARCHAR(255)
  • country_code (countryCode) — CHAR(2)
  • latitude — DECIMAL(10, 8)
  • longitutde (longitude) — DECIMAL(11, 8)
  • flag — INT (1 / 0)
  • wiki_data_id (wikiDataId) — VARCHAR(255) / Qxxxxx

comments (Comments)

  • id — INT — Primary key — NOT NULL
  • author_id (authorId) — BIG INT — Foreign key → users.id — NOT NULL
  • discussion_id — INT — Foreign key → discussions.id — NOT NULL
  • id (id2) — BIG INT — Foreign key → discussions.author_id — NOT NULL
  • content — VARCHAR(255)
  • Field

countries (Countries)

  • id — INT () — Primary key — NOT NULL
  • name — VARCHAR(100)
  • numeric_code (numericCode) — CHAR(3)
  • iso2 — CHAR(2)
  • iso3 (iso) — CHAR(3)
  • phone_code (phoneCode) — VARCHAR(255)
  • captial (capital) — VARCHAR(255)
  • currency — VARCHAR(255)
  • currency_name (currencyName) — VARCHAR(255)
  • currency_symbol (currencySymbol) — VARCHAR(255)
  • domain — VARCHAR(255)
  • native — VARCHAR(255)
  • region — VARCHAR(255)
  • subregion — VARCHAR(255)
  • timezones — TEXT
  • translations — TEXT
  • latitude — DECIMAL(10, 8)
  • longitude — DECIMAL(11, 8)
  • emoji — VARCHAR(191)
  • emoji_unicode (emojiUnicode) — VARCHAR(191)
  • flag — INT (1 / 0)
  • wiki_data_id (wikiDataId) — VARCHAR(255)/Qxxxx
  • Field

discussions (Discussions)

  • id — INT — Primary key — NOT NULL
  • author_id (authorId) — BIG INT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(100)
  • content — VARCHAR(255)

educations (Educations)

  • id — INT — Primary key — NOT NULL
  • author_id (authorId) — BIG INT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255)
  • cover_img (coverImg) — VARCHAR(255)
  • type — ENUM(link, file)
  • url — VARCHAR(255)
  • lang — ENUM(english, ....)
  • status — ENUM(pending, publish)
  • content — TEXT

organizations (Organizations)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(100)
  • logo — VARHCHAR(255)
  • location — JSON
  • website — VARCHAR(100)
  • description — VARCHAR(255)
  • status — ENUM(pending, published)

organizations_themes (OrganizationsThemes)

  • theme_id (themeId) — INT — Foreign key → themes.id — NOT NULL
  • organization_id (organizationId) — INT — Foreign key → organizations.id — NOT NULL

posts (Posts)

  • id — BIG INT — Primary key — NOT NULL
  • author_id (authorId) — BIG INT — Foreign key → users.id — NOT NULL
  • created_at (createdAt) — DATE TIME
  • created_at_gmt (createdAtGmt) — DATE TIME
  • content — TEXT
  • excerpt — TEXT
  • status — VARCHAR(20)
  • password — VARCHAR(255)
  • related_post (relatedPost) — BIG INT
  • guid — VARCHAR(255)
  • mime_type (mimeType) — VARCHAR(100)
  • type — ENUM(resource, articles, event)

posts_audiences (Posts_Audiences)

  • post_id (postId) — BIG INT — Foreign key → posts.id — NOT NULL
  • audiences_id (audiencesId) — INT — Foreign key → audiences.id — NOT NULL

posts_themes (PostThemes)

  • post_id (postId) — BIG INT — Foreign key → posts.id — NOT NULL
  • theme_id (themeId) — INT — Foreign key → themes.id — NOT NULL

questions (Questions)

  • id — INT — Primary key — NOT NULL
  • content — VARCHAR(255)
  • status — ENUM(pending, publish)
  • Field

questions_tags (QuestionsTags)

  • question_id (questionId) — INT — Foreign key → questions.id — NOT NULL
  • tag_id (tagId) — INT — Foreign key → tags.id — NOT NULL

states (States)

  • id — INT () — Primary key — NOT NULL
  • country_id (countryId) — INT () — Foreign key → countries.id — NOT NULL
  • country_code (countryCode) — CHAR(2)
  • fips_code (fipsCode) — VARCHAR(255)
  • iso2 — VARCHAR(255)
  • type — VARCHAR(191)
  • flag — INT (1 / 0)
  • wiki_data_id (wikiDataId) — VARCHAR(255) / Qxxx
  • Field

tags (Tags)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(100)
  • count — INT

themes (Themes)

  • id — INT — Primary key — NOT NULL
  • parent_id (parentId) — INT — Foreign key → themes.id — NOT NULL
  • name — VARCHAR(100)
  • slug — VARCHAR(100)
  • description — VARCHAR(255)
  • count — INT
  • Field

user_meta (UserMeta)

  • id — INT() — Primary key — NOT NULL
  • user_id (userId) — BIG INT — Foreign key → users.id — NOT NULL
  • nickname — VARCHAR(255)
  • fist_name — VARCHAR(100)
  • last_name — VARCHAR(100)
  • description — VARCHAR(255)
  • job — VARCHAR(255)
  • x_name (xName) — VARCHAR(255)
  • instagram_name (instagramName) — VARCHAR(255)
  • linked_in (linkedIn) — VARCHAR(255)
  • location — JSON
  • post_id (?) (Field)
  • profile_image (profileImage)
  • expertise — STRING[]
  • awards — VARCHAR(100)
  • Field2

users (Untitled)

  • id — BIG INT — Primary key — NOT NULL
  • username — VARCHAR(60) / def = ''
  • password — VARCHAR(255) / def = ''
  • user_slug (userSlug) — VARCHAR(50) / def = ''
  • email — VARCHAR(100) def = ''
  • url — VARCHAR(100) def = ''
  • created_at (createdAt) — DATETIME def = '0000-00-00 00:00:00'
  • activation_key (activationKey) — VARCHAR(255) def = ''
  • nickname — VARCHAR(250)
  • status — INT def = 0 (everything is 0)
  • role — STRING[] / prev wp_capabilties
  • session_token (sessionTokens) — VARCHAR(255)