flour

Tables (20)

board

  • BOARD_ID — INT — Primary key — NOT NULL
  • BOARD_TITLE — VARCHAR(100) — NOT NULL
  • BOARD_CONTENT — LONGTEXT
  • BOARD_REGDATE — TIMESTAMP — NOT NULL
  • BOARD_COUNT — INT
  • BOARD_FILENAME — VARCHAR(200)
  • BOARD_FILEPATH — TEXT
  • USER_IDENNUM — CHAR(9) — NOT NULL

board_comment

  • BOARD_COMMENT_ID — INT — Primary key — NOT NULL
  • BOARD_COMMENT_USER_ID — VARCHAR(45)
  • BOARD_COMMENT_CONTENT — VARCHAR(45)
  • BOARD_COMMENT_REGDATE — TIMESTAMP
  • BOARD_ID — INT

board_news

  • BOARD_NEWS_ID — INT — Primary key — NOT NULL
  • BOARD_NEWS_TITLE — VARCHAR(100) — NOT NULL
  • BOARD_NEWS_CONTENT — LONGTEXT
  • BOARD_NEWS_REGDATE — TIMESTAMP — NOT NULL
  • BOARD_NEWS_COUNT — INT
  • BOARD_NEWS_FILENAME — VARCHAR(200)
  • BOARD_NEWS_FILEPATH — TEXT
  • USER_IDENNUM — CHAR(9) — NOT NULL

board_news_comment

  • BOARD_NEWS_COMMENT_ID — INT — Primary key — NOT NULL
  • BOARD_NEWS_COMMENT_USER_ID — VARCHAR(45)
  • BOARD_NEWS_COMMENT_CONTENT — VARCHAR(45)
  • BOARD_NEWS_COMMENT_REGDATE — TIMESTAMP
  • BOARD_NEWS_ID — INT

board_notice

  • BOARD_NOTICE_ID — INT — Primary key — NOT NULL
  • BOARD_NOTICE_TITLE — VARCHAR(100) — NOT NULL
  • BOARD_NOTICE_CONTENT — LONGTEXT
  • BOARD_NOTICE_REGDATE — TIMESTAMP — NOT NULL
  • BOARD_NOTICE_COUNT — INT
  • BOARD_NOTICE_FILENAME — VARCHAR(200)
  • BOARD_NOTICE_FILEPATH — TEXT
  • USER_IDENNUM — CHAR(9) — NOT NULL

board_notice_comment

  • BOARD_NOTICE_COMMENT_ID — INT — Primary key — NOT NULL
  • BOARD_NOTICE_COMMENT_USER_ID — VARCHAR(45)
  • BOARD_NOTICE_COMMENT_CONTENT — VARCHAR(45)
  • BOARD_NOTICE_COMMENT_REGDATE — TIMESTAMP
  • BOARD_NOTICE_ID — INT

chatmessage

  • id — VARCHAR(255) — Primary key — NOT NULL
  • chat_id — VARCHAR(255) — NOT NULL
  • sender_id — VARCHAR(255) — NOT NULL
  • recipient_id — VARCHAR(255) — NOT NULL
  • sender_name — VARCHAR(255) — NOT NULL
  • recipient_name — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • timestamp — TIMESTAMP — NOT NULL
  • statusMessage — VARCHAR(50) — NOT NULL

chatroom

  • id — VARCHAR(255) — Primary key — NOT NULL
  • chat_id — VARCHAR(255) — NOT NULL
  • sender_id — VARCHAR(255) — NOT NULL
  • recipient_id — VARCHAR(255) — NOT NULL

commute

  • USER_IDENNUM — VARCHAR(10)
  • CHECK_DATE — DATE
  • CHECK_IN_TIME — TIME
  • CHECK_OUT_TIME — TIME
  • STATUS — VARCHAR(20)

department

  • DEPARTMENT_ID — INT — Primary key — NOT NULL
  • DEPARTMENT_NAME — VARCHAR(45) — NOT NULL

document_holiday

  • DOCUMENT_HOLIDAY_NUM — VARCHAR(45) — Primary key — NOT NULL
  • USER_IDENNUM — CHAR(9) — NOT NULL
  • DOCUMENT_HOLIDAY_USERNAME — VARCHAR(45)
  • DOCUMENT_HOLIDAY_USERDEPARTMENT — VARCHAR(45)
  • DOCUMENT_HOLIDAY_TITLE — VARCHAR(45)
  • DOCUMENT_HOLIDAY_SORT — VARCHAR(45)
  • DOCUMENT_HOLIDAY_SUBMITDAY — DATE
  • DOCUMENT_HOLIDAY_STARTDAY — DATE
  • DOCUMENT_HOLIDAY_ENDDAY — DATE
  • DOCUMENT_HOLIDAY_CONTENT — VARCHAR(200)
  • DOCUMENT_HOLIDAY_CHECK — VARCHAR(45)
  • DOCUMENT_HOLIDAY_STATUS — VARCHAR(45)
  • DOCUMENT_HOLIDAY_PAYMENTDAY — VARCHAR(45)
  • DOCUMENT_HOLIDAY_PAYMENTUSER — VARCHAR(45)
  • DOCUMENT_HOLIDAY_PAYMENTDEPARTMENT — VARCHAR(45)
  • DOCUMENT_HOLIDAY_PAYMENTUSERID — VARCHAR(45)

