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