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)