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

    log_makanan (Untitled7)

      makanan (Untitled8)

        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