clns-acuity-flyway/src/main/resources/flyway/release-7.0-helium/migrations/V1601914009__create_tables_and_sequences.sql [1722:1775]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    paes_id character varying(32),
    paes_ae_id character varying(32),
    paes_dataset_id numeric(20,0) NOT NULL,
    paes_dataset character varying(100) NOT NULL,
    paes_pat_id character varying(32),
    paes_pat_part character varying(255),
    paes_pat_subject character varying(255),
    paes_pat_centre bigint,
    paes_pat_dth_date timestamp without time zone,
    paes_study character varying(255),
    paes_evt_id character varying(32),
    paes_evt_pt character varying(255),
    paes_evt_hlt character varying(255),
    paes_evt_llt character varying(255),
    paes_evt_soc character varying(255),
    paes_text character varying(255),
    paes_comment character varying(255),
    paes_action_taken_primary character varying(4000),
    paes_custom character varying(100),
    paes_serious character varying(255),
    paes_causality character varying(4000),
    paes_max_ctc character varying(255),
    paes_webapp_max_ctc character varying(255),
    paes_num_max_ctc bigint,
    paes_start_date timestamp without time zone,
    paes_end_date timestamp without time zone,
    paes_days_since_first_dose numeric,
    paes_week numeric,
    paes_week2 numeric,
    paes_week3 numeric,
    paes_week4 numeric,
    paes_start_day numeric,
    paes_end_day numeric,
    paes_days_since_randomisation numeric,
    paes_week_since_randomisation numeric,
    paes_end_day_from_rand numeric,
    paes_start_day_from_rand numeric,
    paes_duration numeric,
    paes_dose_at_start numeric,
    paes_ongoing character(1),
    paes_start_prior_to_rand character varying(3),
    paes_end_prior_to_rand character varying(3),
    paes_outcome character varying(255),
    paes_dose_limiting_toxicity character varying(31),
    paes_time_point character varying(255),
    paes_immune_mediated character varying(255),
    paes_infusion_reaction character varying(255),
    paes_required_treatment character varying(31),
    paes_caused_subject_withdrawal character varying(255),
    paes_suspected_endpoint character varying(255),
    paes_suspected_endpoint_cat character varying(255),
    paes_ae_number numeric,
    paes_ae_of_special_interest character varying(255)
);
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



clns-acuity-flyway/src/main/resources/flyway/release-7.0-helium/migrations/V1601914009__create_tables_and_sequences.sql [1778:1831]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    paes_id character varying(32),
    paes_ae_id character varying(32),
    paes_dataset_id numeric(20,0) NOT NULL,
    paes_dataset character varying(100) NOT NULL,
    paes_pat_id character varying(32),
    paes_pat_part character varying(255),
    paes_pat_subject character varying(255),
    paes_pat_centre bigint,
    paes_pat_dth_date timestamp without time zone,
    paes_study character varying(255),
    paes_evt_id character varying(32),
    paes_evt_pt character varying(255),
    paes_evt_hlt character varying(255),
    paes_evt_llt character varying(255),
    paes_evt_soc character varying(255),
    paes_text character varying(255),
    paes_comment character varying(255),
    paes_action_taken_primary character varying(4000),
    paes_custom character varying(100),
    paes_serious character varying(255),
    paes_causality character varying(4000),
    paes_max_ctc character varying(255),
    paes_webapp_max_ctc character varying(255),
    paes_num_max_ctc bigint,
    paes_start_date timestamp without time zone,
    paes_end_date timestamp without time zone,
    paes_days_since_first_dose numeric,
    paes_week numeric,
    paes_week2 numeric,
    paes_week3 numeric,
    paes_week4 numeric,
    paes_start_day numeric,
    paes_end_day numeric,
    paes_days_since_randomisation numeric,
    paes_week_since_randomisation numeric,
    paes_end_day_from_rand numeric,
    paes_start_day_from_rand numeric,
    paes_duration numeric,
    paes_dose_at_start numeric,
    paes_ongoing character(1),
    paes_start_prior_to_rand character varying(3),
    paes_end_prior_to_rand character varying(3),
    paes_outcome character varying(255),
    paes_dose_limiting_toxicity character varying(31),
    paes_time_point character varying(255),
    paes_immune_mediated character varying(255),
    paes_infusion_reaction character varying(255),
    paes_required_treatment character varying(31),
    paes_caused_subject_withdrawal character varying(255),
    paes_suspected_endpoint character varying(255),
    paes_suspected_endpoint_cat character varying(255),
    paes_ae_number numeric,
    paes_ae_of_special_interest character varying(255)
);
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



