aa
Tables (38)
ASSET
- ASSET_ID — NUMBER — Primary key — NOT NULL
- CATEGORY_CODE — VARCHAR2(20) — NOT NULL
- MODEL_NAME — VARCHAR2(200) — NOT NULL
- SERIAL_NO — VARCHAR2(100)
- PROJECT_CODE — VARCHAR2(100)
- MANUFACTURER — VARCHAR2(100)
- ASSET_PURCHASE_TYPE — VARCHAR2(20)
- ASSET_USAGE — VARCHAR2(100)
- ASSET_NO — VARCHAR2(100)
- SW_ASSET_NO — VARCHAR2(100)
- ASSET_STATUS — VARCHAR2(20)
- RENTAL_COMPANY — VARCHAR2(100)
- RENTAL_CONTRACT_NO — VARCHAR2(100)
- RENTAL_SW_CONTRACT_NO — VARCHAR2(100)
- PURCHASE_DATE — DATE
- PURCHASE_COST — NUMBER(15,0)
- SW_RENTAL_COST — NUMBER(15,0)
- VAT — NUMBER(15,0)
- EXPIRE_DATE — DATE
- CURRENT_EMPLOYEE_ID — NUMBER
- LOCATION — VARCHAR2(4000)
- SPEC_INFO — VARCHAR2(4000)
- REMARK — VARCHAR2(4000)
- CREATED_AT — DATE
- UPDATED_AT — DATE
- CONFIRM_REQ_YN — CHAR(1) — 자산
AUTH_RESOURCE
- RESOURCE_ID — NUMBER — Primary key — NOT NULL
- RESOURCE_NAME — VARCHAR2(100) — NOT NULL — 자원의
- RESOURCE_TYPE — VARCHAR2(20) — NOT NULL — 자원의
- RESOURCE_KEY — VARCHAR2(255) — NOT NULL — 자원의
- RESOURCE_PATH — VARCHAR2(255) — NOT NULL
- MENU_GROUP — VARCHAR2(100) — NOT NULL
- MENU_ICON_KEY — VARCHAR2(100) — NOT NULL
- MENU_SORT_ORDER — NUMBER(3,0) — NOT NULL
- DESCRIPTION — VARCHAR2(500) — 자원에
- IS_ACTIVE — CHAR(1) — NOT NULL — 자원
- CREATED_AT — DATE — NOT NULL — 레코드
- UPDATED_AT — DATE — NOT NULL — 레코드
AUTH_ROLE
- ROLE_CODE — VARCHAR2(50) — Primary key — NOT NULL
- ROLE_NAME — VARCHAR2(100)
- RANK — NUMBER(38,0) — role
CLIENT
- CLIENT_ID — NUMBER
- CLIENT_NAME — VARCHAR2(100) — NOT NULL
- RELATIONSHIP_TYPE_CODE — VARCHAR2(20) — 고객사유형코드
- BUSINESS_ID — VARCHAR2(20)
- CONTACT_NAME — VARCHAR2(50)
- CONTACT_PHONE — VARCHAR2(20)
- CONTACT_EMAIL — VARCHAR2(100)
- ADDRESS — VARCHAR2(255)
- CLIENT_TYPE — VARCHAR2(20) — NOT NULL
- IS_ACTIVE — CHAR(1) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- CREATED_BY — VARCHAR2(50)
- UPDATED_AT — TIMESTAMP
- UPDATED_BY — VARCHAR2(50)
CODE
- GROUP_CODE — VARCHAR2(50) — Primary key — NOT NULL
- CODE_VALUE — VARCHAR2(50) — Primary key — NOT NULL — 상세
- CODE_NAME — VARCHAR2(100) — NOT NULL
- DESCRIPTION — VARCHAR2(255)
- IS_USED — CHAR(1) — NOT NULL
- SORT_ORDER — NUMBER(5,0)
- CREATED_AT — TIMESTAMP — NOT NULL
- CREATED_BY — VARCHAR2(50)
- UPDATED_AT — TIMESTAMP
- UPDATED_BY — VARCHAR2(50)
- IS_MANDATORY — CHAR(1)
- FILLER1 — VARCHAR2(100)
- FILLER2 — VARCHAR2(100)
CODE_GROUP
- GROUP_CODE — VARCHAR2(50) — Primary key — NOT NULL
- GROUP_NAME — VARCHAR2(100) — NOT NULL — 그룹
- DESCRIPTION — VARCHAR2(255)
- IS_USED — CHAR(1) — NOT NULL
- SORT_ORDER — NUMBER(5,0)
- CREATED_AT — TIMESTAMP — NOT NULL
- CREATED_BY — VARCHAR2(50)
- UPDATED_AT — TIMESTAMP
- UPDATED_BY — VARCHAR2(50)
CONTRACT_ATTACHMENT
- ID — NUMBER — Primary key — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL
- FILE_NAME — VARCHAR2(255) — NOT NULL
- FILE_TYPE — VARCHAR2(50)
- FILE_PATH — VARCHAR2(500)
- UPLOADED_AT — TIMESTAMP
- UPLOADED_BY — VARCHAR2(100)
CONTRACT_PAYMENT_HISTORY
- ID — NUMBER — Primary key — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL
- STATUS — VARCHAR2(50)
- PAYMENT_DATE — DATE — NOT NULL
- AMOUNT — NUMBER(15,0) — NOT NULL
- PAYMENT_METHOD — VARCHAR2(100)
- RECEIPT_NUMBER — VARCHAR2(100)
- TAX_INVOICE_STATUS_CODE — VARCHAR2(50)
- REMARKS — VARCHAR2(500)
- CREATED_AT — TIMESTAMP
EMPLOYEE
- EMPLOYEE_ID — NUMBER — Primary key — NOT NULL — 시스템
- EMPLOYEE_NO — VARCHAR2(50) — 사번
- STATUS — VARCHAR2(20) — NOT NULL — 근무
- EMPLOYEE_TYPE — VARCHAR2(20) — 채용
- HIRE_TYPE — VARCHAR2(20) — NOT NULL — 직원
- ORG_ID — VARCHAR2(100)
- NAME — VARCHAR2(50) — NOT NULL — 이름
- NAME_EN — VARCHAR2(50) — 이름
- EMAIL — VARCHAR2(100) — NOT NULL — 이메일
- PHONE_NUMBER — VARCHAR2(20) — NOT NULL — 휴대폰
- HIRE_DATE — DATE — NOT NULL — 입사일자
- TERMINATION_DATE — DATE — 퇴사일자
- POSITION — VARCHAR2(20) — NOT NULL — 직위
- JOB_TITLE — VARCHAR2(20) — 직책
- GRADE — VARCHAR2(20) — 등급
- RECOMMAND_EMPLOYEE_NO — VARCHAR2(20) — 추천인
- BIRTHDAY — VARCHAR2(8) — NOT NULL — 생년월일
- GENDER_CD — CHAR(1) — NOT NULL — 성별
- EMERGENCY_TEL_NO — VARCHAR2(20) — NOT NULL — 비상
- EMERGENCY_REL_TYPE — VARCHAR2(20) — NOT NULL
- SALARY — VARCHAR2(300) — 급여
- DEPARTMENT — VARCHAR2(100) — 소속
- DESCRIPTION — VARCHAR2(4000) — 비고
- ADDRESS — VARCHAR2(1000) — NOT NULL — 주소
- MARRY_YN — CHAR(1) — 결혼
- DISABILITY_YN — CHAR(1) — 장애
- VETERAN_YN — CHAR(1) — 보훈
- CREATE_AT — TIMESTAMP
- CREATE_BY — VARCHAR2(50)
- BANK_NAME — VARCHAR2(50) — 외주/프리용
- BANK_ACCOUNT_NO — VARCHAR2(50) — 외주/프리용
EMPLOYEE_ATTACHMENT
- ID — NUMBER — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER — NOT NULL
- FILE_NAME — VARCHAR2(255) — NOT NULL
- FILE_TYPE — VARCHAR2(50)
- FILE_PATH — VARCHAR2(500)
- UPLOADED_AT — TIMESTAMP
- UPLOADED_BY — VARCHAR2(100)
EMPLOYEE_CAREER
- ID — NUMBER
- EMPLOYEE_ID — NUMBER
- COMPANY_NAME — VARCHAR2(255)
- POSITION — VARCHAR2(100)
- DEPARTMENT — VARCHAR2(100)
- START_DATE — DATE
- END_DATE — DATE
- DESCRIPTION — CLOB
EMPLOYEE_CERTIFICATE
- ID — NUMBER — NOT NULL
- EMPLOYEE_ID — VARCHAR2(50) — NOT NULL
- CERTIFICATE_NAME — VARCHAR2(100) — NOT NULL
- CERTIFICATE_LEVEL — VARCHAR2(50)
- ACQUIRE_DATE — VARCHAR2(10)
- ISSUE_INSTITUTION — VARCHAR2(100)
- CERTIFICATE_NO — VARCHAR2(50)
- DESCRIPTION — VARCHAR2(1000)
EMPLOYEE_EDUCATION
- ID — NUMBER — Primary key — NOT NULL
- EMPLOYEE_ID — VARCHAR2(50) — NOT NULL
- START_DATE — VARCHAR2(10)
- END_DATE — VARCHAR2(10)
- SCHOOL_NAME — VARCHAR2(100) — NOT NULL
- MAJOR — VARCHAR2(100)
- GRADUATE_STATUS — VARCHAR2(20)
- DEGREE — VARCHAR2(20)
- DESCRIPTION — VARCHAR2(1000)
EMPLOYEE_HISTORY
- ID — NUMBER — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER — NOT NULL
- EMAIL — VARCHAR2(100)
- PHONE_NUMBER — VARCHAR2(20)
- POSITION — VARCHAR2(20) — NOT NULL
- JOB_TITLE — VARCHAR2(20)
- SALARY — VARCHAR2(300)
- DEPARTMENT — VARCHAR2(100)
- CHANGED_AT — TIMESTAMP
- CHANGED_BY — VARCHAR2(100)
- DESCRIPTION — VARCHAR2(4000)
- ORG_ID — VARCHAR2(100)
- STATUS — VARCHAR2(100)
- GRADE — VARCHAR2(20)
EMPLOYEE_PROJECT_ASSIGNMENT
- ID — NUMBER — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER
- PROJECT_ID — NUMBER — NOT NULL
- ROLE — VARCHAR2(100)
- GRADE — VARCHAR2(50)
- HIRE_TYPE — VARCHAR2(20)
- POSITION — VARCHAR2(20)
- GROSS_UNIT_PRICE — NUMBER(10,0) — 원청
- PAYMENT_UNIT_PRICE — NUMBER(10,0) — 협력사/인력
- SEMI_REGULAR_UNIT_PRICE — NUMBER(10,0) — 계약직/프리랜서
- REAL_PAYMENT_UNIT_PRICE — NUMBER(10,0)
- REAL_SEMI_REGULAR_UNIT_PRICE — NUMBER(10,0)
- START_DATE — DATE
- END_DATE — DATE
- REAL_START_DATE — DATE
- REAL_END_DATE — DATE
- DESCRIPTION — VARCHAR2(4000)
- BYPASS — CHAR(1) — BYPASS
- PLANNED — CHAR(1) — 계약시점
- CHANGE_REASON — VARCHAR2(100) — 변경사유
- TBD_ID — NUMBER(3,0) — TBD
- BASE_MM_RATE — NUMBER(3,2) — 투입기준비율
- PARTNER_NAME — VARCHAR2(100) — 혁력사(소속사)
- ADDITIONAL_TASK_ID — NUMBER(38,0) — 추가업무
- ADJUST_MM_RATE — NUMBER(3,2) — MM
- BEFORE_EMPLOYEE_ID — NUMBER(38,0) — 인력교체전
- REPLACEMENT_COST_BURDEN — VARCHAR2(20) — 인력교체
- MOD_SOURCE_NAME — VARCHAR2(100) — 수정화면명
- CHANGED_BY_PM_AT — TIMESTAMP
- CHANGED_BY_PM — VARCHAR2(50)
- CHANGED_AT — TIMESTAMP
- CHANGED_BY — VARCHAR2(100)
- SUBCONTRACT_STATUS — VARCHAR2(100) — 하도급계약상태
EMPLOYEE_PROJECT_EVALUATION
- ID — NUMBER — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER
- PROJECT_ID — NUMBER — NOT NULL
- TASK_SCORE — CHAR(1) — 업무
- TECHNIC_SCORE — CHAR(1) — 기술
- ATTITUDE_SCORE — CHAR(1) — 태도/협업
- TASK_COMMENT — VARCHAR2(4000)
- TECHNIC_COMMENT — VARCHAR2(4000)
- ATTITUDE_COMMENT — VARCHAR2(4000)
- CREATED_BY — VARCHAR2(100)
- CREATED_AT — TIMESTAMP
EXPENSE_MGMT
- EXP_ID — NUMBER — Primary key — NOT NULL
- USAGE_MONTH — CHAR(6) — NOT NULL
- EMPLOYEE_ID — NUMBER — NOT NULL
- EXPENSE_TYPE — VARCHAR2(20) — NOT NULL
- PROJECT_CODE — VARCHAR2(20)
- UNASSIGNED_PROJECT_CODE — VARCHAR2(20)
- AMOUNT — NUMBER(15,0)
- REQUEST_DATE — TIMESTAMP
- STATUS — VARCHAR2(20)
- REMARK — VARCHAR2(2000)
- CLOSE_YN — CHAR(1)
- CREATED_AT — DATE — NOT NULL
- CREATED_BY — VARCHAR2(50) — NOT NULL
- NGW_DOCUMENT_ID — VARCHAR2(100)
EXPENSE_RECEIPT
- RECEIPT_ID — NUMBER — Primary key — NOT NULL
- USAGE_MONTH — CHAR(6) — NOT NULL
- EMPLOYEE_ID — NUMBER — NOT NULL
- PROJECT_CODE — VARCHAR2(20)
- EXP_ID — NUMBER
- ORIGINAL_FILE_NAME — VARCHAR2(500)
- STORED_FILE_NAME — VARCHAR2(500)
- CONTENT_TYPE — VARCHAR2(200)
- FILE_PATH — VARCHAR2(2000)
- CREATED_AT — TIMESTAMP
EXPENSE_USAGE
- USAGE_ID — NUMBER — Primary key — NOT NULL
- USAGE_MONTH — CHAR(6) — NOT NULL
- EMPLOYEE_ID — NUMBER — NOT NULL
- EXP_ID — NUMBER
- CARD_NUMBER — VARCHAR2(20)
- MERCHANT_NAME — VARCHAR2(200) — NOT NULL
- ACCOUNT_CD — VARCHAR2(50) — NOT NULL — 계정코드
- DEBIT_AMT — NUMBER(15,0)
- ERP_CD — VARCHAR2(10)
- RESULT_REFLECT_YN — CHAR(1)
- AMOUNT — NUMBER(15,0) — NOT NULL
- USAGE_DATE — DATE — NOT NULL
- USAGE_DESCRIPTION — VARCHAR2(500) — NOT NULL — 적요
- ATTENDEES — VARCHAR2(4000)
- REMARKS — VARCHAR2(4000)
- CREATED_AT — DATE — NOT NULL
- CREATED_BY — VARCHAR2(50) — NOT NULL
- APPROVAL_NO — VARCHAR2(20)
- CANCEL_YN — CHAR(1)
GPT_MAIL_JOB
- ID — NUMBER
- JOB_KEY — VARCHAR2(50)
- ENABLED — CHAR(1)
- SUBJECT — VARCHAR2(200)
- PROMPT_SYSTEM — CLOB
- PROMPT_USER — CLOB
- MODEL — VARCHAR2(50)
- CRON_EXPR — VARCHAR2(100)
- RECIPIENT_GROUP_KEY — VARCHAR2(50)
- LAST_RUN_AT — TIMESTAMP
- MESSAGE — VARCHAR2(1000)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
MAIL_RECIPIENT_GROUP
- ID — NUMBER — Primary key — NOT NULL
- GROUP_KEY — VARCHAR2(50) — NOT NULL
- GROUP_TYPE — VARCHAR2(50) — NOT NULL
- GROUP_VALUE — VARCHAR2(100) — NOT NULL
MENU_INFO
- MENU_CODE — VARCHAR2(100) — Primary key — NOT NULL
- MENU_NAME — VARCHAR2(200) — NOT NULL — 메뉴명
- MENU_CATEGORY — VARCHAR2(50) — NOT NULL — 메뉴
- API_URL — VARCHAR2(400) — 대표
- HTTP_METHOD — VARCHAR2(20) — 대표
- IS_ACTIVE — CHAR(1) — NOT NULL — 사용
- DISPLAY_ORDER — NUMBER(5,0) — 메뉴
- CREATED_AT — TIMESTAMP — 생성
- CREATED_BY — VARCHAR2(50) — 생성자
- UPDATED_AT — TIMESTAMP — 수정
- UPDATED_BY — VARCHAR2(50) — 수정자
MONTHLY_MANPOWER
- ID — NUMBER(19,0) — Primary key — NOT NULL
- PROJECT_ID — NUMBER(19,0) — NOT NULL
- MONTH — VARCHAR2(7) — NOT NULL
- REVENUE — NUMBER(19,0)
- COST — NUMBER(19,0)
- MANPOWER_TYPE — VARCHAR2(50)
- HQ — VARCHAR2(100)
- ORG_GROUP — VARCHAR2(100)
- CONTRACT_TYPE — VARCHAR2(50)
- PROJECT_CODE — VARCHAR2(50)
- PROJECT_NAME — VARCHAR2(200)
- START_DATE — VARCHAR2(10)
- END_DATE — VARCHAR2(10)
- PM_NAME — VARCHAR2(100)
- CLASSIFICATION — VARCHAR2(50)
- COMPANY_NAME — VARCHAR2(200)
- IS_REGULAR — VARCHAR2(1)
- NAME — VARCHAR2(100)
- RANK — VARCHAR2(50)
- GRADE — VARCHAR2(50)
- INPUT_START_DATE — VARCHAR2(10)
- INPUT_END_DATE — VARCHAR2(10)
- BASE_MM_RATE — NUMBER(10,4)
- MM — NUMBER(10,4)
- ADJUST_MM_RATE — NUMBER(10,4)
- UNIT_PRICE — NUMBER(19,0)
- SUB_UNIT_PRICE — NUMBER(19,0)
- INTERNAL_COST — NUMBER(19,0)
- REMARKS — VARCHAR2(1000)
- TYPE2 — VARCHAR2(50)
- TRANSFER_AMOUNT — NUMBER(19,0)
- CHANGE_REASON — VARCHAR2(500)
- CHANGED_AT — VARCHAR2(19)
- CHANGED_BY — VARCHAR2(50)
- CHANGED_BY_PM_AT — DATE
- CHANGED_BY_PM — VARCHAR2(100)
- EMPLOYEE_ID — NUMBER(19,0) — NOT NULL
- EXPORTED_COUNT — NUMBER(10,0) — NOT NULL — 하도급
NOTICE
- NOTICE_ID — NUMBER
- TITLE — VARCHAR2(255)
- CONTENTS — CLOB
- NOTICE_TYPE — VARCHAR2(100)
- POSTING_ORG_ID — VARCHAR2(4000)
- START_DATE — DATE
- END_DATE — DATE
- IS_ACTIVE — CHAR(1)
- CREATED_AT — DATE
- UPDATED_AT — DATE
- POSTING_POSITION — VARCHAR2(1000)
- PM_ONLY — CHAR(1)
ORGANIZATION
- ORG_ID — NUMBER — Primary key — NOT NULL
- PARENT_ORG_ID — NUMBER(10,0) — 상위
- ORG_LEVEL — VARCHAR2(20) — NOT NULL — 조직의
- ORG_NAME — VARCHAR2(100) — NOT NULL — 조직의
- ORG_TYPE — VARCHAR2(20) — NOT NULL — 조직
- IS_ACTIVE — CHAR(1) — NOT NULL — 조직
- CREATED_AT — DATE — NOT NULL — 레코드
- UPDATED_AT — DATE — NOT NULL — 레코드
- SORT_ORDER — NUMBER(38,0)
PARTNER_CONTRACT
- CONTRACT_ID — NUMBER — Primary key — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL — 프로젝트
- PARTNER_ID — NUMBER — NOT NULL — 협력사
- CONTRACT_AMOUNT — NUMBER(18,2) — NOT NULL — 협력사에게
- CONTRACT_DATE — DATE — 계약
- PAYMENT_CONDITION — VARCHAR2(100) — 대금
- INSURANCE_DETAILS — VARCHAR2(500) — 보증보험
- INSURANCE_FILE_ID — NUMBER — 보증보험
- DESCRIPTION — VARCHAR2(4000) — 계약
- IS_CANCELED — CHAR(1) — 계약
- CREATED_AT — TIMESTAMP — NOT NULL
- CREATED_BY — VARCHAR2(50) — NOT NULL
- UPDATED_AT — TIMESTAMP
- UPDATED_BY — VARCHAR2(50)
PRICE_RATE
- RATE_ID — NUMBER — Primary key — NOT NULL
- APPLY_YEAR — NUMBER(4,0) — NOT NULL — 단가
- ORG_HQ_ID — NUMBER(10,0) — NOT NULL — 단가
- CONTRACT_TYPE — VARCHAR2(20) — NOT NULL — 단가
- POSITION_CODE — VARCHAR2(20) — NOT NULL — 단가
- MONTHLY_RATE — NUMBER(15,0) — NOT NULL — 해당
- IS_ACTIVE — CHAR(1) — NOT NULL — 단가
- CREATED_AT — DATE — NOT NULL — 레코드
- UPDATED_AT — DATE — NOT NULL — 레코드
PROJECT
- ID — NUMBER — Primary key — NOT NULL
- PROJECT_NAME — VARCHAR2(255) — NOT NULL
- PROJECT_CODE — VARCHAR2(100)
- CLIENT_NAME — VARCHAR2(255)
- CONTRACT_COMPANY_NAME — VARCHAR2(100) — 계약사
- START_DATE — DATE
- END_DATE — DATE
- ADMIN_ORG_ID — NUMBER(10,0)
- SALES_ORG_ID — NUMBER(10,0)
- STATUS — VARCHAR2(50)
- CONTRACT_TYPE — VARCHAR2(50)
- FINANCIAL_CODE — VARCHAR2(10) — 재무코드
- VRB1_STATUS_CODE — CHAR(1)
- VRB2_STATUS_CODE — CHAR(1)
- VRB3_STATUS_CODE — CHAR(1)
- VRB4_STATUS_CODE — CHAR(1)
- ADVANCE_TYPE — VARCHAR2(100) — 선금유형
- PAYMENT_CONDITION — VARCHAR2(100) — 수금조건
- PRICE_APLY_TYPE — VARCHAR2(100) — 단가적용유형
- DEPLOYMENT_STATUS_CODE — VARCHAR2(50) — 투입
- DESCRIPTION — VARCHAR2(4000)
- STATUS_CHANGE_AT — TIMESTAMP
- STATUS_CHANGE_USER — VARCHAR2(100)
- CREATED_AT — TIMESTAMP
- CREATED_BY — VARCHAR2(100)
PROJECT_BUDGET
- BUDGET_ID — NUMBER — Primary key — NOT NULL
- PROJECT_CODE — VARCHAR2(100) — NOT NULL
- EMPLOYEE_ID — NUMBER — NOT NULL
- CARD_IDENTIFIER — VARCHAR2(20)
- USAGE_LIMIT_AMOUNT — NUMBER(15,0) — NOT NULL
- EXPIRATION_DATE — DATE
- EXPENSE_TYPE — VARCHAR2(20)
- CREATED_AT — TIMESTAMP — NOT NULL
- REQUESTED_BY — VARCHAR2(100) — NOT NULL
- STATUS — VARCHAR2(50) — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
PROJECT_HISTORY
- ID — NUMBER — Primary key — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL
- PROJECT_COST_ID — NUMBER
- SALES_MANAGER — VARCHAR2(50)
- PROJECT_MANAGER — VARCHAR2(100)
- SALES_TARGET_AMOUNT — NUMBER(15,0)
- EXPENSE_AMOUNT — NUMBER(15,0)
- START_DATE — DATE
- END_DATE — DATE
- ADMIN_ORG_ID — NUMBER(10,0)
- SALES_ORG_ID — NUMBER(10,0)
- STATUS — VARCHAR2(50)
- CONTRACT_TYPE — VARCHAR2(50)
- FINANCIAL_CODE — VARCHAR2(10)
- ADVANCE_TYPE — VARCHAR2(100)
- PAYMENT_CONDITION — VARCHAR2(100)
- DESCRIPTION — VARCHAR2(4000)
- CHANGED_AT — TIMESTAMP
- CHANGED_BY — VARCHAR2(100)
PROJECT_MONTHLY_REVENUE
- ID — NUMBER — Primary key — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL
- YEAR — NUMBER(4,0) — NOT NULL
- MONTH — NUMBER(2,0) — NOT NULL
- REVENUE — NUMBER(15,2)
- INTERNAL_COST — NUMBER(15,2)
- EXTERNAL_COST — NUMBER(15,2)
- EXPENSE_COST — NUMBER(15,2)
- PROFIT — NUMBER(15,2)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
PROJECT_PAYMENT_PLAN
- ID — NUMBER — Primary key — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL
- PLANNED_PAYMENT_DATE — DATE — NOT NULL
- AMOUNT — NUMBER(15,2) — NOT NULL
- MILESTONE — VARCHAR2(255)
- STATUS — VARCHAR2(50)
- REMARKS — VARCHAR2(500)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
PROJECT_TRANSFER_MGMT
- ID — NUMBER — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL
- FROM_PROJECT_ID — NUMBER
- TRANSFER_AMT — NUMBER(15,0)
- TRANSFER_DATE — DATE
- REMARK — VARCHAR2(4000)
- CREATE_AT — TIMESTAMP
- CREATE_BY — VARCHAR2(50)
PWA_PUSH_SUBSCRIPTION
- SUBSCRIPTION_ID — NUMBER — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER — NOT NULL
- ENDPOINT — VARCHAR2(1000) — NOT NULL
- P256DH — VARCHAR2(300) — NOT NULL
- AUTH — VARCHAR2(300) — NOT NULL
- USER_AGENT — VARCHAR2(500)
- DEVICE_TYPE — VARCHAR2(20)
- IS_ACTIVE — VARCHAR2(1) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
ROLE_PERMISSION
- ROLE_CODE — VARCHAR2(50) — Primary key — NOT NULL
- RESOURCE_NAME — VARCHAR2(50) — Primary key — NOT NULL
- CAN_LIST — CHAR(1)
- CAN_SHOW — CHAR(1)
- CAN_CREATE — CHAR(1)
- CAN_EDIT — CHAR(1)
- CAN_DELETE — CHAR(1)
- CAN_EXPORT — CHAR(1)
- CAN_APPROVE — CHAR(1)
SALES_GOAL
- GOAL_ID — NUMBER — Primary key — NOT NULL
- APPLY_YEAR — NUMBER(4,0) — NOT NULL — 목표
- APPLY_MONTH — NUMBER(2,0) — NOT NULL — 목표
- ORG_GROUP_ID — NUMBER(10,0) — NOT NULL — 영업사원이
- MONTHLY_ORDER_GOAL_AMOUNT — NUMBER(15,0) — NOT NULL — 해당
- MONTHLY_ORDER_ADJUST_AMOUNT — NUMBER(15,0) — NOT NULL — 해당
- MONTHLY_SALES_GOAL_AMOUNT — NUMBER(15,0) — NOT NULL — 해당
- MONTHLY_SALES_ADJUST_AMOUNT — NUMBER(15,0) — NOT NULL — 해당
- IS_ACTIVE — CHAR(1) — NOT NULL
- CREATED_AT — DATE — NOT NULL — 레코드
- CREATED_BY — VARCHAR2(50)
- UPDATED_AT — DATE — NOT NULL — 레코드
- UPDATED_BY — VARCHAR2(50)
SEMI_REGULAR_PRICE_RATE
- RATE_ID — NUMBER — Primary key — NOT NULL
- APPLY_YEAR — NUMBER(4,0) — NOT NULL — 단가
- POSITION_CODE — VARCHAR2(20) — NOT NULL — 단가
- MONTHLY_RATE — NUMBER(15,0) — NOT NULL — 해당
- IS_ACTIVE — CHAR(1) — NOT NULL — 단가
- CREATED_AT — DATE — NOT NULL — 레코드
- UPDATED_AT — DATE — NOT NULL — 레코드
USERS
- ID — NUMBER — Primary key — NOT NULL
- USERNAME — VARCHAR2(50) — NOT NULL
- PASSWORD — VARCHAR2(100) — NOT NULL
- EMAIL — VARCHAR2(100)
- ROLE — VARCHAR2(50)
- STATUS — VARCHAR2(10)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- LAST_LOGIN — TIMESTAMP
- USER_ID — VARCHAR2(100) — LDAP