You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
1.0 KiB
25 lines
1.0 KiB
CREATE TABLE IF NOT EXISTS form_body_composition ( |
|
id bigint(20) NOT NULL auto_increment, |
|
activity tinyint(1) NOT NULL DEFAULT 1, -- 0 if deleted |
|
|
|
-- external |
|
body_type enum('Standard', 'Athletic'), |
|
height float(6,2) NOT NULL DEFAULT 0.00, |
|
weight float(6,2) NOT NULL DEFAULT 0.00, |
|
|
|
-- body composition |
|
bmi float(6,2) NOT NULL DEFAULT 0.00, |
|
bmr float(6,2) NOT NULL DEFAULT 0.00, |
|
impedance float(6,2) NOT NULL DEFAULT 0.00, |
|
fat_pct float(6,2) NOT NULL DEFAULT 0.00, |
|
fat_mass float(6,2) NOT NULL DEFAULT 0.00, |
|
bps float(6,2) NOT NULL DEFAULT 0.00, |
|
bpd float(6,2) NOT NULL DEFAULT 0.00, |
|
ffm float(6,2) NOT NULL DEFAULT 0.00, |
|
tbw float(6,2) NOT NULL DEFAULT 0.00, |
|
|
|
-- other |
|
other text, |
|
|
|
PRIMARY KEY (id) |
|
) ENGINE=InnoDB;
|
|
|