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