univ_79_22
Tables (8)
checklist_form_instances
- id — BIGSERIAL
- form_def_id — BIGINT — NOT NULL
- record_id — BIGINT
- voice_note_id — BIGINT
- created_at — TIMESTAMPTZ — NOT NULL
checklist_forms_def
- id — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
- version — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- description — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(name, — version)
checklist_item_defs
- id — BIGSERIAL
- form_def_id — BIGINT — NOT NULL
- item_key — VARCHAR(100) — NOT NULL
- label — VARCHAR(200) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- value_type — VARCHAR(20) — NOT NULL
- required — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- UNIQUE(form_def_id, — item_key)
listings
- id — BIGSERIAL
- sgg_cd — VARCHAR(200)
- umd_nm — VARCHAR(200)
- apt_nm — VARCHAR(50)
- jibun — VARCHAR(100)
- exclu_use_ar — INT
- deposit — INT
- monthly_rent — INT
- floor — INT
- build_year — INT
- contract_term — INT
- contract_type — VARCHAR(30)
- use_rr_right — VARCHAR(30)
- pre_deposit — INT
- pre_monthly_rent — INT
record_checklist_items
- id — BIGSERIAL
- form_instance_id — BIGINT — NOT NULL
- item_def_id — BIGINT — NOT NULL
- value_type — VARCHAR(20) — NOT NULL
- bool_value — BOOLEAN
- scale_value — SMALLINT
- text_value — TEXT
- number_value — NUMERIC(12,2)
- status — VARCHAR(20)
- note — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(form_instance_id, — item_def_id)
user_records
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- listing_id — BIGINT
- title — VARCHAR(200)
- notes — TEXT
- category — VARCHAR(200)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGSERIAL
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
voice_notes
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- record_id — BIGINT
- audio_url — TEXT — NOT NULL
- duration_sec — INT
- transcript — TEXT
- summary — TEXT
- created_at — TIMESTAMPTZ — NOT NULL