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