공통프로젝트

테이블 (5)

Answer (answer)

  • surveyId — Int — 외래 키 → Survey.surveyId — NOT NULL
  • userId — int — 외래 키 → User.userId — NOT NULL
  • email — String — 외래 키 → Survey.email
  • emotions — String

Company (company)

  • email — String — 기본 키
  • password — String — NOT NULL
  • createdAt — Time — NOT NULL
  • companyId — Int — NOT NULL
  • surveyIds — Int*
  • companyName — String — NOT NULL

Kiosk (kiosk)

  • kioskId — Int — 기본 키 — NOT NULL
  • location — String
  • surveyIds — Int

Survey (survey)

  • surveyId — Int — 기본 키 — NOT NULL
  • email — String — 외래 키 → Company.email
  • kioskId — Int — 외래 키 → Kiosk.kioskId — NOT NULL
  • title — String
  • video — Video
  • description — String
  • createdAt — Time
  • expiresAt — Time
  • answers — Answer

User

  • userId — int — 기본 키 — NOT NULL
  • createdAt — Time
  • point — Int
  • age — Int
  • gender — String
  • phoneNum — Int — NOT NULL