document_resignation

  • DOCUMENT_RESIGNATION_NUM — VARCHAR(45) — Primary key — NOT NULL
  • USER_IDENNUM — CHAR(9) — NOT NULL
  • DOCUMENT_RESIGNATION_USERNAME — VARCHAR(45)
  • DOCUMENT_RESIGNATION_USERDEPARTMENT — VARCHAR(45)
  • DOCUMENT_RESIGNATION_USERCREATEDAY — DATE
  • DOCUMENT_RESIGNATION_TITLE — VARCHAR(45)
  • DOCUMENT_RESIGNATION_SUBMITDAY — DATE
  • DOCUMENT_RESIGNATION_RETIREMENTDAY — DATE
  • DOCUMENT_RESIGNATION_REASON — VARCHAR(45)
  • DOCUMENT_RESIGNATION_CHECK — VARCHAR(45)
  • DOCUMENT_RESIGNATION_STATUS — VARCHAR(45)
  • DOCUMENT_RESIGNATION_PAYMENTDAY — VARCHAR(45)
  • DOCUMENT_RESIGNATION_PAYMENTUSER — VARCHAR(45)
  • DOCUMENT_RESIGNATION_PAYMENTDEPARTMENT — VARCHAR(45)
  • DOCUMENT_RESIGNATION_PAYMENTUSERID — VARCHAR(45)

document_taskreport

  • DOCUMENT_TASKREPORT_NUM — VARCHAR(45) — Primary key — NOT NULL
  • USER_IDENNUM — CHAR(9) — NOT NULL
  • DOCUMENT_TASKREPORT_USERNAME — VARCHAR(45)
  • DOCUMENT_TASKREPORT_USERDEPARTMENT — VARCHAR(45)
  • DOCUMENT_TASKREPORT_TITLE — VARCHAR(45)
  • DOCUMENT_TASKREPORT_TASKNAME — VARCHAR(45)
  • DOCUMENT_TASKREPORT_SUBMITDAY — DATE
  • DOCUMENT_TASKREPORT_STARTDAY — DATE
  • DOCUMENT_TASKREPORT_ENDDAY — DATE
  • DOCUMENT_TASKREPORT_PLAN — VARCHAR(200)
  • DOCUMENT_TASKREPORT_SPECIALNOTE — VARCHAR(200)
  • DOCUMENT_TASKREPORT_SUGGESTIONS — VARCHAR(200)
  • DOCUMENT_TASKREPORT_CHECK — VARCHAR(45)
  • DOCUMENT_TASKREPORT_STATUS — VARCHAR(45)
  • DOCUMENT_TASKREPORT_PAYMENTDAY — VARCHAR(45)
  • DOCUMENT_TASKREPORT_PAYMENTUSER — VARCHAR(45)
  • DOCUMENT_TASKREPORT_PAYMENTDEPARTMENT — VARCHAR(45)
  • DOCUMENT_TASKREPORT_PAYMENTUSERID — VARCHAR(45)

introduce

  • introduce_id — VARCHAR(100) — NOT NULL
  • introduce_title — VARCHAR(100) — NOT NULL
  • introduce_content — TEXT

mywork

  • MYWORK_ID — INT — Primary key — NOT NULL
  • MYWORK_TASK — VARCHAR(100)
  • MYWORK_WORK — LONGTEXT
  • MYWORK_STATUS — VARCHAR(20)
  • MYWORK_STARTTIME — DATE
  • MYWORK_ENDTIME — DATE
  • USER_IDENNUM — CHAR(9) — NOT NULL

mywork_progress

  • MYWORK_PROGRESS_VALUE — VARCHAR(45) — NOT NULL
  • USER_IDENNUM — CHAR(9) — NOT NULL

persistent_logins

  • series — VARCHAR(64) — Primary key — NOT NULL
  • username — VARCHAR(64) — NOT NULL
  • token — VARCHAR(64) — NOT NULL
  • last_used — DATETIME — NOT NULL

reservation_car

  • RESERVATION_CAR_ID — INT — Primary key — NOT NULL
  • RESERVATION_CAR_VALUE — VARCHAR(45)
  • RESERVATION_CAR_STATUS — VARCHAR(15)
  • RESERVATION_CAR_IMAGE — LONGTEXT
  • RESERVATION_CAR_USERID — VARCHAR(45)
  • RESERVATION_CAR_STARTTIME — DATE
  • RESERVATION_CAR_ENDTIME — DATE
  • RESERVATION_CAR_DESTINATION — VARCHAR(45)
  • RESERVATION_CAR_USE — VARCHAR(200)
  • RESERVATION_CAR_REJECTREASON — VARCHAR(45)

reservation_room

  • id — VARCHAR(200)
  • location — VARCHAR(45)
  • calendarId — VARCHAR(45)
  • title — VARCHAR(45)
  • start — TIMESTAMP
  • end — TIMESTAMP
  • state — VARCHAR(45)

users

  • USER_ID — BINARY(255) — Primary key — NOT NULL
  • USER_IDENNUM — CHAR(9) — NOT NULL
  • USER_PASSWORD — CHAR(100) — NOT NULL
  • USER_EMAIL — VARCHAR(45) — NOT NULL
  • USER_NAME — VARCHAR(45) — NOT NULL
  • USER_GENDER — VARCHAR(45) — NOT NULL
  • DEPARTMENT_ID — VARCHAR(30)
  • USER_PHONE — VARCHAR(45) — NOT NULL
  • USER_PHOTO — LONGTEXT
  • USER_ADDRESS_POSTNUM — VARCHAR(5) — NOT NULL
  • USER_ADDRESS_BASIC — VARCHAR(100) — NOT NULL
  • USER_ADDRESS_DETAIL — VARCHAR(100) — NOT NULL
  • USER_ROLE — VARCHAR(30) — NOT NULL
  • user_email_token_generated_date — CHAR(100)
  • user_email_token — CHAR(100)
  • user_email_verified — CHAR(100)
  • user_createddate — DATETIME
  • user_moddate — VARCHAR(45)
  • LAST_ACCESS_TIME — TIMESTAMP
  • USER_POSITION — VARCHAR(45)