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