FearNotToon
Tables (15)
Attendance (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- attendMonth (Field) — int
- attendDate (Field2) — String
- attendType (Field3) — String
- attendTime (Field4) — LocalDateTime
- User.id (Key2) — Long — Foreign key → User.id — NOT NULL
Document (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- content (Field2) — String
- stat (Field3) — char
- regDate (Field4) — LocalDateTme
- templateName (Field5) — String
- User.id (Key2) — Long — Foreign key → User.id — NOT NULL
DocumentData (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- fromDate (Field) — LocalDateTime
- toDate (Field2) — LocalDateTime
- deptCode (Field3) — String
- deptName (Field4) — String
- company (Field5) — String
- expenseType (Field6) — String
- count (Field7) — int
- price (Field8) — int
- supAmt (Field9) — int
- vatAmt (Field10) — int
- totalAmt (Field11) — int
- remark (Field12) — String
- Document.id (Key2) — Long — Foreign key → Document.id — NOT NULL
DocumentRcv (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- sortSequence (Field) — int
- receiveType (Field2) — String
- stat (Field3) — char
- Document.id (Key2) — Long — Foreign key → Document.id — NOT NULL
- User.id (Key3) — Long — Foreign key → User.id — NOT NULL
File (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- fileName (Field) — String
- originName (Field2) — String
- ext (Field3) — String
- fileSize (Field4) — Long
- stat (Field5) — boolean
- Notice.id (Key3) — Long — Foreign key → Notice.id — NOT NULL
- Webtoon.id (Key4) — Long — Foreign key → Webtoon.id — NOT NULL
- WebtoonDt.id (Key5) — Long — Foreign key → WebtoonDt.id — NOT NULL
- Request.id (Key6) — Long — Foreign key → Request.id — NOT NULL
- Document.id (Key2) — Long — Foreign key → Document.id — NOT NULL
- User.id (Key7) — Long — Foreign key → User.id — NOT NULL
Message (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- msgType (Field) — String
- content (Field2) — String
- programId (Field3) — String
- refId (Field4) — Long
- stat (Field5) — char
- createDate (Field6) — LocalDateTime
- sendUser.id (Key2) — Long — Foreign key → User.id — NOT NULL
- rcvUser.id (Key3) — Long — Foreign key → User.id — NOT NULL
Notice (Untitled7)
- id (Key) — Long — Primary key — NOT NULL
- noticeType (Field) — String
- title (Field2) — String
- content (Field3) — String
- noticeDate (Field4) — LocalDate
- readCount (Field5) — int
- User.id (Key2) — Long — Foreign key → User.id — NOT NULL
Pay (Untitled8)
- id (Key) — Long — Primary key — NOT NULL
- salary (Field) — int
- addPay (Field2) — int
- bankAccount (Field3) — String
- payDate (Field4) — LocalDate
- payYN (Field5) — boolean
- Uesr.id (Key2) — Long — Foreign key → User.id — NOT NULL
Plan (Untitled9)
- id (Key) — Long — Primary key — NOT NULL
- planType (Field) — String
- title (Field2) — String
- month (Field3) — int
- startDate (Field4) — LocalDate
- startTime (Field5) — LocalTime
- endDate (Field6) — LocalDate
- endTime (Field7) — LocalTime
- registerDate (Field8) — LocalDate
- holidayYN (Field9) — boolean
- User.id (Key2) — Long — Foreign key → User.id — NOT NULL
Qualification (Untitled10)
- id (Key) — Long — Primary key — NOT NULL
- qlfcType (Field) — String
- content (Field2) — String
- qlfcDate (Field3) — LocalDate
- qlfcPay (Field4) — int
- User.id (Key2) — Long — Foreign key → User.id — NOT NULL
Request (Untitled11)
- id (Key) — Long — Primary key — NOT NULL
- reqType (Field) — String
- title (Field2) — String
- content (Field3) — String
- step (Field4) — int
- LocalDate (Field5) — LocalDate
- doneDate (Field6) — LocalDate
- reqUser.id (Key2) — Long — Foreign key → User.id — NOT NULL
- itUser.id (Key3) — Long — Foreign key → User.id — NOT NULL
RequestDt (Untitled12)
- id (Key) — Long — Primary key — NOT NULL
- content (Field) — String
- count (Field2) — int
- cost (Field3) — int
- Request.id (Key2) — Long — Foreign key → Request.id — NOT NULL
User (Untitled13)
- id (Key) — Long — Primary key — NOT NULL
- employeeId (Field) — String
- password (Field2) — String
- name (Field3) — String
- deptCode (Field4) — String
- deptName (Field5) — String
- teamNum (Field6) — int
- position (Field7) — String
- email (Field8) — String
- tel (Field9) — String
- birthDate (Field10) — LocalDate
- joinDate (Field11) — LocalDate
- usable (Field12) — boolean
- roles (Field13) — List<String>
Webtoon (Untitled14)
- id (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- intro (Field2) — String
- artist (Field3) — String
- illustrator (Field4) — String
- category (Field5) — String
- keyword (Field6) — String
WebtoonDt (Untitled15)
- id (Key) — Long — Primary key — NOT NULL
- episodeNum (Field) — int
- subTitle (Field2) — String
- content (Field3) — String
- manager (Field4) — String
- uploadDate (Field5) — LocalDate
- finalUploadYN (Field6) — boolean
- thumbnailFileId (Field10) — Long
- episodeFileId (Field11) — Long
- Webtoon.id (Key2) — Long — Foreign key → Webtoon.id — NOT NULL