abcd

Tables (21)

Boards

  • id — int — Primary key
  • name — char
  • curated_by — char
  • description (descriptio) — char
  • Field

Certificate

  • id — int — Primary key
  • id_user — int — Foreign key → users.id
  • certificate — char
  • from — char
  • year — int
  • Field

Industry

  • id — int — Primary key
  • name — char
  • Field

Job

  • id — int — Primary key
  • id_company — int — Foreign key → companies.id
  • id_user — int — Foreign key → users.id
  • id_industry — int — Foreign key → Industry.id
  • title — char
  • address — char
  • time_work — char
  • description — char
  • type_of_position — char
  • primary_role — char
  • currency — char
  • salary_from — int
  • salary_to — int
  • equity_range_from — int
  • equity_range_to — int
  • work_experience — char
  • work_type — char
  • location — char
  • area_hiring — char
  • Field

Product

  • id — int — Primary key
  • id_role — int — Foreign key → role_categories.id
  • id_topic — int — Foreign key → Topic.id
  • id_user — int — Foreign key → users.id
  • name — char
  • description — char
  • url — char
  • image — char
  • Field

Subscribe

  • id_user — int — Foreign key → users.id
  • id_board — int — Foreign key → Boards.id

Topic

  • id — int — Primary key
  • name — char
  • Field

companies

  • id — int — Primary key
  • name — char
  • pitch — char
  • description — char
  • address — char
  • employee_from — int
  • employee_to — int
  • url — char
  • founded — int
  • industry — char
  • Field

company_board

  • id — int — Primary key
  • id_board — int — Foreign key → Boards.id
  • id_company — int — Foreign key → companies.id
  • Field

company_social

  • id — int — Primary key
  • id_social — int — Foreign key → social.id
  • id_company — int — Foreign key → companies.id
  • url — char
  • Field

education

  • id — int — Primary key
  • id_user — int — Foreign key → users.id
  • degree — char
  • school — char
  • graduation_year — int
  • Field

follow_company

  • id_user — int — Foreign key → users.id
  • id_company — int — Foreign key → companies.id

role_categories

  • id — int — Primary key
  • name — char
  • Field

role_sub_categories

  • id — int — Primary key
  • idRoleCategory — int — Foreign key → role_categories.id
  • name — char
  • Field

skills

  • id — int — Primary key
  • idRoleSubCategory — int — Foreign key → role_sub_categories.id
  • tab — char
  • name — char
  • Field

social

  • id — int — Primary key
  • name — char
  • image — char
  • Field

sub_skill

  • id — int — Primary key
  • id_skill — int — Foreign key → skills.id
  • tab — char
  • name — char
  • Field

user_skill

  • id — int — Primary key
  • id_user — int — Foreign key → users.id
  • id_skill — int — Foreign key → sub_skill.id
  • isSuperPower — int
  • Field

user_social

  • id — int — Primary key
  • id_user — int — Foreign key → users.id
  • id_social — int — Foreign key → social.id
  • url — char
  • Field

users

  • id — int — Primary key
  • id_role — int — Foreign key → role_categories.id
  • id_type — int — Foreign key → role_sub_categories.id
  • first_name — char
  • last_name — char
  • email — char
  • password — char
  • experience — int
  • description — char
  • pitch — char
  • isPublic — boolean
  • signUpType — char
  • Field

work_history

  • id — int — Primary key
  • id_user — int — Foreign key → users.id
  • title (tab) — char
  • company — char
  • from — date
  • to — date
  • description — char
  • current_work — int
  • Field