SCC ERD

Tables (4)

Info (데이터 목록)

  • id — Long — Primary key — NOT NULL
  • name — String
  • isFirstFloor — boolean
  • floors — int
  • highLevel — enum
  • stairInfo — enum
  • hasSlope — boolean
  • entranceDoorType — enum
  • createdAt — LocalDateTime
  • status — enum
  • comment — String
  • previousInfo — AdjacentInfoDTO
  • nextInfo — AdjacentInfoDTO

activities (센서 데이터)

  • id — String — Primary key — NOT NULL
  • timestamp — Date
  • userId — String
  • x — double
  • y — double
  • z — double
  • ax — double
  • ay — double
  • az — double
  • isOnStairs — boolean
  • Field

member (Untitled3)

  • id — Long — Primary key — NOT NULL
  • Role — enum
  • name — String
  • login_id — String
  • password — String
  • approved_by (Field)
  • approved_by (Key2) — Long — Foreign key → member.id — NOT NULL
  • Field2

photo (사진)

  • id — Long — Primary key — NOT NULL
  • status (photo_status) — ststus — Primary key
  • info_id (id2) — Long — Foreign key → Info.id — NOT NULL
  • url (photo_url) — String
  • analysisResult (photo_analysis_result) — enum
  • Field