LubinplaApp_Project

Tables (10)

Company

  • Id (id) — Primary key
  • name

Untitled (UserFriendship)

  • Id (user_id_1) — Foreign key → Users.Id
  • Id (user_id_2) — Foreign key → Users.Id
  • Field (status)

Untitled (Project)

  • Key (project_id) — Primary key — NOT NULL
  • Key (category_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (name)

Untitled (ProjectMember)

  • Id (user_id) — Foreign key → Users.Id
  • Key (project_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (role)

Untitled (Category)

  • Key (category_id) — Primary key — NOT NULL
  • Key (super_category_id) — Foreign key → Untitled.Key
  • Field (name)

Untitled (Condition)

  • Key (id) — Primary key — NOT NULL
  • Key (category_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (name)
  • Field (description)
  • Field (required)

Untitled (ProjectCondition)

  • Key (project_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (condition_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (value)

Untitled (Solution)

  • Key (id) — Primary key — NOT NULL
  • Key (category_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (name)
  • Field (description)

Untitled (SolutionUse)

  • Key (id) — Foreign key → Untitled.Key — NOT NULL
  • Key (project_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity)
  • Field (providedDate)
  • Field (status)

Users (User)

  • Id (id) — Primary key
  • Id (company_id) — Foreign key → Company.Id
  • jobTitle (job_title)
  • Field (email)
  • surname (sur_name)
  • given name (given_name)
  • phoneNumber (phone_number)
  • createdAt (created_at)
  • updatedAt (updated_at)