HEAL21

Tables (9)

Comment (Untitled7)

    Competition (Untitled2)

    • Compid (Key3) — Primary key — NOT NULL
    • Key — Foreign key → User.Key — NOT NULL
    • Key (Key2) — Foreign key → Copy Of User.Key — NOT NULL
    • user1pt (Field) — int64 — NOT NULL
    • user2pt (Field2) — int64 — NOT NULL
    • createddt (Field3) — date — NOT NULL
    • enddt (Field4) — date — NOT NULL
    • state (Field5) — NOT NULL

    Copy Of User (CopyOfUntitled)

    • Key — Primary key — NOT NULL
    • ID (Field) — Str — NOT NULL
    • PW (Field2) — int64 — NOT NULL
    • email (Field3) — Str — NOT NULL
    • birthday (Field4) — date — NOT NULL
    • Point (Field5) — int64 — NOT NULL

    Food (Untitled3)

      Post (Untitled6)

        Quest (Untitled8)

        • Key — Foreign key → User.Key — NOT NULL
        • Compid (Key3) — Foreign key → Competition.Compid — NOT NULL
        • Questtype (Field) — Str — NOT NULL
        • Questdt (Field2) — date — NOT NULL
        • Photo (Field3) — url
        • text (null) — str
        • point (Field4) — int64 — NOT NULL

        Routine (Untitled5)

          User (user)

          • Key — Primary key — NOT NULL
          • ID — Str — NOT NULL
          • PW (pw) — int64 — NOT NULL
          • email — Str — NOT NULL
          • birthday (Field4) — date — NOT NULL
          • Point (point) — int64 — NOT NULL
          • winrate — float64 — NOT NULL

          Workout (Untitled4)