Prism Prompt
Tables (5)
Admin
- id — TEXT
- created_at — timestamp
- updated_at — timestamp
- username — TEXT — 아이디
- name — TEXT — 이름
- tel — TEXT — 연락처
Application
- id — TEXT
- created_at — timestamp
- updated_at — timestamp
- amount — INT — 제시금액
- workingPeriod — TEXT — 작업기간
- content — TEXT — 지원내용
- surveyId — INT — NOT NULL
Category
- id — TEXT
- created_at — timestamp
- updated_at — timestamp
- name — TEXT — 카테고리 이름
- provider — ENUM — 유형
ChatMessage
- id — INT
- created_at — timestamp
- updated_at — timestamp
- roomId — TEXT — NOT NULL
- memberId — TEXT — NOT NULL
- message — NULL
- documents — JSON
ChatRoom
- id — TEXT
- created_at — timestamp
- updated_at — timestamp
- clientId — TEXT — NOT NULL
- applicantId — TEXT — NOT NULL