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