v3

Tables (37)

action

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • room_seq — bigint — NOT NULL
  • prev_hash — bytea — NOT NULL
  • hash — bytea — NOT NULL
  • content_digest — bytea
  • actor_member_id — uuid — Foreign key → member.id
  • actor_side — varchar(10)
  • actor_key — varchar(80) — NOT NULL
  • type — varchar(40) — NOT NULL
  • idempotency_key — varchar(100) — NOT NULL
  • seen_version_no — int
  • reason — text
  • payload — jsonb
  • party_id — uuid — Foreign key → party.id
  • link_id — uuid — Foreign key → link.id
  • room_part_id — uuid — Foreign key → room_part.id
  • notice_id — uuid — Foreign key → notice.id
  • repair_case_id — uuid — Foreign key → repair_case.id
  • payment_id — uuid — Foreign key → payment.id
  • inspection_id — uuid — Foreign key → inspection.id
  • inspection_item_id — uuid — Foreign key → inspection_item.id
  • settlement_id — uuid — Foreign key → settlement.id
  • settlement_item_id — uuid — Foreign key → settlement_item.id
  • settlement_transfer_id — uuid — Foreign key → settlement_transfer.id
  • proposal_id — uuid — Foreign key → proposal.id
  • response_request_id — uuid — Foreign key → response_request.id
  • correction_request_id — uuid — Foreign key → correction_request.id
  • cause_note_id — uuid — Foreign key → cause_note.id
  • progress_note_id — uuid — Foreign key → progress_note.id
  • photo_id — uuid — Foreign key → photo.id
  • created_at — timestamptz — NOT NULL

cause_note

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • repair_case_id — uuid — Foreign key → cause_note.repair_case_id — NOT NULL
  • side — varchar(10) — NOT NULL
  • text — text — NOT NULL
  • basis — varchar(10) — NOT NULL
  • expert_name — varchar(50)
  • previous_id — uuid — Foreign key → cause_note.id
  • created_at — timestamptz — NOT NULL

correction_request

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • field — varchar(40) — Foreign key → correction_request.field — NOT NULL
  • new_value — jsonb — NOT NULL
  • base_version_id — uuid
  • repair_case_id — uuid — Foreign key → repair_case.id
  • payment_id — uuid — Foreign key → payment.id
  • inspection_item_id — uuid — Foreign key → inspection_item.id
  • settlement_transfer_id — uuid — Foreign key → settlement_transfer.id
  • target_key — varchar(80) — Foreign key → correction_request.target_key — NOT NULL
  • retry_of_id — uuid — Foreign key → correction_request.id
  • requested_by_side — varchar(10) — NOT NULL
  • reason — text
  • status — varchar(20) — NOT NULL
  • closed_reason — varchar(30)
  • closed_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

deletion_log

  • id — uuid — Primary key — NOT NULL
  • target_kind — varchar(40) — NOT NULL
  • target_id — uuid — NOT NULL
  • reason — varchar(30) — NOT NULL
  • phone_hmac — varchar(128)
  • chain_room_id — uuid
  • room_seq — bigint
  • prev_hash — bytea
  • action_hash — bytea
  • created_at — timestamptz — NOT NULL

in_app_notification

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id
  • member_id — uuid — Foreign key → member.id — NOT NULL
  • kind — varchar(10) — NOT NULL
  • response_request_id — uuid — Foreign key → response_request.id
  • target_kind — varchar(30)
  • target_id — uuid
  • group_key — varchar(120)
  • group_count — int
  • read_at — timestamptz
  • expires_at — timestamptz — NOT NULL
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

inspection

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • kind — varchar(10) — NOT NULL
  • author_side — varchar(10) — NOT NULL
  • status — varchar(10) — NOT NULL
  • late — boolean — NOT NULL
  • locked_at — timestamptz
  • lock_reason — varchar(20)
  • first_shown_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

inspection_item

  • id — uuid — Foreign key → inspection_item_version.inspection_item_id — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • inspection_id — uuid — Foreign key → inspection.id — NOT NULL
  • current_version_id — uuid — Foreign key → inspection_item_version.id — NOT NULL
  • confirmed_version_id — uuid
  • status — varchar(20) — NOT NULL
  • added_by_side — varchar(10) — NOT NULL
  • added_after_lock — boolean — NOT NULL
  • added_after_end — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

