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