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