OPS portal

Tables (17)

ATTENDANCES

  • ATT_ID — BIGINT
  • STARTED_AT — DATETIME — NOT NULL
  • ENDED_AT — DATETIME — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • APPROVER_ID — VARCHAR(64) — NOT NULL
  • REASON — TEXT
  • STATUS — ENUM('DRAFT' , 'REQUESTED' , 'COMPLETED' , 'REJECTED') — NOT NULL
  • REJECTION — TEXT
  • TAG — ENUM('VACATION','HOME_WORK','SICK_LEAVE','OFFSITE') — NOT NULL
  • STAFF_ID — VARCHAR(10) — NOT NULL

EVENTS

  • EVENT_ID — BIGINT
  • TYPE — VARCHAR(255)
  • STAFF_ID — VARCHAR(10) — NOT NULL

NOTICE

  • NOTICE_ID — BIGINT
  • TITLE — VARCHAR(50) — NOT NULL
  • CONTENT — TEXT
  • CRATED_AT — TIMESTAMP
  • UPDATE_AT — TIMESTAMP
  • PIN — TINYINT(1) — NOT NULL
  • VISIBLE — VARCHAR(2048)
  • CATEGORY — ENUM('NOTICE','NORMAL','HR') — NOT NULL
  • STAFF_ID — VARCHAR(10) — NOT NULL

NOTICE_FILES

  • NOTICE_FILES_ID — BIGINT
  • FILES_TYPE — ENUM('IMAGE','ATTACH') — NOT NULL
  • FILES_NAME — VARCHAR(255) — NOT NULL
  • MIME_TYPE — VARCHAR(100) — NOT NULL
  • FILES_SIZE — BIGINT
  • FILES_LINK — VARCHAR(2048) — NOT NULL
  • NOTICE_ID — BIGINT — NOT NULL

PAPERS

  • PAPER_ID — BIGINT
  • SERIAL_NUMBER — VARCHAR(254) — NOT NULL
  • CREATED_AT — TIMESTAMP
  • SENDING_TO — VARCHAR(32) — NOT NULL
  • REASON — TEXT — NOT NULL
  • STAFF_ID — VARCHAR(10) — NOT NULL

PAPER_CODES

  • PAPER_CODE_ID — VARCHAR(254) — Primary key — NOT NULL
  • TAG — VARCHAR(20) — NOT NULL
  • LAST_SERIAL_NUMBER — INT

PROJECTS

  • STAFF_ID — VARCHAR(10) — Primary key — NOT NULL
  • PROJECT_ID — BIGINT
  • NAME — VARCHAR(32) — NOT NULL
  • STATUS — TINYINT(1) — NOT NULL
  • VISIBLE — VARCHAR(2048)

PROJECT_BOARDS

  • PROJECT_BOARD_ID — BIGINT
  • ATTENDEE — VARCHAR(254) — NOT NULL
  • TITLE — VARCHAR(100) — NOT NULL
  • CONTENT — TEXT
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • VISIBLE — VARCHAR(2048)
  • PROJECT_ID — BIGINT — NOT NULL
  • STAFF_ID — VARCHAR(10) — NOT NULL

PROJECT_BOARD_FILES

  • PROJECT_BOARD_FILES_ID — BIGINT
  • FILES_TYPE — ENUM('IMAGE','ATTACH') — NOT NULL
  • FILES_NAME — VARCHAR(255) — NOT NULL
  • MIME_TYPE — VARCHAR(100) — NOT NULL
  • FILES_SIZE — BIGINT
  • FILES_LINK — VARCHAR(2048) — NOT NULL
  • PROJECT_BOARD_ID — BIGINT — NOT NULL

PURCHASES

  • PURCHASE_ID — BIGINT
  • CHARGER_ID — VARCHAR(10) — NOT NULL
  • PURCHASE_TITLE — VARCHAR(100) — NOT NULL
  • REASON — TEXT — NOT NULL
  • STATUS — ENUM('DRAFT' , 'REQUESTED' , 'PAYMENT' , 'DOCS_REVIEW' , 'COMPLETED' , 'REJECTED') — NOT NULL
  • REJECTION1 — VARCHAR(254)
  • REJECTION2 — VARCHAR(254)
  • ORDER_DATE — DATETIME
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • CURRENCY — ENUM('KRW','USD','EUR','JPY','CNY')
  • PAYMENT_METHOD — ENUM('CARD','CASH')
  • STAFF_ID — VARCHAR(10) — NOT NULL
  • VENDOR_ID — BIGINT

