coatato-backend1

Tables (4)

applicant

  • id — BIGINT
  • name — VARCHAR(10) — NOT NULL
  • age — INT — NOT NULL
  • phone — VARCHAR(11) — NOT NULL
  • /* — 동일인
  • updated_at — DATETIME

application

  • id — BIGINT
  • applicant_id — BIGINT — NOT NULL
  • period — INT — NOT NULL
  • /* — >= — NOT NULL
  • /* — 기획/디자이너/프론트엔드/백엔드 — NOT NULL
  • /* — 0~10 — NOT NULL
  • /* — 0~10 — NOT NULL
  • /* — 제출 — NOT NULL
  • /* — yyyy-MM-dd
  • INDEX — idx_application_period

application_like

  • id — BIGINT
  • application_id — BIGINT — NOT NULL
  • staff_id — BIGINT — NOT NULL
  • created_at — DATETIME

staff

  • id — BIGINT
  • name — VARCHAR(10) — NOT NULL
  • age — INT — NOT NULL
  • phone — VARCHAR(11) — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • /* — PARTJANG/기획팀장/홍보팀장/부회장/회장/교육팀장
  • updated_at — DATETIME