diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-04 09:39:21 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-04 09:39:21 +0000 |
| commit | 53ad72732f781e6c6d5ddb3776ea47aec010af8e (patch) | |
| tree | e676287827f8634be767a674b8ad08b6ed7eb3e6 /db/migrations/0254_jittery_omega_flight.sql | |
| parent | 3e4d15271322397764601dee09441af8a5b3adf5 (diff) | |
(최겸) PQ/실사 수정 및 개발
Diffstat (limited to 'db/migrations/0254_jittery_omega_flight.sql')
| -rw-r--r-- | db/migrations/0254_jittery_omega_flight.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/db/migrations/0254_jittery_omega_flight.sql b/db/migrations/0254_jittery_omega_flight.sql new file mode 100644 index 00000000..02328a95 --- /dev/null +++ b/db/migrations/0254_jittery_omega_flight.sql @@ -0,0 +1,11 @@ +CREATE VIEW "public"."legal_works_detail_view" AS (select "legal_works"."id", "legal_works"."category", "legal_works"."status", "legal_works"."company_id", "legal_works"."vendor_code", "legal_works"."vendor_name", "legal_works"."is_urgent", "legal_works"."request_date", "legal_works"."consultation_date", "legal_works"."expected_answer_date", "legal_works"."legal_completion_date", "legal_works"."reviewer", "legal_works"."legal_responder", "legal_works"."has_attachment", "legal_works"."created_at", "legal_works"."updated_at", "legal_work_requests"."review_department", "legal_work_requests"."inquiry_type", "legal_work_requests"."title", "legal_work_requests"."request_content", "legal_work_requests"."is_public", "legal_work_requests"."contract_project_name", "legal_work_requests"."contract_type", "legal_work_requests"."contract_amount", ( + SELECT response_content + FROM legal_work_responses lwr_latest + WHERE lwr_latest.legal_work_id = "legal_works"."id" + ORDER BY lwr_latest.created_at DESC + LIMIT 1 + ) as "response_content", ( + SELECT COUNT(*)::integer + FROM legal_work_attachments lwa + WHERE lwa.legal_work_id = "legal_works"."id" + ) as "attachment_count" from "legal_works" left join "legal_work_requests" on "legal_works"."id" = "legal_work_requests"."legal_work_id" left join "vendors" on "legal_works"."company_id" = "vendors"."id");
\ No newline at end of file |