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)