dfd

Tables (13)

board (게시글)

  • board_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • category_id — INT — Foreign key → board_category.board_category_id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • content — VARCHAR(4000) — NOT NULL
  • like_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • address — VARCHAR(255)
  • delete_whether — CHAR(9) — NOT NULL

board_category (게시글 카테고리)

  • board_category_id — INT — Primary key — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

board_img (게시글 이미지)

  • board_img_id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → board.board_id — NOT NULL
  • path — VARCHAR(100) — NOT NULL
  • system_name — VARCHAR(300) — NOT NULL
  • origin_name — VARCHAR(255) — NOT NULL
  • main_whether — CHAR(1) — NOT NULL

body_record (신체기록)

  • body_record_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • date — DATE — NOT NULL
  • bodyCondition — VARCHAR(50) — NOT NULL
  • weight — DECIMAL(5,2) — NOT NULL
  • skeletal_muscle — DECIMAL(5,2)
  • content — VARCHAR(500) — NOT NULL
  • body_fat — INT
  • img — VARCHAR(330)

chat_history (채팅기록)

  • chat_history_id — INT — Primary key — NOT NULL
  • chat_room_id — INT — Foreign key → chat_room.chat_room_id — NOT NULL
  • send_user_id — INT — Foreign key → user.user_id — NOT NULL
  • message — VARCHAR(1000) — NOT NULL
  • send_date — TIMESTAMP — NOT NULL

chat_room (채팅방)

  • chat_room_id — INT — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • last_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

chat_room_user (채팅방 회원)

  • chat_room_user_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • chat_room_id — INT — Foreign key → chat_room.chat_room_id — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL

like (좋아요)

  • like_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • entity_type — VARCHAR(10) — NOT NULL
  • entity_id — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • delete_whether — CHAR(9) — NOT NULL

meal (식단)

  • meal_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • date — DATE — NOT NULL
  • type — CHAR(10) — NOT NULL
  • kcal — INT — NOT NULL
  • protein — INT
  • fat — INT
  • carbs — INT

meal_record (식단기록)

  • meal_record_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • date — DATE — NOT NULL
  • type — CHAR(6) — NOT NULL
  • img — VARCHAR(330)
  • meal_time — VARCHAR(20)
  • content — VARCHAR(500) — NOT NULL
  • fullness — VARCHAR(30) — NOT NULL

meal_streak (식단스트릭)

  • meal_streak_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • streak — INT — NOT NULL
  • morning — TINYINT(1)
  • lunch — TINYINT(1)
  • dinner — TINYINT(1)
  • date — TIMESTAMP — NOT NULL

reply (댓글)

  • reply_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • board_id — INT — Foreign key → board.board_id — NOT NULL
  • parent_reply_id — INT — Foreign key → reply.reply_id — NOT NULL
  • content — VARCHAR(1000)
  • depth — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user (회원)

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(320) — NOT NULL
  • password — VARCHAR(200) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • profile_url — VARCHAR(330)
  • phone — VARCHAR(13)
  • post_code — CHAR(5) — NOT NULL
  • parcel_address — VARCHAR(50) — NOT NULL
  • street_address — VARCHAR(100) — NOT NULL
  • detail_address — VARCHAR(100)
  • refresh_token — VARCHAR(600)
  • latitude — DECIMAL(9,6) — NOT NULL
  • longitude — DECIMAL(9,6) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TINYINT(1) — NOT NULL
  • role — VARCHAR(10) — NOT NULL