1 CREATE TABLE IF NOT EXISTS form_body_composition (
2 id bigint(20) NOT NULL auto_increment,
3 activity tinyint(1) NOT NULL DEFAULT 1, -- 0 if deleted
6 body_type enum('Standard', 'Athletic'),
7 height float(6,2) NOT NULL DEFAULT 0.00,
8 weight float(6,2) NOT NULL DEFAULT 0.00,
11 bmi float(6,2) NOT NULL DEFAULT 0.00,
12 bmr float(6,2) NOT NULL DEFAULT 0.00,
13 impedance float(6,2) NOT NULL DEFAULT 0.00,
14 fat_pct float(6,2) NOT NULL DEFAULT 0.00,
15 fat_mass float(6,2) NOT NULL DEFAULT 0.00,
16 bps float(6,2) NOT NULL DEFAULT 0.00,
17 bpd float(6,2) NOT NULL DEFAULT 0.00,
18 ffm float(6,2) NOT NULL DEFAULT 0.00,
19 tbw float(6,2) NOT NULL DEFAULT 0.00,
22 other text NOT NULL DEFAULT '',