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)