portfolio

Tables (6)

blogs

  • blog_id — SERIAL — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • written_date — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • is_pinned — BOOLEAN — NOT NULL
  • image_url — TEXT — NOT NULL
  • tags — TEXT — NOT NULL
  • blog_url — TEXT — NOT NULL
  • prime_tag — TEXT — NOT NULL

feedback

  • feedback_id — SERIAL — Primary key — NOT NULL
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • has_rating — BOOLEAN — NOT NULL
  • has_comment — BOOLEAN — NOT NULL
  • has_job_share — BOOLEAN — NOT NULL
  • has_bug_report — BOOLEAN — NOT NULL

feedback_extras

  • extra_id — SERIAL — Primary key — NOT NULL
  • feedback_id — SERIAL — Foreign key → feedback.feedback_id — NOT NULL
  • 코멘트내용 (comment_text) — TEXT
  • 버그내용 (bug_description) — TEXT
  • 회사명 (company_name) — VARCHAR(100)
  • 회사링크 (job_link) — TEXT

feedback_ratings

  • rating_id — SERIAL — Primary key — NOT NULL
  • feedback_id — SERIAL — Foreign key → feedback.feedback_id — NOT NULL
  • 완성도 (portfolio_score) — INT — NOT NULL
  • 기술점수 (technical_score) — INT — NOT NULL
  • 예술점수 (design_score) — INT — NOT NULL
  • 평균점수 (average_score) — DECIMAL(3,2) — NOT NULL

heart_logs

  • id — SERIAL — Primary key — NOT NULL
  • action — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL

heart_stats

  • id — INT — Primary key — NOT NULL
  • total_count — INT — NOT NULL