ondo

Tables (13)

ChatRoomJoin (Untitled)

  • join_id (Key) — BIGINT(11) — Primary key — NOT NULL
  • room_id (채팅방ID) — BIGINT(11) — Foreign key → chat_room.room_id — NOT NULL
  • user_id (유저ID) — BIGINT(11) — Foreign key → user.user_id — NOT NULL

alarm (알람)

  • alarm_id (알람ID) — BIGINT(11) — Primary key — NOT NULL
  • user_id (유저ID) — BIGINT(11) — Foreign key → user.user_id — NOT NULL
  • content (내용) — VARCHAR(200)
  • time (시간) — DATETIME

challenge (도전)

  • challenge_id (도전ID) — BIGINT(11) — Primary key — NOT NULL
  • title (제목) — VARCHAR(20) — NOT NULL
  • content (내용) — VARCHAR(200) — NOT NULL
  • s_date (시작일) — DATETIME
  • image (이미지URL) — VARCHAR(50) — NOT NULL
  • owner (챌린지 생성자) — BIGINT(11)
  • category (카테고리 분류) — ENUM

challenge_participate (도전 참가)

  • participate_id (참가ID) — BIGINT(11) — Primary key — NOT NULL
  • challenge_id (도전ID) — BIGINT(11) — Foreign key → challenge.challenge_id — NOT NULL
  • user_id (유저ID) — BIGINT(11) — Foreign key → user.user_id — NOT NULL
  • achieved (달성 여부) — BOOLEAN

chat_room (채팅방)

  • room_id (채팅방ID) — BIGINT(11) — Primary key — NOT NULL

chatmessage (채팅)

  • message_id (채팅ID) — BIGINT(11) — Primary key — NOT NULL
  • user_id (유저ID) — BIGINT(11) — Foreign key → user.user_id — NOT NULL
  • room_id (채팅방ID) — BIGINT(11) — Foreign key → chat_room.room_id — NOT NULL
  • message (내용) — VARCHAR
  • time (작성시간) — DATETIME

comment (댓글)

  • comment_id (댓글ID) — BIGINT(11) — Primary key — NOT NULL
  • user_id (유저ID) — BIGINT(11) — Foreign key → user.user_id — NOT NULL
  • feed_id (피드ID) — BIGINT(11) — Foreign key → feed.feed_id — NOT NULL
  • content (내용) — VARCHAR

feed (피드)

  • feed_id (피드ID) — BIGINT(11) — Primary key — NOT NULL
  • challenge_id (챌린지ID) — BIGINIT(11)
  • image (이미지) — VARCHAR
  • content (내용) — VARCHAR(200)
  • user_id (작성자) — BIGINT(11)
  • date (인증일) — DATETIME

feedlike (피드_좋아요)

  • user_id (유저ID) — BIGINT(11) — Foreign key → user.user_id — NOT NULL
  • feed_id (피드ID) — BIGINT(11) — Foreign key → feed.feed_id — NOT NULL

feedtag (피드_태그)

  • feed_id (피드ID) — BIGINT(11) — Foreign key → feed.feed_id — NOT NULL
  • tag_id (태그ID) — BIGINT(11) — Foreign key → tag.tag_id — NOT NULL

follow (팔로우)

  • user_id (유저ID) — BIGINT(11) — Foreign key → user.user_id — NOT NULL
  • following_id (Field)

tag (태그)

  • tag_id (태그ID) — BIGINT(11) — Primary key — NOT NULL
  • name (태그명) — VARCHAR

user (회원)

  • user_id (유저ID) — BIGINT(11) — Primary key — NOT NULL
  • email (이메일) — VARCHAR
  • nickname (닉네임) — VARCHAR
  • password (비밀번호) — VARCHAR
  • ondo (온도) — NUM
  • role (역할) — ENUM
  • image (이미지) — VARCHAR