nutrisi
Tables (9)
faktor_aktivitas (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- kode (Field) — VARCHAR
- keterangan (Field2) — Varchar
- faktor_laki (Field3) — DECIMAL(10,2)
- faktor_perempuan (Field4) — DECIMAL
- status (Field5) — INTEGER
- sumber (Field6) — varchar
faktor_stres (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- kode (Field) — varchar
- keterangan (Field2) — varchar
- nilai (Field3) — Decimal
- sumber (Field4) — varchar
- status (Field5) — varchar
kategori_makanan (Untitled6)
kategori_umur (Untitled)
- id (Key) — int — Primary key — NOT NULL
- keterangan (Field2) — string — - balita - remaja - dewasa - lansia
- status (Field3) — int
kebutuhan_nutrisi (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- bmr (Field) — decimal
- total_energi (Field2) — DECIMAL
- kebutuhan_karbo (Field3) — Decimal
- kebutuhan_protein (Field4) — Decimal
- kebutuhan_lemak (Field5) — Decimal
- tanggal (Field6) — date
- status (Field7) — varchar
- Field8
nutrisi (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- kategori_umur_id (Key2) — int — Foreign key → kategori_umur.id — NOT NULL
- batas_minimal (Field) — string
- batas_maksimal (Field2) — string
- status (Field3) — int
- Key (Key22) — int — Foreign key → user.faktor_aktivitas_id — NOT NULL
- id (Key32) — int — Foreign key → user.faktor_stres_id — NOT NULL
- id (Key3) — id — Foreign key → user.id — NOT NULL
user (id)
- id (Key) — id — Primary key — NOT NULL
- faktor_aktivitas_id (Key2) — int — Foreign key → faktor_aktivitas.id — NOT NULL
- faktor_stres_id (Key3) — int — Foreign key → faktor_stres.id — NOT NULL
- nama (string) — string
- email — email
- password — string
- status (Field) — integer
- usia (Field2) — integer
- tanggal_lahir (Field3) — date
- berat_badan (Field4) — DECIMAL(10,2)
- tinggi_badan (Field5) — Decimal(10,2)
- jenis_kelamin (Field6) — varchar