diff options
| author | joonhoekim <26rote@gmail.com> | 2025-10-10 11:45:48 +0900 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-10-10 11:45:48 +0900 |
| commit | fed3dc0349be8faa5a94048e2ce2d96e432bf734 (patch) | |
| tree | 1c81e9b2e98d9869225a2897fd2a0d2c9398a556 /db/migrations_backup/0057_fancy_serpent_society.sql | |
| parent | 631b09172b48ec24c4f0131bc97017b87ddf0c47 (diff) | |
(김준회) chore: migrations_backup 경로 제거
Diffstat (limited to 'db/migrations_backup/0057_fancy_serpent_society.sql')
| -rw-r--r-- | db/migrations_backup/0057_fancy_serpent_society.sql | 29 |
1 files changed, 0 insertions, 29 deletions
diff --git a/db/migrations_backup/0057_fancy_serpent_society.sql b/db/migrations_backup/0057_fancy_serpent_society.sql deleted file mode 100644 index 780d023b..00000000 --- a/db/migrations_backup/0057_fancy_serpent_society.sql +++ /dev/null @@ -1,29 +0,0 @@ -DROP VIEW "public"."document_stages_view";--> statement-breakpoint -CREATE VIEW "public"."document_stages_view" AS ( - SELECT - d.id AS document_id, - d.doc_number, - d.title, - d.status, - d.issued_date, - d.contract_id, - - ( - SELECT COUNT(*) - FROM issue_stages - WHERE document_id = d.id - ) AS stage_count, - - COALESCE( - ( - SELECT json_agg(i.stage_name) - FROM issue_stages i - WHERE i.document_id = d.id - ), - '[]' - ) AS stage_list, - - d.created_at, - d.updated_at - FROM documents d -);
\ No newline at end of file |