refolio_fix
Tables (8)
AIFeedback
- ai_feedback_id — bigint — Primary key — NOT NULL
- portfolio_id — bigint — Foreign key → Portfolio.portfolio_id — NOT NULL
- content — text — NOT NULL
- status — varchar(20)
- created_at — timestamp
Favorite
- favorite_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- portfolio_id — bigint — Foreign key → Portfolio.portfolio_id — NOT NULL
Feedback
- feedback_id — bigint — Primary key — NOT NULL
- portfolio_id — bigint — Foreign key → Portfolio.portfolio_id — NOT NULL
- user_id — bigint — Foreign key → User.user_id
- content — varchar(3000) — NOT NULL
- created_at — timestamp
Images
- image_id — bigint — Primary key — NOT NULL
- portfolio_id — bigint — Foreign key → Portfolio.portfolio_id — NOT NULL
- url — varchar(100) — NOT NULL
- name — varchar(20)
Portfolio
- portfolio_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- title — varchar(50) — NOT NULL
- description — varchar(200)
- content — text — NOT NULL
- thumbnail_img — varchar(100)
- github_url — varchar(100)
- demo_url — varchar(100)
- created_at — timestamp
Recommendation
- recommendation_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- portfolio_id — bigint — Foreign key → Portfolio.portfolio_id — NOT NULL
Tag
- tag_id — bigint — Primary key — NOT NULL
- portfolio_id — bigint — Foreign key → Portfolio.portfolio_id — NOT NULL
- title — varchar(15) — NOT NULL
User
- user_id — bigint — Primary key — NOT NULL
- username — varchar(15) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(15) — NOT NULL