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