GetJob

Tables (4)

portfolio

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • title — VARCHAR(255)
  • subject — VARCHAR(255)
  • role — VARCHAR(255)
  • skills — VARCHAR(255)
  • team_size — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE

portfolio_descriptions

  • portfolio_id — BIGINT — Foreign key → portfolio.id — NOT NULL
  • descriptions — TEXT

portfolio_images

  • portfolio_id — BIGINT — Foreign key → portfolio.id — NOT NULL
  • image_paths — VARCHAR(255)

users

  • id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(255)
  • password — VARCHAR(255)
  • role — VARCHAR(255)
  • username — VARCHAR(255)