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