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