SSSSSSSSSSSSSSSSSSS

Tables (20)

ACMSLT_DIRECT_COST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • PURPOSE — varchar2(30) — NOT NULL
  • EXPENS_AMT — numeric(19,2) — NOT NULL
  • REMARK — varchar2(50)

ACMSLT_LABOR_COST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • USER_IDN — bigint(8) — NOT NULL
  • JOB_YMD — varchar2(8) — NOT NULL
  • UNIT_PRICE — numeric(19,2) — NOT NULL
  • LBCST — numeric(19,2) — NOT NULL
  • LBCST_SE — varchar2(4) — NOT NULL
  • REMARK — varchar2(50)

ACMSLT_OUTORD_COST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • ENTRPS_NM — varchar2(20) — NOT NULL
  • QUANTITY — varchar2(100) — NOT NULL
  • UNIT_PRICE — numeric(19,2) — NOT NULL
  • OUTORD_AMT — numeric(19,2) — NOT NULL
  • REMARK — varchar2(50)

ACMSLT_OVERHEAD_COST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • PURPOSE — varchar2(30) — NOT NULL
  • EXPENS_AMT — numeric(19,2) — NOT NULL
  • REMARK — varchar2(50)

BSNM_SHARE_ST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • CNSRTM_NM — varchar2(30) — NOT NULL
  • PAY_AMT — numeric(19,2) — NOT NULL
  • AMT_PER — bigint(3) — NOT NULL

EXPENSE_RATIO

  • SHT_IDN — bigint — Primary key — NOT NULL
  • EXP_RAT — numeric(8.2) — NOT NULL
  • STDR_YMD — varchar(8) — NOT NULL

GITT_DOMN

  • DOMN_ID — varchar2(32) — Primary key — NOT NULL
  • DOMN_NM — varchar2(128) — NOT NULL

GITT_DOMN_CODE

  • DOMN_ID — varchar2(32) — Foreign key → GITT_DOMN.DOMN_ID — NOT NULL
  • CODE_ID — varchar2(32) — NOT NULL
  • CODE_NM — varchar2(128) — NOT NULL
  • USE_AT — varchar2(1) — NOT NULL

GITT_FILE

  • FILE_NO — bigint — Primary key — NOT NULL
  • FILE_STRE_COURS — varchar2(2048)
  • STRE_FILE_NM — varchar2(256)
  • ORG_FILE_NM — varchar2(256)
  • FILE_EXTSN — varchar2(16)
  • FILE_SIZE — bigint

GITT_FILE_INFO

  • SHT_IDN — bigint — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • FILE_NO — bigint — NOT NULL
  • FILE_TYPE — varchar(10) — NOT NULL

GITT_PROCESS

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PROCESS — varchar(32) — NOT NULL
  • JOB_TIME — numeric(4,1) — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL

HNF_INPT_PLAN

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • USER_IDN — bigint(8) — NOT NULL
  • TCHNLGY_TY — varchar2(30) — NOT NULL
  • UNIT_PRICE — bigint(19.2) — NOT NULL

JOB_ST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • USER_IDN — bigint(8) — NOT NULL
  • JOB_TIME — numeric(2,1) — NOT NULL
  • LOD_YMD — varchar2(8) — NOT NULL

PROJECT_INFO

  • PRO_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_CDE — varchar2(30) — NOT NULL
  • PRO_NM — varchar2(50) — NOT NULL
  • PAY_AMT — bigint(19.2) — NOT NULL
  • BEG_YMD — varchar2(8) — NOT NULL
  • FNS_YMD — varchar2(8)
  • RFN_YMD — varchar2(8)
  • ORNT — varchar2(30) — NOT NULL
  • CHRG_DEPT — varchar2(30) — NOT NULL
  • CHRG_NM — varchar2(10) — NOT NULL
  • NRH_TEL — varchar2(11)
  • USER_TEL — varchar2(11)
  • PRO_RISK — varchar2(200)
  • PRO_STAT — varchar2(30) — NOT NULL
  • MNG_NM — varchar2(10)
  • PM_NM — varchar2(10)
  • BSN_NM — varchar2(10)
  • LOD_YMD — varchar2(8)
  • ORG_AMT — bigint(19.2)

PRTN_DIRECT_COST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • PURPOSE — varchar2(30) — NOT NULL
  • EXPENS_AMT — numeric(19,2) — NOT NULL
  • REMARK — varchar2(50)

PRTN_LABOR_COST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • USER_IDN — bigint(8) — NOT NULL
  • JOB_YMD — varchar2(8) — NOT NULL
  • UNIT_PRICE — numeric(19,2) — NOT NULL
  • LBCST — numeric(19,2) — NOT NULL
  • LBCST_SE — varchar2(4) — NOT NULL
  • REMARK — varchar2(50)

PRTN_OUTORD_COST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • ENTRPS_NM — varchar2(20) — NOT NULL
  • QUANTITY — varchar2(100) — NOT NULL
  • UNIT_PRICE — numeric(19,2) — NOT NULL
  • OUTORD_AMT — numeric(19,2) — NOT NULL
  • REMARK — varchar2(50)

PRTN_OVERHEAD_COST

  • SHT_IDN — bigint(8) — Primary key — NOT NULL
  • PRO_IDN — bigint(8) — NOT NULL
  • PURPOSE — varchar2(30) — NOT NULL
  • EXPENS_AMT — numeric(19,2) — NOT NULL
  • REMARK — varchar2(50)

UNIT_PRICE

  • UNIT_IDN — bigint(8) — Primary key — NOT NULL
  • TCHNLGY_GRAD — varchar2(30) — NOT NULL
  • UNIT_PRICE — numeric(19,2) — NOT NULL
  • STDR_YMD — varchar2(8) — NOT NULL
  • REMARK — varchar2(50)
  • USER_CLSF — varchar2(30) — NOT NULL

USER_INFO

  • USER_IDN — bigint(8) — Primary key — NOT NULL
  • USER_NM — varchar2(30) — NOT NULL
  • USER_CLSF — varchar2(30) — NOT NULL
  • USER_ID — varchar2(32) — NOT NULL
  • PASSWORD — varchar2(512) — NOT NULL
  • USER_SE — varchar2(1) — NOT NULL
  • UNIT_IDN — bigint(8) — NOT NULL
  • USER_TEL — varchar2(11)
  • USER_MAIL — varchar2(50)
  • BSNS_TEL — varchar2(11)
  • BRFFC — varchar2(20)
  • DEPT — varchar2(20)
  • USER_TYPE — varchar2(30) — NOT NULL