CREATE TABLE table_test_30 ("id" NUMBER, "ejection_fraction_ef" NUMBER, "multiple_long_bone_fractures" BOOLEAN, "extracellular_volume_expansion" BOOLEAN, "pregnancy_or_lactation" BOOLEAN, "bleeding" NUMBER, "serum_potassium" FLOAT, "prosthetic_heart_valve" BOOLEAN, "hbg" NUMBER, "anticoagulation" BOOLEAN, "incomplete_spinal_cord_injury" BOOLEAN, "complex_pelvic_fractures" BOOLEAN, "ascites" BOOLEAN, "gcs" NUMBER, "urine_output" NUMBER, "hyperkalemia" BOOLEAN, "head_injury" BOOLEAN, "operative_area" BOOLEAN, "trauma" BOOLEAN, "renal_disease" BOOLEAN, "metal_sensitivity" BOOLEAN, "para" BOOLEAN, "creatinine_clearance_cl" FLOAT, "mental_illness" BOOLEAN, "estimated_glomerular_filtration_rate_egfr" NUMBER, "pulmonary_rales" BOOLEAN, "edema" BOOLEAN, "platelet_count" FLOAT, "inadequate_tissue_coverage" BOOLEAN, "associated_long_bone_fractures" BOOLEAN, "pe" BOOLEAN, "long_term_anticoagulation" NUMBER, "pitting" BOOLEAN, "injury_patterns" BOOLEAN, "spinal_infection" BOOLEAN, "jugular_venous_distention" BOOLEAN, "serum_sodium_concentration" NUMBER, "previous_hemorrhagic_stroke" BOOLEAN, "orthopedic" BOOLEAN, "kidney_disease" BOOLEAN, "open_wounds" BOOLEAN, "quadriplegia" BOOLEAN, "chronic_warfarin_therapy" BOOLEAN, "chest_x_ray" BOOLEAN, "inflammation" BOOLEAN, "morbid_obesity" BOOLEAN, "iv_furosemide" NUMBER, "cardiomyopathy" BOOLEAN, "atrial_flutter" BOOLEAN, "alcohol_abuse" BOOLEAN, "aortic" BOOLEAN, "mitral" BOOLEAN, "atrial_fibrillation" BOOLEAN, "drug_abuse" BOOLEAN, "foreign_body_sensitivity" BOOLEAN, "venous_thromboembolic_disease" BOOLEAN, "chronic_anticoagulation" BOOLEAN, "myocardial_infarction" BOOLEAN, "dvt" BOOLEAN, "NOUSE" FLOAT)

patients with one or more of the following indications for chronic warfarin anticoagulation ( the patient may either be a new candidate for anticoagulation or may already be receiving warfarin ) : atrial fibrillation ( paroxysmal, persistent or permanent, not due to a reversible cause, documented by ecg ) or atrial flutter. a prosthetic heart valve in the aortic or mitral position that requires chronic anticoagulation. a history of venous thromboembolic disease ( dvt and / or pe ) requiring long term anticoagulation ( > 6 months ) . a history of myocardial infarction or cardiomyopathy requiring anticoagulation. currently receiving chronic warfarin therapy for another indication not listed, with sponsor approval.
SELECT * FROM table_test_30 WHERE (chronic_warfarin_therapy = 1 OR (anticoagulation = 1 OR chronic_warfarin_therapy = 1)) OR atrial_fibrillation = 1 OR atrial_flutter = 1 OR (prosthetic_heart_valve = 1 AND (aortic = 1 OR mitral = 1) AND chronic_anticoagulation = 1) OR (venous_thromboembolic_disease = 1 OR (dvt = 1 OR pe = 1) AND long_term_anticoagulation > 6) OR ((myocardial_infarction = 1 OR cardiomyopathy = 1) AND anticoagulation = 1) OR chronic_warfarin_therapy = 1
SELECT * FROM "table_test_30" WHERE "anticoagulation" = 1 OR "atrial_fibrillation" = 1 OR "atrial_flutter" = 1 OR "chronic_warfarin_therapy" = 1 OR (("aortic" = 1 OR "mitral" = 1) AND "chronic_anticoagulation" = 1 AND "prosthetic_heart_valve" = 1) OR (("dvt" = 1 OR "pe" = 1 OR "venous_thromboembolic_disease" = 1) AND "long_term_anticoagulation" > 6)