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