Open burrowse opened 9 years ago
Possible Visit Payer DDL (What I'm using in the test environment for now :) ):
create table visit_payer ( visit_payer_id SERIAL NOT NULL, visit_occurrence_id INTEGER NOT NULL, plan_name VARCHAR(100) NOT NULL, plan_type VARCHAR(100), plan_class VARCHAR(100), CONSTRAINT visit_payer_pkey PRIMARY KEY (visit_payer_id), CONSTRAINT visit_payer_nkey UNIQUE (visit_payer_id, visit_occurrence_id), CONSTRAINT visit_payer_fk FOREIGN KEY(visit_occurrence_id) REFERENCES chop_omop5.visit_occurrence (visit_occurrence_id) );
Possible Visit Payer DDL (What I'm using in the test environment for now :) ):
create table visit_payer ( visit_payer_id SERIAL NOT NULL, visit_occurrence_id INTEGER NOT NULL, plan_name VARCHAR(100) NOT NULL, plan_type VARCHAR(100), plan_class VARCHAR(100), CONSTRAINT visit_payer_pkey PRIMARY KEY (visit_payer_id), CONSTRAINT visit_payer_nkey UNIQUE (visit_payer_id, visit_occurrence_id), CONSTRAINT visit_payer_fk FOREIGN KEY(visit_occurrence_id) REFERENCES chop_omop5.visit_occurrence (visit_occurrence_id) );