포트폴리오

테이블 (4)

Untitled (Card)

  • Key (card_id) — BIGINT — 기본 키 — NOT NULL
  • Field (title) — VARCHAR
  • Field2 (content) — TEXT
  • Field3 (layout_type) — ENUM
  • Field (theme_color) — VARCHAR
  • Field (custom_url) — VARCHAR
  • Field (view_count) — INT
  • Field (updated_at) — DATETIME
  • Key (user_id) — 외래 키 → User.Key — NOT NULL
  • Field (category) — VARCHAR
  • Field (sub_category) — VARCHAR
  • Field (phone) — INT
  • Field (location) — VARCHAR
  • Field (summary_intro) — TEXT

Untitled (Card_Link)

  • Key (link_id) — BIGINT — 기본 키 — NOT NULL
  • Key (card_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (link_type) — VARCHAR
  • Field (link_url) — TEXT

Untitled (Project)

  • Key (project_id) — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR
  • Field (summary) — VARCHAR
  • Field (link) — varchar
  • Key (card_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

User

  • Key (user_id) — BIGINT — 기본 키 — NOT NULL
  • 구글 계정 이메일 (email) — VARCHAR
  • Field (nickname) — VARCHAR
  • Field (profile_img) — TEXT