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