Dynamic News SQL Example 1: Item Schema, nisetup.sql

Here's the SQL from nisetup.sql, that defines the structure of a news item:

CREATE TABLE news.NEWS_ITEMS 
( ID   NUMBER NOT NULL, 
  TITLE           VARCHAR2(200), 
  URL             VARCHAR2(200),  
  DESCRIPTION     VARCHAR2(2000),  
  ENTRY_DATE      DATE,  
  CATEGORY_ID     NUMBER,  
  SUB_CATEGORY_ID NUMBER,  
  TYPE_ID         NUMBER,  
  SUBMITTED_BY_ID NUMBER,  
  EXPIRATION_DATE DATE,  A
  APPROVED_FLAG   VARCHAR2(1)
);