wodmon

Tables (4)

Categories (categories)

  • ID (id) — int — Primary key — NOT NULL
  • HeroWodID (hero_wod_id) — int — Foreign key → Hero Wod.Id
  • PersonalWodID (personal_wod_uuid) — char(36) — Foreign key → Personal Wod.WodID
  • TagID (tag_id) — char(36)

Hero Wod (hero_wod)

  • Id (id) — int — Primary key — NOT NULL
  • Title (title) — varchar
  • Content (description) — text
  • History (history) — varchar
  • CreatedAt (credated_at) — date

Personal Wod (personal_wod)

  • WodID (wod_uuid) — char(36) — Primary key — NOT NULL
  • UserID (user_id) — int — Foreign key → User.Id — NOT NULL
  • Title (title) — varchar
  • Content (description) — text
  • History (history) — varchar
  • CreatedAt (credated_at) — date
  • UpdatedAt (updated_at) — date
  • ArchivedAt (archived_at) — date

User (users)

  • Id (id) — int — Primary key — NOT NULL
  • userID (user_uuid) — char(36)
  • Name (name) — varchar
  • E-mail (email) — varchar
  • PW (password) — varchar
  • Field