Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS service_requests_test
- (
- id Int32,
- guid String,
- requisition String,
- patient_id Int32,
- category_code String,
- ehealth_inserted_at DateTime,
- ehealth_updated_at DateTime,
- created_at DateTime,
- STATUS String,
- program_processing_status String,
- ehr_direction_program_id Int32,
- service_requestable_type String,
- service_requestable_id Int32,
- used_employee_id Int32,
- used_division_id Int32,
- used_legal_entity_id Int32,
- completable_type String,
- completable_id Int32,
- contextable_id Int32,
- priority Int32,
- speciality_type_value String
- ) ENGINE = MergeTree()
- ORDER BY id;
- INSERT INTO service_requests (id,
- guid,
- requisition,
- patient_id,
- category_code,
- ehealth_inserted_at,
- ehealth_updated_at,
- created_at,
- STATUS,
- program_processing_status,
- ehr_direction_program_id,
- service_requestable_type,
- service_requestable_id,
- used_employee_id,
- used_division_id,
- used_legal_entity_id,
- completable_type,
- completable_id,
- contextable_id,
- priority,
- speciality_type_value)
- SELECT id,
- guid,
- requisition,
- patient_id,
- category_code,
- ehealth_inserted_at,
- ehealth_updated_at,
- created_at,
- STATUS,
- program_processing_status,
- ehr_direction_program_id,
- service_requestable_type,
- service_requestable_id,
- used_employee_id,
- used_division_id,
- used_legal_entity_id,
- completable_type,
- completable_id,
- contextable_id,
- priority,
- speciality_type_value
- FROM
- postgresql('p-devk4.h24.ua:5432', 'h24ua-stage', 'ehr_direction_service_requests', 'user', 'password');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement