safebell

Tables (5)

apply (신규 신청 요청)

  • phone (Key) — Foreign key → user.phone — NOT NULL

asset (등록된 비콘)

  • 비콘 ID (Key2) — Primary key — NOT NULL
  • phone (Key) — Foreign key → user.phone — NOT NULL

beaconRecord (신고 요청)

  • 신고 요청ID (Field) — Primary key
  • 비콘 ID (Key2) — Foreign key → asset.비콘 ID — NOT NULL
  • phone (Key) — Foreign key → asset.phone — NOT NULL
  • 신고 상태값 (Field2)
  • 위도 (Field3)
  • 경도 (Field4)
  • 값이 변경된 횟수 (Field5)

beaconRecordHistory (신고요청기록)

  • 비콘 ID (Key2) — Foreign key → beaconRecord.비콘 ID — NOT NULL
  • phone (Key) — Foreign key → beaconRecord.phone — NOT NULL
  • 신고 요청ID (Field) — Foreign key → beaconRecord.신고 요청ID

user (신청자)

  • phone (Key) — Primary key — NOT NULL