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