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