1 CREATE TABLE IF NOT EXISTS form_physical_exam (
2 forms_id bigint(20) NOT NULL,
3 line_id char(8) NOT NULL,
4 wnl tinyint(1) NOT NULL DEFAULT 0,
5 abn tinyint(1) NOT NULL DEFAULT 0,
6 diagnosis varchar(255) NOT NULL DEFAULT '',
7 comments varchar(255) NOT NULL DEFAULT '',
8 PRIMARY KEY (forms_id, line_id)
11 CREATE TABLE IF NOT EXISTS form_physical_exam_diagnoses (
12 line_id char(8) NOT NULL,
13 ordering int(11) NOT NULL DEFAULT 0,
14 diagnosis varchar(255) NOT NULL DEFAULT '',
15 KEY (line_id, ordering)