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)