Humble Trader

Friday, September 01, 2006

Get HTML - Table STA.RAW_HTML Specification

  • Name: RAW_HTML
  • Description: Holds raw external-site HTML in VARCHAR2s of up 2000 characters in length. Rows in this table hold pieces of HTML in no particular structure apart from their order on the page.
  • Columns:
    • Name: RUN_NO
      • Description: Part of primary Key. The Run Number that created this row. Foreign key to HTML_PAGE_ACCESS.RUN_NO.
      • Datatype: NUMBER
      • Null: No
      • Unique: No
      • Part of PK: Yes
    • Name: PIECE_SEQ
      • Description: Part of primary key. Maintains the order of the piece of the HTML page that this piece was stored in.
      • Datatype: NUMBER
      • Null: No
      • Unique: No
      • Part of PK: Yes
    • Name: HTML_PIECE
      • Description: The piece of HTML fetched from the web page.
      • Datatype: VARCHAR2(2000)
      • Null: No
      • Unique: No
      • Part of PK: No
    • Name: INS_TSP
      • Description: Insert timestamp.
      • Datatype: DATE
      • Null: No
      • Unique: No
      • Part of PK: No

0 Comments:

Post a Comment

<< Home