inspection_item_version

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • inspection_item_id — uuid — Foreign key → inspection_item_version.inspection_item_id — NOT NULL
  • no — int — NOT NULL
  • room_part_id — uuid — Foreign key → room_part.id — NOT NULL
  • description — text — NOT NULL
  • previous_id — uuid — Foreign key → inspection_item_version.id
  • created_at — timestamptz — NOT NULL

link

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • kind — varchar(20) — NOT NULL
  • party_id — uuid — Foreign key → party.id — NOT NULL
  • repair_case_id — uuid — Foreign key → repair_case.id
  • inspection_id — uuid — Foreign key → inspection.id
  • token_hash — varchar(128) — NOT NULL
  • issued_by_member_id — uuid — Foreign key → member.id — NOT NULL
  • invalidated_at — timestamptz
  • invalidated_reason — varchar(30)
  • failed_view_count — int — NOT NULL
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

member

  • id — uuid — Primary key — NOT NULL
  • email — varchar(320)
  • password_hash — varchar(255)
  • display_name — varchar(50)
  • phone — varchar(20)
  • phone_verified_at — timestamptz
  • sms_enabled — boolean — NOT NULL
  • status — varchar(10) — NOT NULL
  • withdrawn_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

member_acknowledgement

  • id — uuid — Primary key — NOT NULL
  • member_id — uuid — Foreign key → member.id — NOT NULL
  • kind — varchar(20) — NOT NULL
  • text_version — varchar(20) — NOT NULL
  • agreed_at — timestamptz — NOT NULL
  • created_at — timestamptz — NOT NULL

notice

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • response_request_id — uuid — Foreign key → response_request.id
  • link_id — uuid — Foreign key → link.id
  • recipient_party_id — uuid — Foreign key → party.id — NOT NULL
  • kind — varchar(20) — NOT NULL
  • channel — varchar(10) — NOT NULL
  • status — varchar(10) — NOT NULL
  • sent_at — timestamptz
  • delivered_at — timestamptz
  • viewed_at — timestamptz
  • failed_at — timestamptz
  • provider_message_id — varchar(100)
  • batch_lead_id — uuid — Foreign key → notice.id
  • next_poll_at — timestamptz
  • scheduled_for — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

outbox

  • id — uuid — Primary key — NOT NULL
  • kind — varchar(20) — NOT NULL
  • dedupe_key — varchar(300)
  • payload — jsonb — NOT NULL
  • status — varchar(10) — NOT NULL
  • attempts — int — NOT NULL
  • next_attempt_at — timestamptz — NOT NULL
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

part_template

  • id — uuid — Primary key — NOT NULL
  • zone — varchar(30) — NOT NULL
  • name — varchar(50) — NOT NULL
  • sort_order — int — NOT NULL
  • optional — boolean — NOT NULL

party

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • side — varchar(10) — NOT NULL
  • member_id — uuid — Foreign key → member.id
  • invite_phone — varchar(20)
  • status — varchar(20) — NOT NULL
  • connected_at — timestamptz
  • sharing_stopped_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

payment

  • id — uuid — Foreign key → payment_version.payment_id — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • repair_case_id — uuid — Foreign key → repair_case.id — NOT NULL
  • current_version_id — uuid — Foreign key → payment_version.id — NOT NULL
  • confirmed_version_id — uuid
  • confirm_strength — varchar(10) — NOT NULL
  • response — varchar(10) — NOT NULL
  • first_shown_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

payment_version

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • payment_id — uuid — Foreign key → payment_version.payment_id — NOT NULL
  • no — int — NOT NULL
  • payer_kind — varchar(20) — NOT NULL
  • payer_label — varchar(30)
  • payee_kind — varchar(20) — NOT NULL
  • payee_label — varchar(30)
  • amount — bigint — NOT NULL
  • paid_on — date — NOT NULL
  • recorded_by_side — varchar(10) — NOT NULL
  • evidence_kind — varchar(30)
  • previous_id — uuid — Foreign key → payment_version.id
  • created_at — timestamptz — NOT NULL

phone_verification

  • id — uuid — Primary key — NOT NULL
  • phone — varchar(20) — NOT NULL
  • purpose — varchar(10) — NOT NULL
  • code_hash — varchar(128) — NOT NULL
  • expires_at — timestamptz — NOT NULL
  • attempt_count — int — NOT NULL
  • verified_at — timestamptz
  • consumed_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

