portshop
Tables (5)
project
- project_name (name) — VARCHAR(20)
- project_date (date) — datetime
- project_skill (skill) — TEXT
- project_info (info) — TEXT
- user_id (id) — Foreign key → user.user_id — NOT NULL
- image — VARCHAR(20)
user (Untitled)
- user_id (id) — Primary key — NOT NULL
- birth — VARCHAR(20)
- user_date (date) — VARCHAR(20)
- phone — VARCHAR(20)
- korea_name — VARCHAR(20)
- user_email (email) — VARCHAR(20)
- user_github (github) — VARCHAR(20)
- bachelor (univ) — VARCHAR(20)
- bachelor_major (major) — VARCHAR(20)
- portfolio_name (pf_name) — VARCHAR(20)
- master — VARCHAR(20)
- master_major (ms_major) — VARCHAR(20)
- sex — VARCHAR(20)
- photo (image) — IMAGE
- eng_name — VARCHAR(20)
user skill
- user_id (id) — Foreign key → user.user_id — NOT NULL
- skill_name (name) — VARCHAR(20)
- skill_percent (int) — INT
- logo — imae
user_exp
- user_id (id) — Foreign key → user.user_id — NOT NULL
- name — VARCHAR(20)
- date — VARCHAR(20)
- info — VARCHAR(20)
user_prize
- user_id (id) — VARCHAR(20) — Primary key — NOT NULL
- date — VARCHAR(20)
- name — VARCHAR(20)
- institution (insti) — VARCHAR(20)
- info — VARCHAR(20)