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)