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