aa

Tables (6)

Notice (공지)

  • Key (id) — Long — Primary key — NOT NULL
  • fk (noticeTypeId) — Long — Foreign key → NoticeType.id — NOT NULL
  • title — String
  • contents — String
  • isFixed — Boolean
  • exposureBegin — LocalDateTime
  • exposureEnd — LocalDateTime
  • isSendMail — Boolean
  • createdTime — LocalDateTime
  • updatedTime — LocalDateTime

NoticeSendEmail (메일 참조자)

  • Key (id) — Long — Primary key — NOT NULL
  • fk (noticeId) — Long — Foreign key → Notice.Key — NOT NULL
  • empNo — String

NoticeType (구분)

  • id — Long — Primary key — NOT NULL
  • systemid — Long — Foreign key → System.id — NOT NULL
  • name — String

NoticeVisitor (방문 기록)

  • Key (id) — Long — Primary key — NOT NULL
  • empNo — String
  • visitedTime — LocalDateTime

System (시스템)

  • id — Long — Primary key — NOT NULL
  • name — String

SystemUser (시스템 관리자)

  • id — Long — Primary key — NOT NULL
  • fk (systemId) — Long — Foreign key → System.id — NOT NULL
  • empNo — String