 |
|||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||
Tables and Columns
TWL_STATION_SKETCH
| station_number | A six-digit number normally referred to as the "MEDS" station number. Presently "MEDS" station numbers are only 5 digits, the six digit field will allow for future expansion. | NUMBER (6) Foreign Key |
| account | This field is system set with user account info for update and delete privileges. | VARCHAR2 (16) |
| sketch_number | Autogenerated unique number identifying a sketch. | NUMBER (6) |
| DBE_TIME | Database Entry Time - System set. | DATE |
| DBU_TIME | Database Update Time - System set. | DATE |
| status | This field will indicate whether the sketch is currently "ACTIVE" or "HISTORICAL". | VARCHAR2 (16) check list |
| graphic | This field will contain a gif89a image (Have to be inserted into the database by MEDS). | LONG RAW |
Status Check List: ACTIVE or HISTORICAL
| Last Updated: 2009-09-10 |
▲ Site Map |
Webmaster Important Notices |