외주개발자서비스
테이블 (9)
Application
- id — INT
- project_id — INT — NOT NULL
- developer_id — INT — NOT NULL
- estimated_cost — INT
Contract
- id — INT
- project_id — INT — NOT NULL
- developer_id — INT — NOT NULL
- is_agreed — BOOLEAN
Message
- id — INT
- project_id — INT — NOT NULL
- sender_id — INT — NOT NULL
- content — TEXT
- created_at — DATETIME
Payment
- id — INT
- contract_id — INT — NOT NULL
- amount — INT
- status — VARCHAR(50)
Project
- id — INT
- client_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- budget — INT
- status — VARCHAR(50)
TechTest
- id — INT
- project_id — INT — NOT NULL
- question — TEXT — NOT NULL
TestSubmission
- id — INT
- test_id — INT — NOT NULL
- developer_id — INT — NOT NULL
- score — INT
User
- id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- type — VARCHAR(20) — NOT NULL
User (Untitled)
- Key — 기본 키 — NOT NULL
- Field
- Field2