BugBounty

Tables (6)

Admin

  • id — String — Primary key — NOT NULL
  • aid — String
  • password — String
  • name — String

Asset

  • id — String — Primary key — NOT NULL
  • url — String
  • uid — String — Foreign key → User.id — NOT NULL
  • createdAt — String

Notice

  • id — String — Primary key — NOT NULL
  • title — String
  • content
  • createdAt — Timestamp
  • updatedAt — Timestamp
  • sid — String — Foreign key → Service.id — NOT NULL

Report

  • id — String — Primary key — NOT NULL
  • isPublic — String
  • state — Enum
  • title — String
  • vuln — String
  • level — Float
  • description — String
  • solution — String
  • createdAt — String
  • updatedAt — String
  • comment — String
  • point — Number
  • uid — String — Foreign key → User.id — NOT NULL
  • sid — String — Foreign key → Service.id — NOT NULL
  • editer — String — Foreign key → Admin.id — NOT NULL

Service

  • id — String — Primary key — NOT NULL
  • name — String
  • description — String
  • url — String
  • startDate — Timestamp
  • endDate — Timestamp
  • uid — String — Foreign key → User.id — NOT NULL
  • createdAt — Timestamp
  • updatedAt — Timestamp
  • deletedAt — Timestamp

User

  • id — String — Primary key — NOT NULL
  • email — String
  • password — String
  • type — Enum
  • name — String
  • introduction — String
  • point — Number
  • createdAt — Timestamp
  • deletedAt — Timestamp