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)