photo

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • repair_case_id — uuid — Foreign key → repair_case.id
  • inspection_item_id — uuid — Foreign key → inspection_item.id
  • inspection_id — uuid — Foreign key → inspection.id
  • payment_id — uuid — Foreign key → payment.id
  • cause_note_id — uuid — Foreign key → cause_note.id
  • settlement_item_id — uuid — Foreign key → settlement_item.id
  • progress_note_id — uuid — Foreign key → progress_note.id
  • correction_request_id — uuid — Foreign key → correction_request.id
  • redacted_from_photo_id — uuid — Foreign key → photo.id
  • room_part_id — uuid — Foreign key → room_part.id
  • stage — varchar(10) — NOT NULL
  • uploaded_by_side — varchar(10) — NOT NULL
  • device_taken_at — timestamptz
  • original_key — varchar(300) — NOT NULL
  • thumb_key — varchar(300) — NOT NULL
  • original_sha256 — varchar(64) — NOT NULL
  • thumb_sha256 — varchar(64) — NOT NULL
  • size_bytes — bigint — NOT NULL
  • sort_order — int — NOT NULL
  • created_at — timestamptz — NOT NULL

photo_visibility

  • photo_id — uuid — Foreign key → photo.id — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • hidden_on_link — boolean — NOT NULL
  • marked_wrong_at — timestamptz
  • erased_at — timestamptz
  • erase_reason — varchar(20)
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

progress_note

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • repair_case_id — uuid — Foreign key → response_request.repair_case_id — NOT NULL
  • side — varchar(10) — NOT NULL
  • text — text — NOT NULL
  • answers_request_id — uuid — Foreign key → response_request.id
  • asks_check — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL

progress_note_response

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • progress_note_id — uuid — Foreign key → progress_note.id — NOT NULL
  • side — varchar(10) — NOT NULL
  • answer — varchar(10) — NOT NULL
  • reason — text
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

proposal

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • repair_case_id — uuid — Foreign key → proposal.repair_case_id
  • settlement_item_id — uuid — Foreign key → proposal.settlement_item_id
  • settlement_id — uuid — Foreign key → proposal.settlement_id
  • proposed_by_side — varchar(10) — NOT NULL
  • counter_of_id — uuid — Foreign key → proposal.id
  • replaces_id — uuid — Foreign key → proposal.id
  • round — int — NOT NULL
  • no_cost — boolean — NOT NULL
  • exclude — boolean — NOT NULL
  • reason — text
  • created_at — timestamptz — NOT NULL

proposal_line

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • proposal_id — uuid — Foreign key → proposal.id — NOT NULL
  • line_kind — varchar(20) — NOT NULL
  • third_party_label — varchar(30)
  • amount — bigint — NOT NULL
  • created_at — timestamptz — NOT NULL

rate_counter

  • counter_key — varchar(200) — Primary key — NOT NULL
  • window_date — date — Primary key — NOT NULL
  • count — int — NOT NULL

refresh_token

  • id — uuid — Primary key — NOT NULL
  • member_id — uuid — Foreign key → member.id — NOT NULL
  • family_id — uuid — NOT NULL
  • token_hash — varchar(128) — NOT NULL
  • device_label — varchar(100)
  • expires_at — timestamptz — NOT NULL
  • revoked_at — timestamptz
  • replaced_by_id — uuid — Foreign key → refresh_token.id
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

region

  • code — char(10) — Primary key — NOT NULL
  • sido — varchar(20) — NOT NULL
  • sigungu — varchar(30)
  • dong — varchar(30) — NOT NULL
  • active — boolean — NOT NULL

repair_case

  • id — uuid — Foreign key → repair_content.repair_case_id — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • current_content_id — uuid — Foreign key → repair_content.id — NOT NULL
  • confirmed_content_id — uuid
  • status — varchar(20) — NOT NULL
  • closed_by — varchar(10)
  • defect_ack — varchar(20) — NOT NULL
  • money_status — varchar(20) — NOT NULL
  • current_proposal_id — uuid
  • agreed_proposal_id — uuid
  • previous_case_id — uuid — Foreign key → repair_case.id
  • created_by_side — varchar(10) — NOT NULL
  • solo — boolean — NOT NULL
  • first_shown_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

