Project_DevNear

Tables (12)

applications

  • application_id — INT
  • project_id — INT — Foreign key → projects.project_id — NOT NULL
  • freelancer_id — INT — Foreign key → freelancer_profiles.freelancer_id — NOT NULL
  • client_id — INT — Foreign key → client_profiles.클라이언트_ID — NOT NULL
  • bid_price — DECIMAL(10, 2)
  • message — TEXT
  • status — VARCHAR(30) — NOT NULL — PENDING, ACCEPTED, REJECTED, CANCELLED
  • created_at — DATETIME — NOT NULL

chat_messages

  • message_id — INT
  • room_id — INT — Foreign key → chat_rooms.room_id — NOT NULL
  • sender_id — INT — Foreign key → users.유저 ID — NOT NULL
  • content — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_rooms

  • room_id — INT
  • application_id — INT — Foreign key → applications.application_id — NOT NULL
  • client_id — INT — Foreign key → client_profiles.클라이언트_ID — NOT NULL
  • freelancer_id — INT — Foreign key → freelancer_profiles.freelancer_id — NOT NULL
  • created_at — DATETIME — NOT NULL

client_profiles

  • 클라이언트_ID (client_id) — INT
  • 유저ID (user_id) — INT — Foreign key → users.유저 ID — NOT NULL
  • 회사명 (company_name) — VARCHAR(255)
  • 소개란 (introduction) — TEXT
  • 가입일시 (created_at) — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

client_reviews

  • client_review_id — INT
  • project_id — INT — Foreign key → projects.project_id — NOT NULL
  • client_id — INT — Foreign key → client_profiles.클라이언트_ID — NOT NULL
  • freelancer_id — INT — Foreign key → freelancer_profiles.freelancer_id — NOT NULL
  • payment_punctuality — DECIMAL(2,1)
  • requirement_clarity — DECIMAL(2,1)
  • communication — DECIMAL(2,1)
  • manner — DECIMAL(2,1)
  • total_rating — DECIMAL(2,1)
  • comment — TEXT — EX
  • created_at — DATETIME — NOT NULL

freelancer_profiles

  • freelancer_id — INT
  • user_id — INT — Foreign key → users.유저 ID — NOT NULL
  • profile_image_url — VARCHAR(255)
  • introduction — TEXT
  • location — VARCHAR(100)
  • average_rating — DECIMAL(3, 2)
  • completed_projects — INT — NOT NULL
  • review_count — INT — NOT NULL
  • grade — VARCHAR(30) — NOT NULL — GENERAL, VERIFIED, TOP_TALENT
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

freelancer_reviews

  • freelancer_review_id — INT
  • project_id — INT — Foreign key → projects.project_id — NOT NULL
  • freelancer_id — INT — Foreign key → freelancer_profiles.freelancer_id — NOT NULL
  • client_id — INT — Foreign key → client_profiles.클라이언트_ID — NOT NULL
  • work_quality — DECIMAL(2,1)
  • deadline — DECIMAL(2,1)
  • communication — DECIMAL(2,1)
  • expertise — DECIMAL(2,1)
  • total_rating — DECIMAL(2,1)
  • comment — TEXT — EX
  • created_at — DATETIME — NOT NULL

notifications

  • notification_id — INT
  • user_id — INT — Foreign key → users.유저 ID — NOT NULL
  • type — VARCHAR(30) — NOT NULL — APPLICATION, REVIEW, CHAT, STATUS
  • content — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • link_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

portfolio_images

  • image_id — INT
  • portfolio_id — INT — Foreign key → portfolios.portfolio_id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

portfolios

  • portfolio_id — INT
  • freelancer_id — INT — Foreign key → freelancer_profiles.freelancer_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

projects

  • project_id — INT
  • client_id — INT — Foreign key → client_profiles.클라이언트_ID — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • budget — DECIMAL(10, 2)
  • location — VARCHAR(100)
  • status — VARCHAR(30) — NOT NULL — OPEN, IN_PROGRESS, CLOSED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • 유저 ID (user_id) — INT
  • 이메일 (email) — VARCHAR(255) — NOT NULL
  • 비밀번호 (password) — VARCHAR(255) — NOT NULL
  • 닉네임 (nickname) — VARCHAR(100) — NOT NULL
  • 역할 (role) — VARCHAR(30) — NOT NULL — USER, CLIENT, FREELANCER, BOTH
  • 생성일자 (created_at) — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL