SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE practices( practice_id Varchar(80), health_system_id Varchar(80), practice_activation_time_utc Date, variable_pricing_activation_time_utc Date, PRIMARY KEY(practice_id) ); INSERT INTO practices VALUES ('practice_1', 'hs_2434', DATE '2018-01-01', DATE '2019-01-01') ; INSERT INTO practices VALUES ('practice_2', 'hs_2434', DATE '2020-01-01', NULL) ; CREATE TABLE appointments( appointment_id Varchar(100), practice_id Varchar (80), created_at_utc Date, appointment_time_utc Date, is_new_patient Boolean, is_cancelled Boolean, PRIMARY KEY(appointment_id) ); INSERT INTO appointments VALUES ('apt_1', 'practice_1', DATE '2019-01-13', DATE '2019-01-28', 0, 0) ; INSERT INTO appointments VALUES ('apt_2', 'practice_1', DATE '2019-01-13', DATE '2019-01-29', 0, 0) ; INSERT INTO appointments VALUES ('apt_3', 'practice_1', DATE '2019-01-13', DATE '2019-01-28', 1, 1) ; INSERT INTO appointments VALUES ('apt_4', 'practice_2', DATE '2019-01-21', DATE '2019-01-28', 1, 0) ; CREATE TABLE spend_caps( spend_cap_id Varchar(80), practice_id Varchar(80), start_date Date, end_date Date, start_cap_amount Decimal (12,2), end_cap_amount Decimal (12,2), flag_new_cap_added Boolean, PRIMARY KEY(spend_cap_id) ); INSERT INTO spend_caps VALUES ('scap_234', 'practice_1010', DATE '2019-01-21', DATE '2019-02-01', '1200.00', '2500.00', 1) ; CREATE TABLE spend_locks( spend_lock_id Varchar(80), practice_id Varchar(80), start_date DATE, end_date DATE, PRIMARY KEY(spend_lock_id) ); INSERT INTO spend_locks VALUES ('null_spend_lock', 'practice_1010', DATE '2019-01-31', NULL) ;