외주개발자서비스

테이블 (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