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