name			= gastroent_patient_aufnahme
description		= Gastroenterologie : Patient bei Aufnahme
explanation		= ?
fields			= instituts_nr,aufn_nr,pg1sf,pg1sk,pg1bsa,pg1sbr,pg1sst,pg1sss,pg1sve,pg1sdr,pg1sdu,pg1sbo,pg1kr2,pg1kr3,pg1kr4,pg1kr5,pg1b1,pg1b2,pg1b3,pg1b4,pg1b5,pg1b6,pg1b7,pg1b8,pg1b9,

create_instituts_nr	= Integer NotNull
create_aufn_nr		= Integer NotNull

create_pg1sf = Byte
create_pg1sk = Byte
create_pg1bsa = Byte
create_pg1sbr = Byte
create_pg1sst = Byte
create_pg1sss = Byte
create_pg1sve = Byte
create_pg1sdr = Byte
create_pg1sdu = Byte
create_pg1sbo = Byte
create_pg1kr2 = Byte
create_pg1kr3 = Byte
create_pg1kr4 = Byte
create_pg1kr5 = Byte
create_pg1b1 = Byte
create_pg1b2 = Byte
create_pg1b3 = Byte
create_pg1b4 = Byte
create_pg1b5 = Byte
create_pg1b6 = Byte
create_pg1b7 = Byte
create_pg1b8 = Byte
create_pg1b9 = Byte

create_primary_key	= CONSTRAINT pk_gastroent_patient_aufnahme PRIMARY KEY (instituts_nr,aufn_nr)
