df
Tables (35)
ACCOUNT
- ACCOUNT_CODE — NUMBER(10) — NOT NULL — Account
- AFF_CODE — NUMBER(10) — Affiliation
- ID — VARCHAR2(254) — NOT NULL — User
- PASSWORD — VARCHAR2(254) — NOT NULL — User
- NAME — VARCHAR2(50) — User
- STATUS — NUMBER(1) — NOT NULL — Permanent(0:
- CONTACT — VARCHAR2(20) — Contact
- REG_DATE — DATE — NOT NULL — Registration
- MOD_DATE — DATE — Modification
- TYPE — NUMBER(1) — NOT NULL — Permanent
- NOTE — VARCHAR2(500) — Note
- LAST_LOGIN_DATE — DATE — Last
AFFILIATION
- AFF_CODE — NUMBER(10) — NOT NULL — Affiliation
- BIZ_REG_NO — VARCHAR2(13) — NOT NULL — Business
- ORG_CODE — NUMBER(4) — NOT NULL — Organization
- AFF_NAME — VARCHAR2(30) — NOT NULL — Affiliation
- DELYN — CHAR — NOT NULL — Delete
- CONTACT — VARCHAR2(20) — NOT NULL — Contact
- ADDRESS — VARCHAR2(255) — Adress
- REG_DATE — DATE — NOT NULL — Registration
- MOD_DATE — DATE — Modification
- CEO_NAME — VARCHAR2(100) — Representative(CEO)
- NOTE — VARCHAR2(500) — NOTE
- MOD_USER — VARCHAR2(254) — Modification
AGGREGATE_GRADATION_ATTRIBUTE
- GRAD_ATTR_CODE — NUMBER(10) — Combined
- MIX_CODE — NUMBER(10) — NOT NULL — Mixture
- GRAD_SIVE_CODE — NUMBER(10) — Aggregate
- USE_YN — CHAR — NOT NULL — Use
- MIN_RATE — NUMBER(5, 2) — Minimum
- MAX_RATE — NUMBER(5, 2) — Maximum
- MIX_SPEC_CODE — NUMBER(10) — NOT NULL — General
AGGREGATE_GRADATION_SIEVE
- GRAD_SIEVE_CODE — NUMBER(10) — Gradation
- ASTM — VARCHAR2(20) — Sive
- SIZE — NUMBER(5, 3) — Gradation
- USE_YN — CHAR — NOT NULL — Use
AGGREGATE_GRADATION_VALUE
- GRAD_CODE — NUMBER(10) — Gradation
- GRAD_ATTR_CODE — NUMBER — Aggregate
- INPUT_RATE — NUMBER(3, 2) — NOT NULL — Aggregate
- PASS_YN — CHAR — Gradation
- REG_DATE — DATE — Registration
ASSIGNED_MANAGER
- ASSIGNED_CODE — NUMBER(10) — NOT NULL — Assigned
- CONSTRUCTION_CODE — NUMBER(10) — NOT NULL — Construction
- ACCOUNT_CODE — NUMBER(10) — NOT NULL — Account
- POSITION — VARCHAR2(20) — Person
- COMMENT — VARCHAR2(100) — Note
- MANAGER_EMAIL — VARCHAR2(254) — NOT NULL — EMAIL
- EXT_DEPARTMENT — VARCHAR2(100)
- USE_YN — VARCHAR2(1) — NOT NULL
CODE
- CODE — NUMBER(10) — NOT NULL
- CODE_NAME — VARCHAR2(20)
- CARTEGORY — NUMBER(10)
CONSTRUCTION
- CONSTRUCTION_CODE — NUMBER(10) — NOT NULL — Construction
- REG_USER — NUMBER(10) — NOT NULL — Registration
- MOD_USER — NUMBER(10) — NOT NULL — Modification
- CONSTRUCTION_NAME — VARCHAR2(255) — NOT NULL — Construction
- REG_DATE — DATE — NOT NULL — Registration
- MOD_DATE — DATE — Modification
- STATUS — NUMBER(1) — NOT NULL — Construction
- AMOUNT — NUMBER(32) — NOT NULL
- CONTRACT_NO — NUMBER(32) — Contract
- CONTRACT_DATE — DATE — Contract
- START_DATE — DATE — NOT NULL — Construnction
- SKED_COMPL_DATE — DATE — NOT NULL
- ACTUAL_COMPL_DATE — DATE — Actual
- ORDER_DATE — DATE — Construction
- MGMT_NO — NUMBER(32) — Management
- DETAILS — VARCHAR2(256) — Construction
- EXTENSION — NUMBER(8) — NOT NULL
- DEPOSIT — VARCHAR2(50) — Construction
- DELIV_WEIGHT — NUMBER(5) — Delivery
- BPJN_AFF_CODE — NUMBER(10) — NOT NULL — Ordering
- SPEC_CODE — NUMBER(10) — NOT NULL — General
- WEARING — NUMBER — Wearing
- BINDER — NUMBER — Binder
- BASE — NUMBER — Base
- START_STATION — NUMBER
- START_STATION_DIST — NUMBER
- DIST_UNIT — NUMBER
CONSTRUCTION_CONTRACT
- CONSTRUCTION_CODE — NUMBER(10) — Primary key — NOT NULL — Construction
- AFF_CODE — NUMBER(10) — Primary key — NOT NULL — Affiliation
- CONTRACT_CODE — NUMBER(10) — Contract
- CONTRACT_DATE — DATE — Contract
- CONTRACT_NO — VARCHAR2(20) — Contract
- PRICE — NUMBER(32, 2) — Contract
- QUANTITY — NUMBER(32, 2) — Contract
- REG_DATE — DATE — NOT NULL
- USE_YN — VARCHAR2(1) — NOT NULL
CONSTRUCTION_EXPR
- CON_EXPR_CODE — NUMBER(10) — NOT NULL
- CORE_CODE — NUMBER(10) — NOT NULL
- WEIGHT_IN_AIR — NUMBER(6, 2)
- WEIGHT_SURFACE_DRY — VARCHAR2(255)
- WEIGHT_UNDERWATER — VARCHAR2(255)
- VOLUME — VARCHAR2(255)
- DENSITY_ASG — VARCHAR2(255)
- DENSITY_THEO — VARCHAR2(255)
- VOLUME_ASPAHLT — VARCHAR2(255)
- VOID_RATIO — VARCHAR2(255)
- POROCITY — VARCHAR2(255)
- SATURATION — VARCHAR2(255)
- COMPACTION — VARCHAR2(255)
- LAYER — NUMBER(1)
- SEQ — NUMBER(1)
CONSTRUCTION_QA_STANDARD
- STANDARD_CODE — NUMBER(10) — NOT NULL
- STD_VALUE — NUMBER(10)
- TYPE — NUMBER(1)
DMF_BIN_VALUE
- DMF_BIN_VALUE_CODE — NUMBER(10) — Bin
- DMF_LINK_CODE — NUMBER(10) — NOT NULL — Dmf
- COLDBIN_CA — NUMBER(10, 2) — NOT NULL — Coldbin
- COLDBIN_MA — NUMBER(10, 2) — NOT NULL — Coldbin
- COLDBIN_FA — NUMBER(10, 2) — NOT NULL — Coldbin
- COLDBIN_FILLER_CEMENT — NUMBER(10, 2) — NOT NULL — Coldbin
- HOTBIN_ASPHALT_CONTENT — NUMBER(10, 2) — NOT NULL — Hobin
- HOTBIN_4 — NUMBER(10, 2) — NOT NULL — Hobin
- HOTBIN_3 — NUMBER(10, 2) — NOT NULL — Hobin
- HOTBIN_2 — NUMBER(10, 2) — NOT NULL — Hobin
- HOTBIN_1 — NUMBER(10, 2) — NOT NULL — Hobin
- HOTBIN_FILLER_CEMENT — NUMBER(10, 2) — NOT NULL — Hobin
DMF_ITEM_VALUE
- DMF_ITEM_VALUE_CODE — NUMBER(10) — DMF
- DMF_LINK_CODE — NUMBER(10) — NOT NULL — DMF
- ITEM_CODE — NUMBER(10) — NOT NULL — Item
- ADJUSTED_MAX_VALUE — NUMBER(10, 2) — Maximum
- ADJUSTED_MIN_VALUE — NUMBER(10, 2) — Minimum
- INPUT_VALUE — NUMBER(10, 3) — Input
DMF_LINK
- DMF_LINK_CODE — NUMBER(10) — Design
- CONSTRUCTION_CODE — NUMBER(10) — NOT NULL — Construction
- AFF_CODE — NUMBER(10) — NOT NULL — Affiliation
- MIX_CODE — NUMBER(10) — NOT NULL — Mixture
- TEST_DATE — DATE — Test
- REG_DATE — DATE — Registration
- NOTE — VARCHAR2(500) — Note
- FILE_CODE — NUMBER(10) — File
- MIX_IDENTIFIER — VARCHAR2(255) — Unique
- LAYER — NUMBER(1) — 1:
FILE
- FILE_CODE — NUMBER(10) — NOT NULL — File
- PATH — VARCHAR2(200) — NOT NULL — Upload
- DELYN — CHAR — NOT NULL — Delete
- REG_USER — NUMBER(10) — NOT NULL — Registration
- REG_DATE — DATE — NOT NULL — Registration
- DEL_DATE — DATE — Delete
INVOICE
- INVOICE_CODE — NUMBER(10) — NOT NULL
- STATION_CODE — NUMBER(10) — NOT NULL
- APPROVAL_CODE — NUMBER(10)
- INVOICE_NO — NUMBER(20) — NOT NULL
- PROVIDED_FROM — NUMBER(6) — NOT NULL
- PRODUCER — VARCHAR2(20) — NOT NULL
- ORDERED — NUMBER(1) — NOT NULL
- DATE — DATE — NOT NULL
- VEHICLE_NO — NUMBER — NOT NULL
- RAW_DATA — CLOB
MIXTURE
- MIX_CODE — NUMBER(10) — Asphalt
- MIX_GROUP_CODE — NUMBER(10) — Mixture
- MIX_NAME — VARCHAR2(50) — NOT NULL — Asphalt
- MIX_DESCRIPTION — VARCHAR2(255) — Asphalt
- SEQ — NUMBER(5) — NOT NULL — Asphalt
MIXTURE_GROUP
- MIX_GROUP_CODE — NUMBER(10) — Mixture
- MAJOR_GROUP — VARCHAR2(100)
- MINOR_GROUP — VARCHAR2(100)
- SEQ — NUMBER(5)
MIXTURE_ITEM_ATTRIBUTE
- ITEM_CODE — NUMBER(10) — Item
- ITEM_NAME — VARCHAR2(100) — NOT NULL — Item
- COMMONYN — CHAR — NOT NULL — Common
- CATEGORY — VARCHAR2(255) — Mixture
- UNIT — VARCHAR2(50) — Unit
- USEYN — CHAR — Use
- SPEC_CODE — NUMBER(10) — NOT NULL — General
MIXTURE_ITEM_VALUE
- ITEM_VALUE_CODE — NUMBER(10) — Mixture
- ITEM_CODE — NUMBER(10) — NOT NULL — Item
- MIX_GROUP_CODE — NUMBER(10) — Mixture
- MIN_VALUE — NUMBER(10, 2) — Reference
- MAX_VALUE — NUMBER(10, 2) — Reference
ORGANIZATION
- ORG_CODE — NUMBER(4) — NOT NULL — Organization
- ORG_NAME — VARCHAR2(20) — NOT NULL — Organization
PASSWORD_RESET_TOKEN
- TOKEN_CODE — NUMBER — NOT NULL — UNIQUE
- TOKEN — VARCHAR2(255) — NOT NULL — Token
- CREATE_DATE — DATE — token
- EXPIRE_DATE — TIMESTAMP(6) — NOT NULL — Token
- ACCOUNT_CODE — NUMBER(10) — NOT NULL — account
QC_CORE
- QC_CORE_CODE — NUMBER(10) — Primary key — NOT NULL — QC
- STATION_CODE — NUMBER(10) — NOT NULL — Station
- CON_CONFIRM_DATE — DATE — ??
- PPK_CONFIRM — NUMBER(1) — NOT NULL — PPK
- PPK_CONFIRM_DATE — DATE — PPK
- REG_DATE — DATE — NOT NULL — Registration
- CON_CONFIRM_USER — NUMBER(10) — ??
- PPK_CONFIRM_USER — NUMBER(10) — PPK
- REG_USER — NUMBER(10) — NOT NULL — Registration
- CON_CONFIRM — NUMBER(1) — NOT NULL — ??
- IS_TESTED — NUMBER(1) — NOT NULL — Tested
- CORE_ID — VARCHAR2(20) — NOT NULL — Core
- DMF_LINK_CODE — NUMBER(10) — Dmf
- RESULT — NUMBER(1) — 코어
- LATITUDE — NUMBER(8, 6)
- LONGITUDE — NUMBER(9, 6)
- DEL_YN — CHAR
- DEL_DATE — DATE
- STATION — NUMBER
- STATION_DIST — NUMBER
QC_CORE_PICTURE
- PICTURE_CODE — NUMBER(10) — NOT NULL — Picture
- QC_CORE_CODE — NUMBER(10) — NOT NULL — QC
- FILE_CODE — NUMBER(10) — NOT NULL — File
- LATITUDE — NUMBER(8, 6) — NOT NULL — Latitude
- LONGITUDE — NUMBER(9, 6) — NOT NULL — Longitude
- REG_DATE — DATE
- DEL_YN — CHAR
- DEL_DATE — DATE
QC_CORE_TEST
- QC_CORE_TEST_CODE — NUMBER
- LAYER — NUMBER — 1:
- THICKNESS — NUMBER(4) — Core
- WEIGHT_IN_AIR — NUMBER(8, 3)
- WEIGHT_SURFACE_DRY — NUMBER(8, 3)
- WEIGHT_UNDER_WATER — NUMBER(8, 3)
- VOLUME — NUMBER(8, 3)
- DENSITY_ASG — NUMBER(8, 3) — DENSITY
- DENSITY_THEORY — NUMBER(8, 3)
- ASPHALT_VOLUME — NUMBER(8, 3)
- VIM — NUMBER(8, 3)
- VMA — NUMBER(8, 3)
- VFB — NUMBER(8, 3)
- COMPACTION_DEGREE — NUMBER(8, 3) — Density_asg,
- QC_CORE_CODE — NUMBER(10)
- PAY_FACTOR_COMPACTION — NUMBER(4, 1) — pay
- DEL_YN — CHAR
- DEL_DATE — DATE
- PAY_FACTOR_THICKNESS — NUMBER(4, 1)
- REG_DATE — DATE — Registration
- DMF_LINK_CODE — NUMBER
- THICK_DIFF — NUMBER(4) — 실제
QC_CORE_THICKNESS
- THICKNESS_CODE — NUMBER(10)
- CONSTRUCTION_CODE — NUMBER(10) — NOT NULL
- STATION_NO — NUMBER
- DISTANCE — NUMBER
- REG_DATE — DATE
- MOD_DATE — DATE
- USE_YN — CHAR — Use
- WEARING — NUMBER — NOT NULL
- BINDER — NUMBER — NOT NULL
- BASE — NUMBER — NOT NULL
QC_CORE_THICKNESS_RANGE
- TOLERANCE_CODE — NUMBER(10) — Tolerance
- SPEC_CODE — NUMBER(10) — NOT NULL — General
- MIX_CODE — NUMBER(10) — NOT NULL — Mixture
- MINIMUM_THICKNESS — NUMBER — NOT NULL — Minimum
- TOLERANCE — NUMBER — NOT NULL — Tolrance
- USE_YN — CHAR — NOT NULL — Use
QC_TEMPERATURE
- QC_TEMP_CODE — NUMBER(10) — NOT NULL — QC
- STATION_CODE — NUMBER(10) — NOT NULL — Station
- TYPE — NUMBER(1) — NOT NULL — 1:
- LAYER — NUMBER(1) — NOT NULL — 1:
- TEMPERATURE — NUMBER(4, 1) — NOT NULL — Temperature
- VEHICLE_NUMBER — VARCHAR2(10) — Number
- TOTAL_WEIGHT — NUMBER(4) — Total
- COMPACTION — NUMBER(1) — 0:
- CON_CONFIRM — NUMBER(1) — NOT NULL — ??
- CON_CONFIRM_DATE — DATE — ??
- CON_CONFIRM_USER — NUMBER(10) — ??
- PPK_CONFIRM — NUMBER(1) — NOT NULL — PPK
- PPK_CONFIRM_DATE — DATE — PPK
- PPK_CONFIRM_USER — NUMBER(10) — PPK
- REG_DATE — DATE — NOT NULL — Registration
- REG_USER — NUMBER(10) — NOT NULL — Registration
- INVOICE_NO — NUMBER(10)
- RESULT — NUMBER(1) — 0:
- LATITUDE — NUMBER(8, 6)
- LONGITUDE — NUMBER(9, 6)
- DEL_YN — CHAR
- DEL_DATE — DATE
- STATION — NUMBER
- STATION_DIST — NUMBER
QC_TEMP_PICTURE
- PICTURE_CODE — NUMBER(10) — NOT NULL — Picture
- QC_TEMP_CODE — NUMBER(10) — NOT NULL — QC
- FILE_CODE — NUMBER(10) — NOT NULL — File
- LATITUDE — NUMBER(8, 6) — NOT NULL — Latitude
- LONGITUDE — NUMBER(9, 6) — NOT NULL — Longitude
- REG_DATE — DATE
- DEL_YN — CHAR
- DEL_DATE — DATE
REAL_TIME_LOCATION
- LOC_CODE — NUMBER
- ACCOUNT_CODE — NUMBER(10) — NOT NULL
- LATITUDE — NUMBER(8, 6)
- LONGITUDE — NUMBER(9, 6)
- REG_DATE — DATE
- ACCURACY — NUMBER(4)
- STABLE_LATITUDE — NUMBER(8, 6)
- STABLE_LONGITUDE — NUMBER(9, 6)
SPECIFICATION
- SPEC_CODE — NUMBER(10) — General
- SPEC_NAME — VARCHAR2(100) — NOT NULL — Specification
- NOTE — VARCHAR2(100) — Specification
STATION
- STATION_CODE — NUMBER(10) — NOT NULL — Station
- CONSTRUCTION_CODE — NUMBER(10) — NOT NULL — Construction
- STATION_NO — NUMBER(5) — NOT NULL — sequence
- START_STATION — NUMBER
- END_STATION — NUMBER
- START_STATION_DIST — NUMBER
- END_STATION_DIST — NUMBER
- USE_YN — CHAR — NOT NULL — Use
- REG_DATE — DATE
- MOD_DATE — DATE — Modification
TEMPERATURE_STANDARD_ATTRIBUTE
- AT_ATTRIBUTE_CODE — NUMBER(10) — Asphalt
- NAME — VARCHAR2(200) — Name
- MIN_TEMPERATURE — NUMBER(5, 2) — Minimum
- MAX_TEMPERATURE — NUMBER(5, 2) — Maximum
- SPEC_CODE — NUMBER(10) — NOT NULL — General
- TYPE — NUMBER(1) — 1:
- COMPACTION — NUMBER(1) — 0:
TEMPERATURE_STANDARD_VALUE
- AT_VALUE_CODE — NUMBER(10) — Asphalt
- AT_ATTRIBUTE_CODE — NUMBER(10) — NOT NULL — Asphalt
- MIN_TEMPERATURE — NUMBER(5) — Min
- MAX_TEMPERATURE — NUMBER(5) — Max
- CONSTRUCTION_CODE — NUMBER(10) — NOT NULL — Construction
TMP_TEST
- VALUE — VARCHAR2(20)
- REGDATE — DATE