sf
Tables (7)
agency
- agency_no — BIGSERIAL — Primary key — NOT NULL
- agency_type — VARCHAR(20) — NOT NULL
- agency_name — VARCHAR(200) — NOT NULL
- region_code — VARCHAR(20)
- created_at — TIMESTAMPTZ
app_user
- user_no — BIGSERIAL — Primary key — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- pw — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE
- addr — VARCHAR(300)
- phone — VARCHAR(20)
- created_date — TIMESTAMPTZ
- role — VARCHAR(20) — NOT NULL
- agency_no — BIGINT — Foreign key
complaint
- complaint_no — BIGSERIAL — Primary key — NOT NULL
- category — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- address — VARCHAR(300)
- latitude — DOUBLE
- longitude — DOUBLE
- image_path — VARCHAR(500)
- analysis_result — JSONB
- status — VARCHAR(20) — NOT NULL
- is_public — BOOLEAN — NOT NULL
- created_date — TIMESTAMPTZ — NOT NULL
- updated_date — TIMESTAMPTZ
- completed_date — TIMESTAMPTZ
- user_no — BIGINT — Foreign key — NOT NULL
- like_count — INTEGER
- answer — TEXT
complaint_agency
- complaint_no — BIGINT — Foreign key — NOT NULL
- agency_no — BIGINT — Foreign key — NOT NULL
complaint_like
- like_id — BIGSERIAL — Primary key — NOT NULL
- complaint_no — BIGINT — Foreign key — NOT NULL
- user_no — BIGINT — Foreign key — NOT NULL
- created_at — TIMESTAMPTZ
- type — VARCHAR(10) — NOT NULL
- UNIQUE(complaint_no, — user_no)
error_logs
- Key (log_id) — BIGSERIAL — Primary key — NOT NULL
- trace_id — VARCHAR(100)
- endpoint — VARCHAR(200)
- http_method — VARCHAR(10)
- client_ip — VARCHAR(50)
- user_id — VARCHAR(50)
- error_code — VARCHAR(50)
- error_message — TEXT
- stack_trace — TEXT
- timestamp — TIMESTAMPTZ
spatial_feature
- feature_id — BIGSERIAL — Primary key — NOT NULL
- feature_type — VARCHAR(20)
- geom — GEOMETRY(Geometry, 4326)
- addr_text — VARCHAR(300)
- complaint_no — BIGINT — Foreign key
- created_at — TIMESTAMPTZ