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