Spaces:

LearningnRunning
/

nurse-handover-simulator

Sleeping

nurse-handover-simulator / remove_strict_fk.sql

feat: Add SQL scripts for complete database reset and initialization, including table and function definitions for sessions, chat history, handoff records, and sbar drafts. Implement foreign key constraints and triggers for automatic session management and updated timestamps.

2f230ab about 1 month ago

raw

history blame contribute delete

678 Bytes

	-- =====================================================
	-- 기존 테이블 및 제약조건 모두 삭제 (새로 시작)
	-- =====================================================

	-- 순서대로 CASCADE 삭제
	DROP TABLE IF EXISTS sessions CASCADE;
	DROP TABLE IF EXISTS sbar_drafts CASCADE;
	DROP TABLE IF EXISTS chat_history CASCADE;
	DROP TABLE IF EXISTS handoff_records CASCADE;
	DROP TABLE IF EXISTS scenarios CASCADE;
	DROP TABLE IF EXISTS patients CASCADE;

	-- 함수도 삭제 (나중에 재생성)
	DROP FUNCTION IF EXISTS update_updated_at_column() CASCADE;
	DROP FUNCTION IF EXISTS update_session_ended_at() CASCADE;
	DROP FUNCTION IF EXISTS auto_create_session() CASCADE;