PURCHASE_DETAILS

  • PURCHASE_DETAIL_ID — BIGINT
  • ITEM_NAME — VARCHAR(100) — NOT NULL
  • ITEM_CNT — INT — NOT NULL
  • ITEM_UNIT — VARCHAR(50) — NOT NULL
  • ITEM_COST — DECIMAL(12,3) — NOT NULL
  • TAX — DECIMAL(5,3) — NOT NULL
  • PURCHASE_ID — BIGINT — NOT NULL

PURCHASE_DOCS

  • PURCHASE_DOCS_ID — BIGINT
  • DOCS_TYPE — ENUM('CASH_RECEIPT' , 'RECEIPT' , 'TAX_INVOICE' , 'ESTIMATE','STATEMENT' , 'TAX' , 'Others') — NOT NULL
  • DOCS_LINK — VARCHAR(2048) — NOT NULL
  • DOCS_NAME — VARCHAR(255) — NOT NULL
  • DOCS_MIME_TYPE — VARCHAR(100) — NOT NULL
  • DOCS_SIZE — BIGINT
  • PURCHASE_ID — BIGINT

PURCHASE_SITUATIONS

  • PURCHASE_SITUATIONS_ID — BIGINT
  • STATUS — ENUM('DRAFT' , 'REQUESTED' , 'PAYMENT' , 'DOCS_REVIEW' , 'COMPLETED' , 'REJECTED') — NOT NULL
  • PROCESSOR_ID — VARCHAR(10) — NOT NULL
  • CREATED_AT — TIMESTAMP
  • PROCESS_LOG — TEXT — NOT NULL
  • PURCHASE_ID — BIGINT

SCHEDULES

  • SCHEDULE_ID — BIGINT
  • TYPE — ENUM('MY','TEAM','COMPANY') — NOT NULL
  • TITLE — VARCHAR(50) — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • ATTENDEE — VARCHAR(254) — NOT NULL
  • ATTENDEE_ADDR — VARCHAR(254)
  • STARTED_AT — DATETIME — NOT NULL
  • ENDED_AT — DATETIME — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • STATUS — TINYINT(1) — NOT NULL
  • STAFF_ID — VARCHAR(10) — NOT NULL

TEAMS

  • TEAM_ID — BIGINT
  • NAME — VARCHAR(30) — NOT NULL
  • LEADER — TINYINT — NOT NULL
  • STAFF_ID — VARCHAR(10) — NOT NULL

USERS

  • STAFF_ID — VARCHAR(10) — Primary key — NOT NULL
  • USER_ID — VARCHAR(64) — NOT NULL
  • USER_PW — VARBINARY(255) — NOT NULL
  • PHONE — VARCHAR(20) — NOT NULL
  • USER_ADDR — VARCHAR(254)
  • MAIL_ID — VARCHAR(254) — NOT NULL
  • MAIN_PW — VARBINARY(255) — NOT NULL
  • DRIVE_LINK — VARCHAR(2048)
  • DRIVE_TOTAL — INT
  • POSITION — VARCHAR(50)
  • GRADE — ENUM('EMPLOYEE','MANAGER','CEO','ADMIN') — NOT NULL
  • JOIN_DATE — DATE — NOT NULL
  • QUIT_DATE — DATE
  • STATUS — TINYINT(1) — NOT NULL

VENDORS

  • VENDOR_ID — BIGINT
  • NAME — VARCHAR(64) — NOT NULL
  • STAFF_NAME — VARCHAR(30)
  • PHONE — VARCHAR(20) — NOT NULL
  • ADDR — VARCHAR(254) — NOT NULL
  • MAIL — VARCHAR(254)
  • BUSINESS_NUM — VARCHAR(20)