yapp_erd
Tables (13)
ObservationAnimal (Untitled4)
- observation_animal_id (Key) — Long — Primary key — NOT NULL
- image (Field) — String — 이미지
- name (Field2) — String — 이름
- special_note (Field3) — Text — 특이사항
- shelter_id (Key2) — Long — Foreign key → Shelter.shelter_id — NOT NULL
ObservationAnimalTag (Untitled7)
- observation_animal_tag_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String — 공격성, 건강상태, 특이행동
ObservationAnimalTagMapping (Untitled6)
- observation_animal_tag_id (Key) — Long — Primary key — NOT NULL
- observation_animal_id (Key2) — Long — Foreign key → ObservationAnimal.observation_animal_id — NOT NULL
- observation_animal_tag_id (Key3) — Long — Foreign key → ObservationAnimalTag.observation_animal_tag_id — NOT NULL
Shelter (보호소)
- shelter_id (Key) — Long — Primary key — NOT NULL
- name (Field8) — String — 보호소명
- description (Field) — Text — 소개문구
- address (Field2) — String — 주소
- phone (Field3) — String — 연락처
- notice (Field4) — String — 유의사항
- parking (Field5) — Boolean — 주차가능여부
- account (Field6) — String — 계좌번호
- bank_name (Field11) — Enum — 은행명
- image (Field7) — String — 프로필이미지
- email (Field9) — String — 이메일
- donation_url (Field10) — String — 간편후원링크
Shelter_Outlink (Untitled5)
- url_id (Key) — Long — Primary key — NOT NULL
- type (Field) — Enum
- url (Field2) — String
- shelter_id (Key2) — Long — Foreign key → Shelter.shelter_id — NOT NULL
ShleterAdmin (CopyOf보호소)
- id (Key) — Long — Primary key — NOT NULL
- shelter_id (Key2) — Long — Foreign key → Shelter.shelter_id — NOT NULL
- user_id (Key3) — Long — Foreign key → User.user_id — NOT NULL
User (Untitled)
- user_id (Key) — Long — Primary key — NOT NULL
- email (Field3) — String — 이메일
- nickname (Field) — String — 닉네임
- phone (Field2) — String — 전화번호 -> unique
- oAuthType (Field4) — Enum — Google/Kakao
- is_deleted (Field5) — Boolean — 탈퇴여부
- created_at (Field6) — LocalDateTime — 생성날짜
- oauth_access_token (Field7) — String — 카카오 Access Token
- role (Field8) — Enum — 봉사자/보호소운영자
VolunteerEvent (Untitled2)
- volunteer_event_id (Key) — Long — Primary key — NOT NULL
- title (Field) — String — 제목
- recruit_num (Field2) — int — 모집인원수
- material (Field3) — Text — 준비물
- age_limit (Field4) — Enum — 나이제한 : 나이제한 없음/초등학생 이상/중학생 이상/ 고등학생 이상/ 성인 Only
- date (Field6) — LocalDate — 날짜
- view_cnt (Field9) — int — 조회수
- status (Field10) — Enum — 이벤트 상태 -> 진행중/종료/취소
- participant_num (Field5) — int — 참가인원
- created_at (Field7) — LocalDateTime — 등록시간
- update_at (Field8) — LocalDateTime — 수정시간
- shelter_id (Key2) — Long — Foreign key → Shelter.shelter_id — NOT NULL
- writer_id (Key3) — Long — Foreign key → User.user_id — NOT NULL — 작성자아이디
VolunteerEventActivityType (CopyOfUntitled7)
- volunteer_event_activity_type_id (Key) — Primary key — NOT NULL
- name (Field) — String — 활동유형 : 산책/청소/목욕/세탁/놀아주기/사료급여/사진촬영/기타
VolunteerEventActivityTypeMapping (CopyOfCopyOfUntitled7)
- volunteer_event_activity_type_mapping_id (Key) — Primary key — NOT NULL
- volunteer_event_activity_type_id (Key2) — Foreign key → VolunteerEventActivityType.volunteer_event_activity_type_id — NOT NULL
- volunteer_event_id (Key3) — Long — Foreign key → VolunteerEvent.volunteer_event_id — NOT NULL
VolunteerEventJoinQueue (CopyOfCopyOfCopyOfUntitled72)
- join_queue_id (Key) — Primary key — NOT NULL
- volunteer_event_id (Key2) — Long — Foreign key → VolunteerEvent.volunteer_event_id — NOT NULL
- user_id (Key3) — Long — Foreign key → User.user_id — NOT NULL
VolunteerEventMapping (Untitled3)
- volunteer_event_mapping_id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.user_id — NOT NULL
- volunteer_event_id (Key3) — Long — Foreign key → VolunteerEvent.volunteer_event_id — NOT NULL
VolunteerEventWaitingQueue (CopyOfCopyOfUntitled72)
- waiting_queue_id (Key) — Primary key — NOT NULL
- volunteer_event_id (Key2) — Long — Foreign key → VolunteerEvent.volunteer_event_id — NOT NULL
- user_id (Key3) — Long — Foreign key → User.user_id — NOT NULL