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