prism

Tables (7)

HashTag (Untitled4)

  • Key — int — Primary key — NOT NULL
  • Field — varchar
  • ID (Key2) — int — Foreign key → Portfolio.UserID — NOT NULL

Portfolio (Untitled2)

  • UserID (Key2) — int — Foreign key → UserInfo.UserID — NOT NULL
  • 한줄 본인 소개 (Field) — text

Project (Untitled3)

  • Key2 — int — Primary key — NOT NULL
  • UserID (Key22) — int — Foreign key → Portfolio.UserID — NOT NULL
  • 프로젝트 명 (Field2) — varchar
  • 한줄 소개 (Field) — text
  • architecture_img (Field3) — varchar

Skill_list (Untitled8)

  • Key3 — Primary key — NOT NULL
  • UserID (Key2) — int — Foreign key → Portfolio.UserID — NOT NULL
  • Level (Field) — int
  • id (Key) — int — Foreign key → Tech_stack.id — NOT NULL

Tech_category (Untitled5)

  • code (Field) — int — Primary key
  • Field (Field2) — varchar

Tech_stack (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • skill (Field) — varchar
  • code (Field2) — int — Foreign key → Tech_category.code

UserInfo (Untitled)

  • UserID (Key) — int — Primary key — NOT NULL
  • NickName (Field) — varchar
  • ProfileImg (Field2) — varchar