C109 ERD
Tables (49)
BATCH_JOB_EXECUTION
- JOB_EXECUTION_ID — bigint — Primary key — NOT NULL
- VERSION — bigint
- JOB_INSTANCE_ID — bigint — Foreign key → BATCH_JOB_INSTANCE.JOB_INSTANCE_ID — NOT NULL
- CREATE_TIME — datetime(6) — NOT NULL
- START_TIME — datetime(6)
- END_TIME — datetime(6)
- STATUS — varchar(10)
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
BATCH_JOB_EXECUTION_CONTEXT
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
BATCH_JOB_EXECUTION_PARAMS
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- PARAMETER_NAME — varchar(100) — NOT NULL
- PARAMETER_TYPE — varchar(100) — NOT NULL
- PARAMETER_VALUE — varchar(2500)
- IDENTIFYING — char(1) — NOT NULL
BATCH_JOB_EXECUTION_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
BATCH_JOB_INSTANCE
- JOB_INSTANCE_ID — bigint — Primary key — NOT NULL
- VERSION — bigint
- JOB_NAME — varchar(100) — NOT NULL
- JOB_KEY — varchar(32) — NOT NULL
BATCH_JOB_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
BATCH_STEP_EXECUTION
- STEP_EXECUTION_ID — bigint — Primary key — NOT NULL
- VERSION — bigint — NOT NULL
- STEP_NAME — varchar(100) — NOT NULL
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- CREATE_TIME — datetime(6) — NOT NULL
- START_TIME — datetime(6)
- END_TIME — datetime(6)
- STATUS — varchar(10)
- COMMIT_COUNT — bigint
- READ_COUNT — bigint
- FILTER_COUNT — bigint
- WRITE_COUNT — bigint
- READ_SKIP_COUNT — bigint
- WRITE_SKIP_COUNT — bigint
- PROCESS_SKIP_COUNT — bigint
- ROLLBACK_COUNT — bigint
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
BATCH_STEP_EXECUTION_CONTEXT
- STEP_EXECUTION_ID — bigint — Foreign key → BATCH_STEP_EXECUTION.STEP_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
BATCH_STEP_EXECUTION_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
abandoned_dog
- id — bigint — Primary key — NOT NULL
- age — varchar(255)
- care_addr — varchar(1024)
- care_nm — varchar(255)
- care_owner_nm — varchar(255)
- care_reg_no — varchar(255)
- care_tel — varchar(255)
- color_cd — varchar(255)
- desertion_no — varchar(255) — NOT NULL
- happen_dt — varchar(255)
- happen_place — varchar(255)
- kind_cd — varchar(255)
- kind_nm — varchar(255)
- neuter_yn — varchar(255)
- notice_edt — varchar(255)
- notice_no — varchar(255)
- notice_sdt — varchar(255)
- org_nm — varchar(255)
- popfile1 — varchar(1024)
- popfile2 — varchar(1024)
- process_state — varchar(255)
- sex_cd — varchar(255)
- special_mark — varchar(2048)
- upd_tm — varchar(255)
- weight — varchar(255)
- shelter_id — bigint — Foreign key → shelter.id
- sigungu_org_cd — varchar(255) — Foreign key → sigungu.org_cd
adoption
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- process_status — enum('CANCELLED','COMPLETED','IN_PROGRESS') — NOT NULL
- rejection_reason — varchar(255)
- status — enum('APPROVED','REJECTED')
- updated_at — datetime(6)
- abandoned_dog_id — bigint — Foreign key → abandoned_dog.id — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- completed_at — datetime(6)
adoption_contract
- id — bigint — Primary key — NOT NULL
- contract_file_url — varchar(255) — NOT NULL
- file_size — bigint
- original_file_name — varchar(255) — NOT NULL
- uploaded_at — datetime(6) — NOT NULL
- step_instance_id — bigint — Foreign key → adoption_step_instance.id — NOT NULL
adoption_counseling
- id — bigint — Primary key — NOT NULL
- counseling_date — datetime(6) — NOT NULL
- status — enum('CANCELED','COMPLETED','SCHEDULED') — NOT NULL
- adoption_id — bigint — Foreign key → adoption.id — NOT NULL
adoption_document
- id — bigint — Foreign key → adoption_step_instance.id — NOT NULL
- description — varchar(255)
adoption_education_cert
- id — bigint — Foreign key → adoption_step_instance.id — NOT NULL
- certificate_file_url — varchar(255)
- certificate_number — varchar(255) — NOT NULL
- completion_date — datetime(6) — NOT NULL
- education_institution — varchar(255) — NOT NULL
adoption_step_def
- id — bigint — Primary key — NOT NULL
- description — text
- step_name — varchar(255) — NOT NULL
- step_order — int — NOT NULL
adoption_step_instance
- id — bigint — Primary key — NOT NULL
- approved_at — datetime(6)
- completed_at — datetime(6)
- rejection_reason — text
- status — enum('ACTIVE','APPROVED','CANCELLED','COMPLETED','NOT_STARTED','PENDING','REJECTED','SUBMITTED') — NOT NULL
- submitted_at — datetime(6)
- adoption_id — bigint — Foreign key → adoption.id — NOT NULL
- step_def_id — bigint — Foreign key → adoption_step_def.id — NOT NULL
adoption_survey
- id — bigint — Foreign key → adoption_step_instance.id — NOT NULL
- additional_questions — text
- address — varchar(255) — NOT NULL
- agrees_to_follow_up — bit(1) — NOT NULL
- agrees_to_lifetime_commitment — bit(1) — NOT NULL
- agrees_to_neutering — bit(1) — NOT NULL
- agrees_to_regular_updates — bit(1) — NOT NULL
- alone_time_management — text — NOT NULL
- cohabitant_agreement — bit(1) — NOT NULL
- number_of_adults — int
- number_of_children — int
- completed_owner_education — bit(1) — NOT NULL
- date_of_birth — date — NOT NULL
- detail_address — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- gender — enum('FEMALE','MALE','OTHER') — NOT NULL
- has_cohabitant — bit(1) — NOT NULL
- has_current_pets — bit(1) — NOT NULL
- has_past_pet_experience — bit(1) — NOT NULL
- is_owner — bit(1) — NOT NULL
- job — varchar(255) — NOT NULL
- life_change_coping_plan — text — NOT NULL
- marital_status — enum('DIVORCED','MARRIED','OTHER','SINGLE') — NOT NULL
- monthly_expense_range — enum('NOT_SURE','RANGE_0_5','RANGE_10_20','RANGE_20_UP','RANGE_5_10') — NOT NULL
- motivation_for_adoption — text — NOT NULL
- name — varchar(255) — NOT NULL
- pet_living_space_location — varchar(255) — NOT NULL
- pet_living_space_photo_url — varchar(255)
- pet_preference — enum('ADULT_DOG','ANY','PUPPY') — NOT NULL
- phone_number — varchar(255) — NOT NULL
- residence_type — enum('APARTMENT','MULTI_FAMILY_HOUSE','OTHER','SINGLE_FAMILY_HOUSE','STUDIO_APARTMENT') — NOT NULL
- travel_coping_plan — text — NOT NULL
- working_hours — varchar(255) — NOT NULL
adoption_survey_cohabitant_detail
- adoption_survey_id — bigint — Foreign key → adoption_survey.id — NOT NULL
- adoption_agreement — bit(1) — NOT NULL
- age — int — NOT NULL
- has_allergy — bit(1) — NOT NULL
- relationship — varchar(255) — NOT NULL
adoption_survey_current_pet_detail
- adoption_survey_id — bigint — Foreign key → adoption_survey.id — NOT NULL
- age — int
- breed — varchar(255) — NOT NULL
- count — int
- neutered — bit(1)
- pet_type — varchar(255) — NOT NULL
- reason_for_adopting_more — text
adoption_survey_emergency_contact
- adoption_survey_id — bigint — Foreign key → adoption_survey.id — NOT NULL
- contact_name — varchar(255) — NOT NULL
- contact_phone_number — varchar(255) — NOT NULL
- relationship — varchar(255) — NOT NULL
adoption_survey_past_pet_experience
- adoption_survey_id — bigint — Foreign key → adoption_survey.id — NOT NULL
- details — text
- duration — varchar(255) — NOT NULL
- is_currently_with_you — bit(1) — NOT NULL
- past_pet_count — int — NOT NULL
- past_pet_type — varchar(255) — NOT NULL
auth_user
- auth_user_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- oauth_id — varchar(255)
- provider — enum('GOOGLE','KAKAO','LOCAL','NAVER') — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
board_comment_likes
- id — bigint — Primary key — NOT NULL
- comment_id — bigint — Foreign key → board_comments.comment_id — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
board_comments
- comment_id — bigint — Primary key — NOT NULL
- content — tinytext — NOT NULL
- created_at — datetime(6) — NOT NULL
- deleted_at — datetime(6)
- updated_at — datetime(6) — NOT NULL
- board_id — bigint — Foreign key → boards.board_id — NOT NULL
- parent_comment_id — bigint — Foreign key → board_comments.comment_id
- user_id — bigint — Foreign key → users.user_id — NOT NULL
board_media
- board_media_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- sort_order — int — NOT NULL
- type — enum('IMAGE') — NOT NULL
- url — varchar(1000) — NOT NULL
- board_id — bigint — Foreign key → boards.board_id — NOT NULL
boards
- board_id — bigint — Primary key — NOT NULL
- category — enum('FREE','REVIEW') — NOT NULL
- content — tinytext — NOT NULL
- created_at — datetime(6) — NOT NULL
- deleted_at — datetime(6)
- title — varchar(100) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- view_count — int — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
checklist_item_instance
- id — bigint — Primary key — NOT NULL
- checked — bit(1) — NOT NULL
- item_text — varchar(255) — NOT NULL
- step_instance_id — bigint — Foreign key → post_adoption_step_instance.id — NOT NULL
dog_kind
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
dog_personality
- id — bigint — Primary key — NOT NULL
- activity — int — NOT NULL
- ai_observation — text
- barking — int — NOT NULL
- separation_anxiety — int — NOT NULL
- shedding_level — int — NOT NULL
- stranger_friendliness — int — NOT NULL
- abandoned_dog_id — bigint — Foreign key → abandoned_dog.id — NOT NULL
dog_recommendation_survey
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- fur_tolerance — enum('HIGH','LOW','MEDIUM','NOT_AT_ALL') — NOT NULL
- house_empty_time — enum('EIGHT_TO_TWELVE_HOURS','FOUR_TO_EIGHT_HOURS','MORE_THAN_TWELVE_HOURS','ONE_TO_FOUR_HOURS','RARELY') — NOT NULL
- residence_type — enum('APARTMENT','DETACHED_HOUSE','ETC','OFFICETEL','VILLA') — NOT NULL
- rest_activity_level — enum('ACTIVE','CALM','MODERATE','VERY_ACTIVE','VERY_CALM') — NOT NULL
- updated_at — datetime(6)
- visitor_frequency — enum('FREQUENTLY','OCCASIONALLY','RARELY','VERY_FREQUENTLY') — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
email_verification
- verification_id — bigint — Primary key — NOT NULL
- code — varchar(10) — NOT NULL
- created_at — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- expires_at — datetime(6) — NOT NULL
- purpose — varchar(20) — NOT NULL
- verified_at — datetime(6)
faq
- id — bigint — Primary key — NOT NULL
- answer — text — NOT NULL
- created_at — datetime(6)
- question — varchar(500) — NOT NULL
- updated_at — datetime(6)
post_adoption
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- process_status — enum('CANCELLED','COMPLETED','IN_PROGRESS') — NOT NULL
- updated_at — datetime(6)
- adoption_id — bigint — Foreign key → adoption.id — NOT NULL
post_adoption_checklist_def
- step_def_id — bigint — Foreign key → post_adoption_step_def.id — NOT NULL
- item_text — varchar(255) — NOT NULL
- required — bit(1)
post_adoption_checklist_instance
- step_instance_id — bigint — Foreign key → post_adoption_step_instance.id — NOT NULL
- checked — bit(1)
- item_text — varchar(255) — NOT NULL
post_adoption_step_def
- id — bigint — Primary key — NOT NULL
- default_order — int — NOT NULL
- description — text
- name — varchar(255) — NOT NULL
- days_after_adoption — bigint — NOT NULL
post_adoption_step_instance
- id — bigint — Primary key — NOT NULL
- completed_at — datetime(6)
- description — text
- rejection_reason — text
- status — enum('CANCELLED','COMPLETED','NOT_STARTED','PENDING','REJECTED','SUBMITTED') — NOT NULL
- step_name — varchar(255) — NOT NULL
- step_order — int — NOT NULL
- submitted_at — datetime(6)
- approver_id — bigint — Foreign key → users.user_id
- post_adoption_id — bigint — Foreign key → post_adoption.id — NOT NULL
- post_adoption_step_def_id — bigint — Foreign key → post_adoption_step_def.id
- due_date — date — NOT NULL
post_adoption_submission_def
- step_def_id — bigint — Foreign key → post_adoption_step_def.id — NOT NULL
- description — text
- required — bit(1)
- submission_name — varchar(255) — NOT NULL
- type — enum('DOCUMENT','IMAGE','OTHER','VIDEO') — NOT NULL
post_adoption_submission_instance
- step_instance_id — bigint — Foreign key → post_adoption_step_instance.id — NOT NULL
- description — text
- file_url — varchar(255)
- original_file_name — varchar(255)
- submission_name — varchar(255) — NOT NULL
- submitted — bit(1)
- type — enum('DOCUMENT','IMAGE','OTHER','VIDEO') — NOT NULL
post_adoption_video_calls
- id — bigint — Primary key — NOT NULL
- month — int — NOT NULL
- scheduled_date_time — datetime(6)
- status — enum('CANCELLED','COMPLETED','NOT_SCHEDULED','SCHEDULED') — NOT NULL
- post_adoption_id — bigint — Foreign key → post_adoption.id — NOT NULL
- completed_at — datetime(6)
- open_vidu_session_id — varchar(255)
post_care_session
- id — bigint — Primary key — NOT NULL
- recording_url — varchar(255)
- round — int — NOT NULL
- scheduled_at — datetime(6)
- session_id — varchar(255)
- status — varchar(20)
- adoption_id — bigint — Foreign key → adoption.id
shelter
- id — bigint — Primary key — NOT NULL
- address — varchar(255)
- care_nm — varchar(255) — NOT NULL
- shelter_reg_no — varchar(20)
- tel — varchar(255)
- user_id — bigint — Foreign key → users.user_id
sido
- org_cd — varchar(255) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
sigungu
- org_cd — varchar(255) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- sido_org_cd — varchar(255) — Foreign key → sido.org_cd
submission_instance
- id — bigint — Primary key — NOT NULL
- description — text
- file_url — varchar(255)
- original_file_name — varchar(255)
- submission_name — varchar(255) — NOT NULL
- submitted — bit(1) — NOT NULL
- type — enum('DOCUMENT','IMAGE','OTHER','VIDEO') — NOT NULL
- step_instance_id — bigint — Foreign key → post_adoption_step_instance.id — NOT NULL
uploaded_documents
- id — bigint — Primary key — NOT NULL
- document_type — enum('FAMILY_RELATIONSHIP_CERTIFICATE','INCOME_PROOF','LEASE_AGREEMENT','RESIDENT_REGISTRATION_COPY') — NOT NULL
- file_path — varchar(255) — NOT NULL
- file_size — bigint — NOT NULL
- original_file_name — varchar(255) — NOT NULL
- status — enum('APPROVED','PENDING','REJECTED') — NOT NULL
- upload_date — datetime(6) — NOT NULL
- adoption_document_id — bigint — Foreign key → adoption_document.id — NOT NULL
user_dog_interest
- user_dog_interest_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- abandoned_dog_id — bigint — Foreign key → abandoned_dog.id — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
users
- user_id — bigint — Primary key — NOT NULL
- address — varchar(255)
- created_at — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- is_email_verified — bit(1)
- name — varchar(100) — NOT NULL
- password — varchar(255)
- phone — varchar(30)
- updated_at — datetime(6) — NOT NULL
- user_type — enum('admin','adopter','shelter') — NOT NULL
- username — varchar(255)