repair_content

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • repair_case_id — uuid — Foreign key → repair_content.repair_case_id — NOT NULL
  • no — int — NOT NULL
  • room_part_id — uuid — Foreign key → room_part.id — NOT NULL
  • title — varchar(100) — NOT NULL
  • description — text
  • previous_id — uuid — Foreign key → repair_content.id
  • created_by_side — varchar(10) — NOT NULL
  • created_at — timestamptz — NOT NULL

response_request

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • kind — varchar(30) — NOT NULL
  • repair_case_id — uuid — Foreign key → repair_case.id
  • payment_id — uuid — Foreign key → payment.id
  • settlement_item_id — uuid — Foreign key → settlement_item.id
  • settlement_id — uuid — Foreign key → settlement.id
  • inspection_id — uuid — Foreign key → inspection.id
  • inspection_item_id — uuid — Foreign key → inspection_item.id
  • settlement_transfer_id — uuid — Foreign key → settlement_transfer.id
  • progress_note_id — uuid — Foreign key → progress_note.id
  • requested_by_side — varchar(10) — NOT NULL
  • first_notified_at — timestamptz
  • renotify_due_at — timestamptz
  • unconfirmed_due_at — timestamptz
  • status — varchar(20) — NOT NULL
  • closed_reason — varchar(30)
  • closed_at — timestamptz
  • solo_reason — varchar(30)
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

room_part

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • template_id — uuid — Foreign key → part_template.id
  • zone — varchar(30) — NOT NULL
  • name — varchar(50) — NOT NULL
  • sort_order — int — NOT NULL
  • enabled — boolean — NOT NULL
  • hidden_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

room_record

  • id — uuid — Primary key — NOT NULL
  • region_code — char(10) — Foreign key → region.code — NOT NULL
  • alias — varchar(50) — NOT NULL
  • move_in_date — date
  • status — varchar(10) — NOT NULL
  • created_by_side — varchar(10) — NOT NULL
  • counterpart_first_connected_at — timestamptz
  • ended_at — timestamptz
  • settled_at — timestamptz
  • autoclose_due_at — timestamptz
  • delete_due_at — timestamptz
  • inactivity_notice_due_at — timestamptz
  • joined_into_id — uuid — Foreign key → room_record.id
  • joined_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

settlement

  • id — uuid — Foreign key → proposal.settlement_id — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • deposit_status — varchar(20) — NOT NULL
  • current_deposit_proposal_id — uuid — Foreign key → proposal.id
  • agreed_deposit_proposal_id — uuid
  • snapshot_no — int — NOT NULL
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

settlement_item

  • id — uuid — Foreign key → proposal.settlement_item_id — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • settlement_id — uuid — Foreign key → settlement.id — NOT NULL
  • source — varchar(10) — NOT NULL
  • repair_case_id — uuid — Foreign key → repair_case.id
  • room_part_id — uuid — Foreign key → room_part.id
  • category — varchar(30) — NOT NULL
  • status — varchar(10) — NOT NULL
  • current_proposal_id — uuid — Foreign key → proposal.id
  • agreed_proposal_id — uuid
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

settlement_transfer

  • id — uuid — Foreign key → settlement_transfer_version.settlement_transfer_id — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • settlement_id — uuid — Foreign key → settlement.id — NOT NULL
  • direction — varchar(10) — NOT NULL
  • current_version_id — uuid — Foreign key → settlement_transfer_version.id — NOT NULL
  • confirmed_version_id — uuid
  • recorded_by_side — varchar(10) — NOT NULL
  • response — varchar(10) — NOT NULL
  • same_as_transfer_id — uuid — Foreign key → settlement_transfer.id
  • receipt_confirmed_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • version — bigint — NOT NULL

settlement_transfer_version

  • id — uuid — Primary key — NOT NULL
  • room_record_id — uuid — Foreign key → room_record.id — NOT NULL
  • settlement_transfer_id — uuid — Foreign key → settlement_transfer_version.settlement_transfer_id — NOT NULL
  • no — int — NOT NULL
  • amount — bigint — NOT NULL
  • paid_on — date — NOT NULL
  • previous_id — uuid — Foreign key → settlement_transfer_version.id
  • created_at — timestamptz — NOT NULL

sms_opt_out

  • phone_hmac — varchar(128) — Primary key — NOT NULL
  • created_at — timestamptz — NOT NULL