portfolio

Tables (19)

certification

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • supported_language_idx — BIGINT — Foreign key → supported_language.Key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • organization — VARCHAR(100) — NOT NULL
  • Issue_date — DATE — NOT NULL
  • expiration_date — DATE — NOT NULL
  • description — TEXT

education

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • supported_language_idx — BIGINT — Foreign key → supported_language.Key — NOT NULL
  • school — VARCHAR(100) — NOT NULL
  • degree — VARCHAR(100) — NOT NULL
  • major — VARCHAR(100) — NOT NULL
  • location — VARCHAR(200) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • description — TEXT

language

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • language — VARCHAR(20) — NOT NULL

language_ability

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • member_idx — BIGINT — Foreign key → member.key — NOT NULL
  • language_idx — BIGINT — Foreign key → language.Key — NOT NULL
  • level — VARCHAR(20) — NOT NULL

member

  • key (idx) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(40) — NOT NULL
  • password — VARCHAR(200) — NOT NULL

member_permissions

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • member_idx — BIGINT — Foreign key → member.key — NOT NULL
  • role_idx — BIGINT — Foreign key → role.Key — NOT NULL

message

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • sender — BIGINT — Foreign key → member.key — NOT NULL
  • receiver — BIGINT — Foreign key → member.key — NOT NULL
  • message — TEXT — NOT NULL
  • check_status — BOOLEAN — NOT NULL
  • send_time — TIMESTAMP — NOT NULL
  • check_time — TIMESTAMP — NOT NULL

professional_experience

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • supported_language_idx — BIGINT — Foreign key → supported_language.Key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • organization — VARCHAR(200) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • description — TEXT

project

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • supported_language_idx — BIGINT — Foreign key → supported_language.Key — NOT NULL
  • project_name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • overview — TEXT — NOT NULL
  • industry — VARCHAR(100)
  • role — VARCHAR(100) — NOT NULL
  • description — TEXT

read_portfolio

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • portfolio_author — BIGINT — Foreign key → supported_language.Key — NOT NULL — supported_language_idx
  • portfolio_reader — BIGINT — Foreign key → supported_language.Key — NOT NULL — supported_language_idx
  • read_time — TIMESTAMP — NOT NULL

role

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • explain — TEXT

saved_portfolio

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • portfolio_author — BIGINT — Foreign key → supported_language.Key — NOT NULL — supported_language_idx
  • portfolio_savers — BIGINT — Foreign key → supported_language.Key — NOT NULL — supported_language_idx
  • saved_time — TIMESTAMP — NOT NULL

self_introduction

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • supported_language_idx — BIGINT — Foreign key → supported_language.Key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(100) — NOT NULL
  • job — VARCHAR(100)
  • linkedin — VARCHAR(100)
  • github — VARCHAR(200)
  • blog — VARCHAR(200)
  • about_me — TEXT

setting

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • member_idx — BIGINT — Foreign key → member.key — NOT NULL
  • email_ receive_status — BOOLEAN — NOT NULL
  • job_seeking_preference — TINYINT — NOT NULL

skill

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(100) — NOT NULL

supported_language

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • member_idx — BIGINT — Foreign key → member.key — NOT NULL
  • language_idx — BIGINT — Foreign key → language.Key — NOT NULL
  • support_status — BOOLEAN — NOT NULL

technical_proficiency

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • skill_idx — BIGINT — Foreign key → skill.Key — NOT NULL
  • experience — TINYINT — NOT NULL
  • proficiency — VARCHAR(20) — NOT NULL

work_experience

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • supported_language_idx — BIGINT — Foreign key → supported_language.Key — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • job_type — VARCHAR(100) — NOT NULL
  • location — VARCHAR(100) — NOT NULL
  • job_title — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • description — TEXT

work_proficiency

  • Key (idx) — BIGINT — Primary key — NOT NULL
  • skill_idx — BIGINT — Foreign key → skill.Key — NOT NULL
  • member_idx — BIGINT — Foreign key → member.key — NOT NULL
  • frequency — VARCHAR(20) — NOT NULL