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