Sometimes
Tables (8)
ALLOW_TABLE (접근 허용)
- ID (allow_id) — Primary key — NOT NULL
- REQUEST_USER_ID (requestUser_id)
- TARGET_USER_ID (targetUser_id)
- STATUS (status)
- IS_ALLOWED (is_allowed)
Chatitem (채팅메시지)
- ID (chatitem_id) — Primary key — NOT NULL
- MESSAGE (message)
- SENDERID (sender_id)
- CHATROOMID (chatroom_id)
- ACTION (action)
Chatroom (채팅)
- ID (chatroom_id) — Primary key — NOT NULL
- PARTICIPANT1 (participant1)
- PARTICIPANT2 (participant2)
LIKE (찜)
- ID (user_id) — Primary key — NOT NULL
- likedID (likeduser_id) — 나를 찜한 사람
- likeID (likeuser_id) — 내가 찜한 사람
Location (위치)
- ID (location_id) — Primary key — NOT NULL
- X (x)
- Y (y)
- USERID (user_id)
NOTIFICATION (알림)
- ID (notification_id) — Primary key — NOT NULL
- RECEIVER_ID (receiver_id)
- SENDER_ID (sender_id)
- MESSAGE (message)
- TYPE (type)
QUESTION (각 단계 정보)
- ID (question_id) — Primary key — NOT NULL
- KIND (kind)
- DESCRIPTION (description)
- TYPE (type)
- IS_REQUIRED (isRequired)
- USER_ID (user_id)
User (사용자)
- ID (user_id) — Primary key — NOT NULL
- NAME (name)
- DESCRIPTION (descripttion)
- PROFILEIMG (profilePath)
- GENDER (gender)