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