SOS V1

Tables (13)

Comment (댓글)

  • commentID (댓글ID) — BIGINT — Primary key — NOT NULL
  • eventId (사건ID) — BIGINT — Foreign key → Event.eventId — NOT NULL
  • memberId (회원ID) — BIGINT — Foreign key → Member.memberId — NOT NULL
  • comment (댓글) — TEXT

Default (Untitled)

  • created (생성날짜) — TIMESTAMP
  • updated (수정날짜) — TIMESTAMP
  • deleted (삭제날짜) — TIMESTAMP

Event (사건)

  • eventId (사건ID) — BIGINT — Primary key — NOT NULL
  • memberId (회원ID) — BIGINT — Foreign key → Member.memberId — NOT NULL
  • type (종류) — VARCHAR(10)
  • media (사진, 영상) — TEXT
  • title (제목) — VARCHAR(25)
  • content (내용) — TEXT
  • latitude (위도) — INT
  • longitude (경도) — INT
  • address (주소) — VARCHAR(255)
  • level (재난 단계) — VARCHAR(25)
  • likes (공감 갯수) — INT
  • comments (댓글 갯수) — INT

Favorite (관심사용자)

  • favoriteId (ID) — BIGINT — Primary key — NOT NULL
  • memberId (회원ID) — BIGINT — Foreign key → Member.memberId — NOT NULL
  • memberId (관심사용자ID) — BIGINT — Foreign key → Member.memberId — NOT NULL

Guideline (행동요령)

  • guidelineId (행동요령id) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR(20)
  • image (이미지) — TEXT
  • type (Field) — VARCHAR(10)

Keyword (키워드)

  • keywordId (키워드Id) — BIGINT — Primary key — NOT NULL
  • eventId (사건ID) — BIGINT — Foreign key → Event.eventId — NOT NULL
  • keyword (키워드) — VARCHAR(25)

Like (좋아요)

  • like_id (좋아요Id) — BIGINT — Primary key — NOT NULL
  • eventId (사건ID) — BIGINT — Foreign key → Event.eventId — NOT NULL
  • memberId (회원ID) — BIGINT — Foreign key → Member.memberId — NOT NULL

Member (회원)

  • memberId (회원ID) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(25)
  • password (비밀번호) — VARCHAR(20)
  • name (이름) — VARCHAR(10)
  • nickname (닉네임) — VARCHAR(20)

MemberDetail (회원 신체정보)

  • memberId (회원ID) — BIGINT — Foreign key → Member.memberId — NOT NULL
  • height (키) — INT
  • weight (몸무게) — INT
  • bloodtype (혈액형) — VARCHAR(5)
  • disease (질병) — TEXT
  • medication (복용약) — TEXT

Notification (알림)

  • notificationId (알림ID) — BIGINT — Primary key — NOT NULL
  • memberId (회원ID) — BIGINT — Foreign key → Member.memberId — NOT NULL
  • type (알림 타입) — VARCHAR(25)
  • isRead (읽음 상태) — BOOLEAN
  • referenceId (관련ID) — BIGINT
  • referenceTable (관련테이블) — VARCHAR(25)

Rescue (긴급 구조 요청)

  • Key (구조ID) — Primary key — NOT NULL
  • Field (구조 내용)
  • Field (위치)

Sub_Guideline (행동요령에 종속된 서브 행동요령)

  • subGuidelineId (서브행동요령id) — BIGINT — Primary key — NOT NULL
  • guidelineId (행동요령id2) — BIGINT — Foreign key → Guideline.guidelineId — NOT NULL
  • order (순서) — INT
  • title (소제목) — VARCHAR(45)
  • content (내용) — TEXT

User Notification (알림 설정)

  • notificationId (알림ID) — BIGINT — Primary key — NOT NULL
  • memberId (회원ID) — BIGINT — Foreign key → Member.memberId — NOT NULL
  • comment (댓글 알림) — BOOLEAN
  • loca (주변알림) — BOOLEAN
  • favorite_user (관심사용자알림) — BOOLEAN
  • national (국가 재난 알림) — BOOLEAN
  • help (도움 요청 알림) — BOOLEAN