asd
Tables (36)
ATTENDENCE
- ATTENDENCE_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- IN_TIME — DATETIME
- OUT_TIME — DATETIME
- DAY_STATUS — ENUM
BOARD
- BOARD_ID — BIGINT — NOT NULL
- COMMENT_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- TITLE — VARCHAR
- CONTENT — VARCHAR
- CATEGORY — ENUM
- HITS — BIGINT
- DEL_YN — ENUM
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
BOARD_FILE
- BOARD_FILE_ID — BIGINT — NOT NULL
- BOARD_ID — BIGINT — NOT NULL
- PATH — VARCHAR
- TYPE — VARCHAR
BigEvalution
- BIGEV_ID — BIGINT — NOT NULL
- BIGEV_NAME — VARCHAR
CALENDAR
- CALENDAR_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- TEAM_ID — BIGINT — NOT NULL
- TITLE — VARCHAR
- CONTENT — TEXT
- START — DATETIME
- END — DATETIME
- TYPE — ENUM
CHAT_FILE
- CHAT_FILE_ID — BIGINT — NOT NULL
- CHAT_USER_ID — BIGINT — NOT NULL
- CHAT_ROOM_ID2 — BIGINT — NOT NULL
- USER_ID2 — BIGINT — NOT NULL
- NAME — VARCHAR
- PATH — VARCHAR
CHAT_MESSAGE
- CHAT_MESSAGE_ID — BIGINT — NOT NULL
- CHAT_ROOM_ID — BIGINT — NOT NULL
- CHAT_USER_ID — BIGINT — NOT NULL
- CREATED_AT — VARCHAR
- CONTENT — VARCHAR
CHAT_ROOM
- CHAT_ROOM_ID — BIGINT — NOT NULL
- NAME — VARCHAR
CHAT_USER
- CHAT_USER_ID — BIGINT — NOT NULL
- CHAT_ROOM_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
COMMENT
- COMMENT_ID — BIGINT — NOT NULL
- CONTENT — VARCHAR
- USER_ID — BIGINT
- DEL_YN — ENUM
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
DISCORD_MESSAGE
- DISCORD_MESSAGE_ID — BIGINT — NOT NULL
- DISCORD_ROOM_ID — BIGINT — NOT NULL
- DISCORD_USER_ID — BIGINT — NOT NULL
- CREATED_AT — DATETIME
- CONTENT — TEXT
DISCORD_ROOM
- DISCORD_ROOM_ID — BIGINT — NOT NULL
- TEAM_ID — BIGINT — NOT NULL
- DISCORD_USER_ID — BIGINT — NOT NULL
- PASSWORD — BIGINT
- DISCORD_NAME — STRING
- password — STRING
- CREATED_AT — DATETIME
DISCORD_USER
- DISCORD_USER_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
DOCUMENT_C
- DOCUMENT_C_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- DOCUMENT_P_ID — BIGINT
- CONTENT — JSON
- DEL_YN — ENUM
- CREATED_AT — DATETIME
- SAVEDATE — VARCHAR
- FILE_PATH — VARCHAR
DOCUMENT_P
- DOCUMENT_P_ID — BIGINT — NOT NULL
- DOCUMENT_C_ID — BIGINT — NOT NULL
- DEL_YN — ENUM
DOCUMENT_TYPE
- DOCUMENT_TYPE_ID — BIGINT — NOT NULL
- DOCUMENT_P_ID — BIGINT — NOT NULL
- DEL_YN — ENUM
- DOCUMENT_TYPE — VARCHAR
EVALUATION
- EVALUATION_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- SCORE — INT
- START — DATE
- END — DATE
- DEL_YN — ENUM
EVALUATION_ITEMS
- EVALUATION_ITEMS_ID — INT — NOT NULL
- EVALUATION_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- CONTENT — VARCHAR
Evalutaion
- EVALUTION_ID — BIGINT — NOT NULL
- SUBEV_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- EV_SCORE — ENUM
- EV_FIELD — STRING
- EV_DATE — DATETIME
HOLIDAY
- HOL_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- HOLICAY_CAT_ID — BIGINT — NOT NULL
- USER_HOLI — FLOAT
- HOL_START — DATETIME
- HOL_END — DATETIME
HOLIDAY_CAT
- HOLICAY_CAT_ID — BIGINT — NOT NULL
- HOLI_NAME — VARCHAR
- HOLI_GIVE — FLOAT
MEETING_ROOM
- MEETING_ROOM_ID — BIGINT — NOT NULL
- NAME — VARCHAR
MEETING_ROOM_RESERVATION
- MEETING_ROOM_RES_ID — BIGINT — NOT NULL
- MEETING_ROOM_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- TIME — VARCHAR
- DATE — DATE
- CREATED_AT — DATETIME
- DEL_YN — ENUM
MiddleEvalution
- MIDDLEEV_ID — BIGINT — NOT NULL
- BIGEV_ID — BIGINT — NOT NULL
- MIDDLEEV_NAME — VARCHAR
NOTIFICATION
- NOTIFICATION_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- TEAM_ID — BIGINT — NOT NULL
- TYPE — VARCHAR
- READ — ENUM
- CREATED_AT — DATETIME
- DEL_YN — ENUM
POSITION
- POSITION_ID — BIGINT — NOT NULL
- NAME — VARCHAR
SUBJECT
- SUBJECT_ID — BIGINT — NOT NULL
- NAME — VARCHAR
- START — DATETIME
- END — DATETIME
- NUM — INT
- STATUS — ENUM
- DEL_YN — ENUM
- DESCRIPTION — VARCHAR
SUBMIT
- SUBMIT_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- TYPE — VARCHAR
- STATE — ENUM
- CONTENT — JSON
- DEL_YN — ENUM
- CREATED_AT — DATETIME
SUBMIT_LINE
- LINE_ID — BIGINT — NOT NULL
- SUBMIT_ID — BIGINT — NOT NULL
- PARENT_ID — BIGINT — NOT NULL
- USER_ID — BIGINT
- STATE — VARCHAR(255)
- CREATED_AT — DATETIME
SubEvalution
- SUBEV_ID — BIGINT — NOT NULL
- MIDDLEEV_ID — BIGINT — NOT NULL
- BIGEV_ID — BIGINT — NOT NULL
- SUBEV_CONTENT — TEXT
TEAM
- TEAM_ID — BIGINT — NOT NULL
- NAME — VARCHAR
- PARENT_ID — BIGINT — NOT NULL
USER
- USER_ID — BIGINT — NOT NULL
- POSITION_ID — BIGINT — NOT NULL
- TEAM_ID — BIGINT — NOT NULL
- PROFILE_IMAGE — VARCHAR
- NAME — VARCHAR
- GENDER — ENUM
- STATUS — ENUM
- PASSWORD — VARCHAR
- CREATED_AT — DATETIME
- DELETED_AT — DATETIME
- EMAIL — VARCHAR
- PHONE — DEL_YN
- DEL_YN — ENUM
- SOCIAL_NUM — VARCHAR
- HIRE — ENUM
- ADDRESS — VARCHAR
- NOW_STATE — ENUM
- ANNUAL_LEAVE — VARCHAR(255)
- WORK_DAY — STRING
USER_DELTE_HISTORY
- USER_DELETE_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- deletedBy — STRING
- deleteReason — STRING
- deletedAt — VARCHAR(255)
USER_SUBJECT
- USER_SUBJECT_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- SUBJECT_ID2 — BIGINT — NOT NULL
- DEL_YN — ENUM
VEHICLE
- VEHICLE_ID — BIGINT — NOT NULL
- NUM — VARCHAR
- TYPE — VARCHAR
VEHICLE_RESERVATION
- VEHICLE_RESERVATION_ID — BIGINT — NOT NULL
- VEHICLE_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- BOR_DATE — DATETIME
- APPROVE_STATE — ENUM
- DEL_YN — ENUM