ojt_jira

Tables (4)

Person (person)

  • Person_id (person_id) — String — Primary key — NOT NULL
  • name — String

Person_report (person_report)

  • person_report_id — String — Primary key — NOT NULL
  • Person_id (person_id) — String — Foreign key → Person.Person_id — NOT NULL
  • success_ticket — Number
  • fail_ticket — Number
  • success_point — Number
  • fail_point — Number
  • start_date — LocalDateTime
  • end_date — LocalDateTIme

Team (team)

  • Team_id (team_id) — String — Primary key — NOT NULL
  • epic — String

Team_report (team_report)

  • team_report_id — String — Primary key — NOT NULL
  • Team_id (team_id) — String — Foreign key → Team.Team_id — NOT NULL
  • success_ticket — Number
  • fail_ticket — Number
  • success_point — Number
  • fail_point — Number
  • start_date — LocalDateTime
  • end_date — LocalDateTIme