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