Files
his/sql/迁移记录-DB变更记录/202511201516 alter_table tmp_encounter_auto_roll.sql

8 lines
454 B
SQL

ALTER TABLE tmp_encounter_auto_roll ADD practitioner_id int8 NULL;
COMMENT ON COLUMN tmp_encounter_auto_roll.practitioner_id IS '参与者id';
ALTER TABLE tmp_encounter_auto_roll ADD organization_id int8 NULL;
COMMENT ON COLUMN tmp_encounter_auto_roll.organization_id IS '参与者科室id';
-- Insert migration record
INSERT INTO __MigrationsHistory (MigrationId, ProductVersion)
VALUES ('202511201516 alter_table tmp_encounter_auto_roll', '1.0.0');