Ready's7

Tables (12)

categories

  • id — UUID
  • name — VARCHAR(100)
  • slug — VARCHAR(100)
  • icon — VARCHAR(100)
  • description — TEXT
  • created_at — TIMESTAMP

chat_rooms

  • id — UUID
  • project_id — UUID — Foreign key → projects.id
  • created_at — TIMESTAMP

developer_skills

  • id — UUID
  • developer_id — UUID — Foreign key → users.id
  • skill_id — UUID — Foreign key → skills.id
  • proficiency — VARCHAR(20)
  • years_of_experience — INT
  • created_at — TIMESTAMP

messages

  • id — UUID
  • chat_room_id — UUID — Foreign key → chat_rooms.id
  • sender_id — UUID — Foreign key → users.id
  • receiver_id — UUID — Foreign key → users.id
  • content — TEXT
  • is_read — BOOLEAN
  • sent_at — TIMESTAMP

portfolio_skills

  • id — UUID
  • portfolio_id — UUID — Foreign key → portfolios.id
  • skill_id — UUID — Foreign key → skills.id

portfolios

  • id — UUID
  • developer_id — UUID — Foreign key → users.id
  • title — VARCHAR(255)
  • description — TEXT
  • image_url — TEXT
  • project_url — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

project_skills

  • id — UUID
  • project_id — UUID — Foreign key → projects.id
  • skill_id — UUID — Foreign key → skills.id
  • created_at — TIMESTAMP

projects

  • id — UUID
  • client_id — UUID — Foreign key → users.id
  • category_id — UUID — Foreign key → categories.id
  • title — VARCHAR(255)
  • description — TEXT
  • budget — INT
  • duration — VARCHAR(100)
  • status — VARCHAR(20)
  • proposal_count — INT
  • posted_date — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

proposals

  • id — UUID
  • project_id — UUID — Foreign key → projects.id
  • developer_id — UUID — Foreign key → users.id
  • cover_letter — TEXT
  • proposed_budget — INT
  • proposed_duration — VARCHAR(100)
  • status — VARCHAR(20)
  • submitted_at — TIMESTAMP
  • updated_at — TIMESTAMP

reviews

  • id — UUID
  • project_id — UUID — Foreign key → projects.id
  • proposal_id — UUID — Foreign key → proposals.id
  • reviewer_id — UUID — Foreign key → users.id
  • reviewee_id — UUID — Foreign key → users.id
  • rating — INT
  • comment — TEXT — EX
  • created_at — TIMESTAMP

skills

  • id — UUID
  • name — VARCHAR(100)
  • category — VARCHAR(100)
  • created_at — TIMESTAMP

users

  • id — UUID
  • email — VARCHAR(255)
  • password_hash — TEXT
  • name — VARCHAR(100)
  • user_type — VARCHAR(20)
  • avatar_url — TEXT
  • title — VARCHAR(255)
  • description — TEXT
  • location — VARCHAR(255)
  • hourly_rate — INT
  • response_time — VARCHAR(50)
  • completed_projects — INT
  • rating — FLOAT
  • review_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP