k-paas

Tables (16)

adoption_apply

  • apply_id — BIGINT
  • notice_id — BIGINT — NOT NULL
  • applicant_id — BIGINT — NOT NULL
  • pet_id — BIGINT — NOT NULL
  • application_form — TEXT — NOT NULL — JSON 형태 신청서
  • applicant_message — TEXT
  • contact_phone — VARCHAR(15) — NOT NULL
  • apply_status — VARCHAR(20) — PENDING, APPROVED, REJECTED, COMPLETED
  • reviewer_id — BIGINT
  • review_notes — TEXT
  • interview_date — TIMESTAMP
  • adoption_date — TIMESTAMP
  • created_at — TIMESTAMP

adoption_history

  • history_id — BIGINT
  • pet_id — BIGINT — NOT NULL
  • previous_owner_id — BIGINT
  • new_owner_id — BIGINT — NOT NULL
  • apply_id — BIGINT — NOT NULL
  • adoption_date — TIMESTAMP — NOT NULL
  • return_date — TIMESTAMP
  • return_reason — TEXT
  • blockchain_hash — VARCHAR(66) — NOT NULL
  • did_transfer_hash — VARCHAR(66)
  • created_at — TIMESTAMP

adoption_notice

  • notice_id — BIGINT
  • pet_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • adoption_fee — INT
  • requirements — TEXT
  • notice_status — VARCHAR(20) — ACTIVE, RESERVED, COMPLETED
  • view_count — INT
  • created_at — TIMESTAMP

breed

  • breed_id — INT
  • animal_type — VARCHAR(20) — NOT NULL — 강아지, 고양이
  • breed_name — VARCHAR(50) — NOT NULL

chat_message

  • message_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • message_text — TEXT — NOT NULL
  • message_type — VARCHAR(20) — TEXT, IMAGE, FILE
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

chat_participant

  • participant_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • joined_at — TIMESTAMP
  • last_read_at — TIMESTAMP

chat_room

  • room_id — BIGINT
  • room_name — VARCHAR(100)
  • room_type — VARCHAR(20) — ADOPTION, GENERAL
  • pet_id — BIGINT
  • notice_id — BIGINT
  • room_status — VARCHAR(20)
  • created_at — TIMESTAMP

comment

  • comment_id — BIGINT
  • story_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • comment_text — TEXT — NOT NULL
  • created_at — TIMESTAMP

donation

  • donation_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • pet_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • target_amount — INT — NOT NULL
  • current_amount — INT
  • donation_category — VARCHAR(50) — NOT NULL — 의료비, 사료비, 시설비
  • region_id — INT
  • images — TEXT
  • donation_status — VARCHAR(20)
  • created_at — TIMESTAMP

donation_participate

  • participate_id — BIGINT
  • donation_id — BIGINT — NOT NULL
  • donor_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • donor_message — TEXT
  • created_at — TIMESTAMP

member

  • member_id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • age — INT — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(15) — NOT NULL
  • member_type — VARCHAR(20) — NOT NULL — SHELTER, OWNER
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP

pet

  • pet_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • shelter_id — BIGINT
  • pet_name — VARCHAR(50) — NOT NULL
  • animal_type — VARCHAR(20) — NOT NULL — 강아지, 고양이
  • breed_id — INT
  • age — INT
  • weight — DECIMAL(5, 2)
  • gender — VARCHAR(20) — NOT NULL
  • color — VARCHAR(100) — NOT NULL
  • main_image — VARCHAR(500) — NOT NULL
  • feature — TEXT — NOT NULL
  • health_status — VARCHAR(20) — NOT NULL
  • pet_status — VARCHAR(20) — AVAILABLE, ADOPTED, RESERVED
  • did_id — VARCHAR(255)
  • blockchain_hash — VARCHAR(66)
  • created_at — TIMESTAMP

region

  • region_id — INT
  • sido — VARCHAR(20) — NOT NULL
  • sigungu — VARCHAR(30) — NOT NULL
  • dong — VARCHAR(30)

shelter

  • shelter_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • center_name — VARCHAR(100) — NOT NULL
  • region_id — INT — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • capacity — INT
  • current_count — INT
  • latitude — DECIMAL(10, 8)
  • longitude — DECIMAL(11, 8)
  • created_at — TIMESTAMP

story

  • story_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • pet_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — VARCHAR(50) — NOT NULL — 일상, 입양후기
  • images — TEXT
  • hashtag — VARCHAR(500)
  • created_at — TIMESTAMP

story_like

  • like_id — BIGINT
  • story_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP