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