Get HTML - Table CTL.HTML_PAGE_ACCESS Specification

• Name: HTML_PAGE_ACCESS
• Description: Holds a record of when a web page was accessed.
• Columns:
• Name: RUN_NO
  
• Description: Primary key and foreign Key from HTML_PAGES.RUN_NO.
• Datatype: NUMBER
• Null: No
• Unique: Yes
  
• Part of PK: Yes
  
• Name: HTML_PAGE_NAME
  
• Description: Foreign key from HTML_PAGES.NAME.
  
• Datatype: VARCHAR2(30)
  
• Null: No
• Unique: No
  
• Part of PK: No
  
• Name: STATUS
  
• Description: Status of the access. One of
  FETCHING, FETCHED, PARSED, PARSING or FAILED.
• Datatype: VARCHAR2(10)
  
• Null: No
• Unique: No
• Part of PK: No
  
• Name: START_TSP
• Description: Timestamp of when the process that accesses the page was started.
• Datatype: DATE
• Null: No
• Unique: No
• Part of PK: No