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