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