BE

Tables (4)

feed (게시물)

  • feed_id (피드아이디) — bigInt — Primary key — NOT NULL
  • city (시) — varchar
  • district (구)
  • neighborhood (동)
  • weather_status (날씨상태) — varchar
  • created_at (생성일자) — datetime
  • feed_image_url (피드이미지) — varchar
  • members_id (회원아이디) — uuid — Foreign key → member.member_id — NOT NULL

location (시/구/동)

  • location_id (위치아이디) — bigint — Primary key — NOT NULL
  • name (위치이름) — varchar
  • type (시/구/동) — varchar
  • parent_id (부모아이디) — int

member (회원)

  • member_id (회원아이디) — uuid — Primary key — NOT NULL
  • name (회원이름) — varchar
  • email (회원이메일) — varchar
  • social_id (소셜로그인 식별자) — varchar
  • profile_image_url (회원프로필이미지) — varchar
  • created_at (생성일자) — datetime
  • last_modified_at (최종수정일자) — datetime
  • is_deleted (탈퇴여부) — tinyInt

umbrella (우산대여소)

  • umbrella_id (우산대여소아이디) — bigint — Primary key — NOT NULL
  • name (대여소이름) — varchar
  • addr (대여소주소) — varchar
  • addr_detail (대여소상세주소) — varchar
  • zip_code (우편번호) — varchar
  • phone_number (대여소전화번호) — varchar
  • detail_info (대여소상세정보) — varchar
  • latitude (위도) — double
  • longitude (경도) — double