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)