24.08.28 new erd 2
Tables (15)
UserInfra
- id — varchar(500) — Foreign key → user.userid — NOT NULL
- infracodePK — int — Foreign key → infra.infracodePK — NOT NULL
- role — varchar(500)
- joined — int
UserPentest
- pentestPK — varchar(500) — Foreign key → pentest.pentestPK — NOT NULL
- id — varchar(500) — Foreign key → user.userid — NOT NULL
- role — varchar(500)
- joined — int
UserSourcecode
- id — varchar(500) — Foreign key → user.userid — NOT NULL
- sourcecodePK — int — Foreign key → sourcecode.sourcecodePK — NOT NULL
- role — varchar(500)
- joined — int
infra
- infracodePK — int — Primary key — NOT NULL
- managecode — varchar(500) — Foreign key → project.managecode — NOT NULL
- testtype — varchar(500)
- testdivision — varchar(500)
- status — varchar(500)
- receiveday — date
- testcount — int
- startdate — date
- enddate — date
- asset_count — int
- targetcount — int
- firstvulncount — int
infra_check_list
- checkcode — varchar(500) — Primary key — NOT NULL
- years — int
- testtype — varchar(500)
- check_item — varchar(500)
- listlevel — varchar(500)
infra_target
- PK — int — Primary key — NOT NULL
- host — varchar(500)
- ip — varchar(500)
- platform — varchar(500)
- platformdetail — varchar(500)
- licenseusecount — int
- SolidStepRegistDay — date
- memo — varchar(500)
- assetstatus — varchar(500)
infravuln
- PK — int — Primary key — NOT NULL
- PK2 — int — Foreign key → infra_target.PK — NOT NULL
- checkcode — varchar(500) — Foreign key → infra_check_list.checkcode — NOT NULL
- infracodePK — int — Foreign key → infra.infracodePK — NOT NULL
- managecode — varchar(500) — Foreign key → infra.managecode — NOT NULL
- IP — varchar(500)
- type — varchar(500)
- target — varchar(500)
- risklevel — varchar(500)
- typename — varchar(500)
- handmokname — varchar(500)
- result — varchar(500)
- teststatus — varchar(500)
- testcount — varchar(500)
- startdate — date
- enddate — date
- actdate — date
- actstatus — varchar(500)
- memo — varchar(500)
pentest
- pentestPK — varchar(500) — Primary key — NOT NULL
- managecode — varchar(500) — Foreign key → project.managecode — NOT NULL
- years — int
- status — varchar(500)
- url — varchar(500)
- urlcount — int
- testcount — int
- memo — varchar(500)
- manday — int
- type — varchar(500)
pentest_checklist
- checkcode — varchar(500) — Primary key — NOT NULL
- years — int
- testtype — varchar(500)
- check_item — varchar(500)
- listlevel — varchar(500)
pentest_vuln
- vulnPK — varchar(500) — Primary key — NOT NULL
- checkcode — varchar(500) — Foreign key → pentest_checklist.checkcode — NOT NULL
- pentestPK — varchar(500) — Foreign key → pentest.pentestPK — NOT NULL
- managecode — varchar(500) — Foreign key → pentest.managecode — NOT NULL
- years — int — NOT NULL
- testcount — int
- memo — varchar(500)
- memo2 — varchar(500)
- startdate — date
- enddate — date
- actdate — date
- status — varchar(500) — NOT NULL
- memo3 — varchar(500)
- manager — varchar(500)
- actmemo — varchar(500)
project
- managecode — varchar(500) — Primary key — NOT NULL
- years — int — NOT NULL
- projcet_code — varchar(500) — NOT NULL
- service_code — varchar(500) — NOT NULL
- projcet_name — varchar(500) — NOT NULL
- inspection — varchar(500) — NOT NULL
- open_date — date
- RCom — varchar(500)
- MCom — varchar(500)
- MPart — varchar(500)
- MManager — varchar(500)
- MMPhone — varchar(500)
- WCom — varchar(500)
- WPart — varchar(500)
- WManager — varchar(500)
- WMPhone — varchar(500)
- Pentest — varchar(500)
- sourcecode — varchar(500)
- infra — varchar(500)
- memo — varchar(500)
- newinvest — ENUM('O', 'X')
- OX2 — ENUM('O', 'X')
- OX3 — ENUM('O', 'X')
- OX4 — ENUM('O', 'X')
- OX5 — ENUM('O', 'X')
- OX6 — ENUM('O', 'X')
- OX7 — ENUM('O', 'X')
- LastYearCode — varchar(500)
- LastYearExtension — ENUM('O', 'X')
- PreviousProjectCode — varchar(500)
- stardate — date
- enddate — date
sourcecode
- sourcecodePK — int — Primary key — NOT NULL
- managecode — varchar(500) — Foreign key → project.managecode — NOT NULL
- manday — int
- coderayname — varchar(500)
- Field — int
- memo — varchar(500)
- startdate — date
- firstcheckdate — date
- enddate — date
- status — varchar(500)
- Field2 — varchar(500)
sourcecode_checklist
- checkcode — varchar(500) — Primary key — NOT NULL
- years — int
- testtype — varchar(500)
- check_item — varchar(500)
- listlevel — varchar(500)
sourcecodevuln
- PK — int — Primary key — NOT NULL
- checkcode — varchar(500) — Foreign key → sourcecode_checklist.checkcode — NOT NULL
- sourcecodePK — int — Foreign key → sourcecode.sourcecodePK — NOT NULL
- managecode — varchar(500) — Foreign key → sourcecode.managecode — NOT NULL
- name — varchar(500)
- IP — varchar(500)
- type — varchar(500)
- risklevel — varchar(500)
- typename — varchar(500)
- handmokname — varchar(500)
- result — varchar(500)
- teststatus — varchar(500)
- actdate — date
- memo — varchar(500)
user
- userid — varchar(500) — Primary key — NOT NULL
- name — varchar(500)
- password — varchar(500)
- level — int
- createday — date
- last_pwchange — date
- lastlogon — date