Well Test Data Model

Well Test ERD

Well%20Test
Figure 1. Well Test ERD

Well Test Tables Description

Table Description

WELL_TEST

The well test table contains descriptive information concerning test date, test time duration, test location, test type and test validation general data information for a well test.

WELL_TEST_FLOW_PERIOD

This table is used to describe how many period in this whole well test job, and its basic information for datetime of each individual period.

WELL_TEST_FLOW_MEASUREMENT

This table is used to record the volume and rate of each product kind, which is measured on the stable flow stage of well test.

WELL_TEST_MEASUREMENT

This table is used to record measured properties those are not relevant with product kind on the stable flow stage of well test, such as pressure, temperature.

R_VALIDATE_RESULT

This table is used to Specify well test validation results, such as failed, passed, passed with changes, or unknown.

R_REPORTING_PRODUCT

Specifies the product kinds, such as oil, water, gas, condensate, sediment and water, and sand, which are commonly tested in well test.

R_WELL_TEST_TYPE_PRODUCT

Identifies the general type of test used to evaluate the potential of the well.

R_VALIDATE_RESULT

This table is used to Specify well test validation results, such as failed, passed, passed with changes, or unknown.

R_MEASUREMENT

This reference table describes the various measurement that used for well tests, and routine daily or periodically measure job.

R_FLOW_KIND

This table is used to Specify the well test for production or injection.

WELL_TEST_ALLOCATION_FACTOR

This table is used to record the allocation factor for each product phase relative to the overall volume of the test.