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