Skip Headers

Oracle® Database Lite Oracle Lite Client Guide Release 10.3 Part Number E12548-02 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| View PDF

# B Catalog Views for the Oracle Lite Client

T he following are the SQLRT and other system catalogs that are included in the client Oracle Lite database:

- Section B.1, "ALL_COL_COMMENTS"

- Section B.2, "ALL_CONSTRAINTS"

- Section B.3, "ALL_CONS_COLUMNS"

- Section B.4, "ALL_DEPENDENCIES"

- Section B.5, "ALL_INDEXES"

- Section B.6, "ALL_IND_COLUMNS"

- Section B.7, "ALL_OBJECTS"

- Section B.8, "ALL_PRIVILEGES"

- Section B.9, "ALL_SEQUENCES"

- Section B.10, "ALL_SYNONYMS"

- Section B.11, "ALL_TABLES"

- Section B.12, "ALL_TAB_COLUMNS"

- Section B.13, "ALL_TAB_COMMENTS"

- Section B.14, "ALL_USERS"

- Section B.15, "ALL_VIEWS"

- Section B.16, "POL__ALLOBJ"

- Section B.17, "POL__COLUSAGE"

- Section B.18, "POL__COMMENT"

- Section B.19, "POL__CONS"

- Section B.20, "POL__DATABASE_PARAMETERS"

- Section B.21, "POL__INDICES"

- Section B.22, "POL__INDICESDT"

- Section B.23, "POL__PROCEDURES"

- Section B.24, "POL__PROCEDURE_COLUMNS"

- Section B.25, "POL__SCHEMATA"

- Section B.26, "POL__SEQ"

- Section B.27, "POL__SYNONYM"

- Section B.28, "POL__TBLCONS"

- Section B.29, "POL__TBLUSAGE"

- Section B.30, "POL__TRIGGERS"

- Section B.31, "POL__VIEWS"

- Section B.32, "POL__USERS"

## B.1 ALL_COL_COMMENTS

Table B-1 ALL_COL_COMMENTS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`TABLE_NAME` | `VARCHAR(128)` | `NOT NULL` | Name of the table
`COLUMN_NAME` | `VARCHAR(128)` | `NOT NULL` | Name of the column
`COMMENTS` | `VARCHAR(4096)` | `NULL` | Description

## B.2 ALL_CONSTRAINTS

Table B-2 ALL_CONSTRAINTS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`CONSTRAINT_NAME` | `VARCHAR(128)` | `NOT NULL` | Constraint name
`CONSTRAINT_TYPE` | `VARCHAR(128)` | `NOT NULL` | Constraint type
`TABLE_NAME` | `VARCHAR(128)` | `NOT NULL` | Name of the table
`SEARCH_CONDITION` | `VARCHAR(1000)` | `NULL` | Search condition
`R_OWNER` | `VARCHAR(128)` | `NULL` | Owner of Referenced Primary Key Constraint
`R_CONSTRAINT_NAME` | `VARCHAR(128)` | `NULL` | Reference Name of Primary Constraint
`DELETE_RULE` | `VARCHAR(128)` | `NULL` | Delete rule
`STATUS` | `VARCHAR(20)` | `NOT NULL` | Status
`VALIDATED` | `VARCHAR(13)` | `NOT NULL` | Validated

## B.3 ALL_CONS_COLUMNS

Table B-3 ALL_CONS_COLUMNS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NULL` | Owner
`CONSTRAINT_NAME` | `VARCHAR(128)` | `NULL` | Constraint name
`TABLE_NAME` | `VARCHAR(128)` | `NULL` | Table name
`COLUMN_NAME` | `VARCHAR(128)` | `NULL` | Column name
`POSITION` | `VARCHAR(10)` | `NULL` | Position

## B.4 ALL_DEPENDENCIES

Table B-4 ALL_DEPENDENCIES Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(30)` | `NOT NULL` | Owner
`NAME` | `VARCHAR(30)` | `NOT NULL` | Name
`TYPE` | `VARCHAR(16)` | `NULL` | Type
`REFERENCED_OWNER` | `VARCHAR(30)` | `NULL` | Referenced owner
`REFERENCED_NAME` | `VARCHAR(30)` | `NOT NULL` | Referenced name
`REFERENCED_TYPE` | `VARCHAR(16)` | `NULL` | Referenced type

## B.5 ALL_INDEXES

Table B-5 ALL_INDEXES Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`INDEX_NAME` | `VARCHAR(128)` | `NOT NULL` | Index name
`TABLE_OWNER` | `VARCHAR(128)` | `NOT NULL` | Table owner
`TABLE_NAME` | `VARCHAR(128)` | `NOT NULL` | Table name
`TABLE_TYPE` | `VARCHAR(10)` | `NULL` | Table type
`UNIQUENESS` | `VARCHAR(128)` | `NOT NULL` | Index Uniqueness

## B.6 ALL_IND_COLUMNS

Table B-6 ALL_IND_COLUMNS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`INDEX_OWNER` | `VARCHAR(128)` | `NOT NULL` | Index owner
`INDEX_NAME` | `VARCHAR(128)` | `NOT NULL` | Index name
`TABLE_OWNER` | `VARCHAR(128)` | `NOT NULL` | Table owner
`TABLE_NAME` | `VARCHAR(128)` | `NOT NULL` | Table name
`COLUMN_NAME` | `VARCHAR(128)` | `NOT NULL` | Column name
`COLUMN_POSITION` | `VARCHAR(10)` | `NOT NULL` | Column position

## B.7 ALL_OBJECTS

Table B-7 ALL_OBJECTS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`OBJECT_NAME` | `VARCHAR(128)` | `NOT NULL` | Object name
`OBJECT_TYPE` | `VARCHAR(128)` | `NULL` | Object type
`CREATED` | `DATE` | `NULL` | When object was created
`STATUS` | `VARCHAR(128)` | `NULL` | Status

## B.8 ALL_PRIVILEGES

Table B-8 ALL_PRIVILEGES Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`SCHEMA` | `VARCHAR(128)` | `NOT NULL` | Schema
`TABLE` | `VARCHAR(128)` | `NOT NULL` | Table
`COLUMN` | `NUMBER(11)` | `NOT NULL` | Column
`GRANTOR1` | `VARCHAR(128)` | `NOT NULL` | Grantor
`GRANTEE1` | `UNKNOWN(8)` | `NOT NULL` | Grantee
`OBJTYPE` | `TINYINT(3)` | `NOT NULL` | Object type
`GTYPE` | `TINYINT(3)` | `NOT NULL` | Grant type
`GTABLE` | `TINYINT(3)` | `NOT NULL` | Grant table
`TO` | `UNKNOWN(8)` | `NOT NULL` | Not used

## B.9 ALL_SEQUENCES

Table B-9 ALL_SEQUENCES Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`SEQUENCE_OWNER` | `VARCHAR(128)` | `NOT NULL` | Sequence owner
`SEQUENCE_NAME` | `VARCHAR(128)` | `NOT NULL` | Sequence name
`MIN_VALUE` | `VARCHAR(10)` | `NOT NULL` | Minimum value
`MAX_VALUE` | `VARCHAR(10)` | `NOT NULL` | Maximum value
`INCREMENT_BY` | `VARCHAR(10)` | `NOT NULL` | Increment value for sequence

## B.10 ALL_SYNONYMS

Table B-10 ALL_SYNONYMS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NULL` | Owner
`SYNONYM_NAME` | `VARCHAR(128)` | `NULL` | Synonym name
`TABLE_OWNER` | `VARCHAR(128)` | `NULL` | Table owner
`TABLE_NAME` | `VARCHAR(128)` | `NULL` | Table name
`DB_LINK` | `VARCHAR(128)` | `NULL` | Database link

## B.11 ALL_TABLES

Table B-11 ALL_TABLES Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`TABLE_NAME` | `VARCHAR(128)` | `NOT NULL` | Table name
`TABLESPACE_NAME` | `VARCHAR(128)` | `NULL` | Tablespace name
`CLUSTER_NAME` | `VARCHAR(128)` | `NULL` | Cluster name
`PCT_FREE` | `NUMBER(10)` | `NULL` | Minimum percentage of free space in a block
`PCT_USED` | `NUMBER(10)` | `NULL` | Minimum percentage of used space in a block. Note: If the space in data block is less than PCT_FREE, no new rows will be added in that block until amount of space in table is less than PCT_USED
`INI_TRANS` | `NUMBER(10)` | `NULL` | Initial number of transactions
`MAX_TRANS` | `NUMBER(10)` | `NULL` | Maximum number of transactions
`INITIAL_EXTENT` | `NUMBER(10)` | `NULL` | Set of Contiguous blocks in a database segment that is automatically allotted when a segment is created
`NEXT_EXTENT` | `NUMBER(10)` | `NULL` | Block allocated after initial extent
`MIN_EXTENTS` | `NUMBER(10)` | `NULL` | Minimum number of extents allowed in the segment
`MAX_EXTENTS` | `NUMBER(10)` | `NULL` | Maximum extent that can be allocated
`PCT_INCREASE` | `NUMBER(10)` | `NULL` | Default percentage increase in extent size
`BACKED_UP` | `VARCHAR(1)` | `NULL` | Has table being backed up since last modification
`NUM_ROWS` | `NUMBER(10)` | `NULL` | Number of rows
`BLOCKS` | `NUMBER(10)` | `NULL` | Number of used blocks in the table
`EMPTY_BLOCKS` | `NUMBER(10)` | `NULL` | Number of empty blocks in the table
`AVG_SPACE` | `NUMBER(10)` | `NULL` | Average available free space in the table
`CHAIN_CNT` | `NUMBER(10)` | `NULL` | Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid
`AVG_ROW_LEN` | `NUMBER(10)` | `NULL` | Average row length, including row overhead

## B.12 ALL_TAB_COLUMNS

Table B-12 ALL_TAB_COLUMNS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`TABLE_NAME` | `VARCHAR(128)` | `NOT NULL` | Table name
`COLUMN_NAME` | `VARCHAR(128)` | `NOT NULL` | Column name
`DATA_TYPE` | `VARCHAR(30)` | `NULL` | Data type
`DATA_LENGTH` | `NUMBER(10)` | `NULL` | Data length
`DATA_PRECISION` | `NUMBER(10)` | `NULL` | Data precision
`DATA_SCALE` | `NUMBER(10)` | `NULL` | Data scale
`NULLABLE` | `VARCHAR(1)` | `NULL` | Nullable
`COLUMN_ID` | `NUMBER(10)` | `NOT NULL` | Column ID
`DEFAULT_LENGTH` | `NUMBER(10)` | `NULL` | Default length
`DATA_DEFAULT` | `VARCHAR(4096)` | `NULL` | Default value for column
`NUM_DISTINCT` | `NUMBER(10)` | `NULL` | Number of distinct values this column holds
`LOW_VALUE` | `NUMBER(10)` | `NULL` | Low value
`HIGH_VALUE` | `NUMBER(10)` | `NULL` | High value
`IS_HIDDEN` | `VARCHAR(1)` | `NULL` | If item is hidden

## B.13 ALL_TAB_COMMENTS

Table B-13 ALL_TAB_COMMENTS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`TABLE_NAME` | `VARCHAR(128)` | `NOT NULL` | Table name
`TABLE_TYPE` | `VARCHAR(128)` | `NOT NULL` | Table type
`COMMENTS` | `VARCHAR(4096)` | `NOT NULL` | Description

## B.14 ALL_USERS

Table B-14 ALL_USERS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`USERNAME` | `VARCHAR(30)` | `NOT NULL` | Username
`USER_ID` | `NUMBER(11)` | `NOT NULL` | User ID
`CREATED` | `DATE` | `NOT NULL` | When user was created

## B.15 ALL_VIEWS

Table B-15 ALL_VIEWS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`VIEW_NAME` | `VARCHAR(128)` | `NOT NULL` | View name
`TEXT_LENGTH` | `NUMBER(10)` | `NOT NULL` | Text length
`TEXT` | `VARCHAR(1000)` | `NOT NULL` | Text

## B.16 POL__ALLOBJ

Table B-16 POL__ALLOBJ Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`CATALOG_NAME` | `VARCHAR(128)` | `NOT NULL` | Catalog name
`SCHEMA_NAME` | `VARCHAR(128)` | `NOT NULL` | Schema name
`OBJECT_NAME` | `VARCHAR(128)` | `NOT NULL` | Object name
`OBJECT_ID` | `NUMBER(10)` | `NOT NULL` | Object ID
`OBJECT_TYPE` | `SMALLINT(5)` | `NOT NULL` | Object type
`CREATED` | `DATE` | `NOT NULL` | Date when created
`LAST_DDL_TIME` | `DATE` | `NOT NULL` | Timestamp for the last modification of the object resulting from a DDL command

## B.17 POL__COLUSAGE

Table B-17 POL__COLUSAGE Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`COLUMN` | `VARCHAR(128)` | `NOT NULL` | Column
`TBLUSAGEREF` | `UNKNOWN(8)` | `NOT NULL` | Reference to its POL__TBLUSAGE object
`POSITION` | `NUMBER(11)` | `NOT NULL` | Column position in Constraint definition. Used to identify order of column in the key

## B.18 POL__COMMENT

Table B-18 POL__COMMENT Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`COLREF` | `UNKNOWN(8)` | `NOT NULL` | Column Reference
`COMMENTS` | `VARCHAR(4096)` | `NOT NULL` | Comment

## B.19 POL__CONS

Table B-19 POL_CONS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`CATALOG` | `VARCHAR(128)` | `NOT NULL` | Catalog
`SCHEMA` | `VARCHAR(128)` | `NOT NULL` | Schema
`CONSTRAINT` | `VARCHAR(128)` | `NOT NULL` | Constraint
`TYPE` | `NUMBER(11)` | `NOT NULL` | Type
`TBLCONS` | `UNKNOWN(8)` | `NOT NULL` | Reference to POL__TBLCONS that points to constrained table
`ASSERTCONS` | `UNKNOWN(8)` | `NOT NULL` | Reserved
`DOMAINCONS` | `UNKNOWN(8)` | `NOT NULL` | Reserved
`FLAGS` | `NUMBER(11)` | `NOT NULL` | For update rules
`TO` | `UNKNOWN(8)` | `NOT NULL` | Used by foreign key constraint to point to parent table primary key constraint object
`EXTENSIONS` | `TINYINT(3)` | `NOT NULL` | Not used

## B.20 POL__DATABASE_PARAMETERS

Table B-20 POL__DATABASE_PARAMETERS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`PARAMETER` | `VARCHAR(30)` | `NOT NULL` | Parameter
`TYPE` | `TINYINT(3)` | `NOT NULL` | Type
`VALUE` | `VARCHAR(128)` | `NULL` | Value

## B.21 POL__INDICES

Table B-21 POL__INDICES Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`CATALOG_NAME` | `VARCHAR(128)` | `NOT NULL` | Catalog name
`SCHEMA_NAME` | `VARCHAR(128)` | `NOT NULL` | Schema name
`INDEX_NAME` | `VARCHAR(128)` | `NOT NULL` | Index name
`TABLE_SCHEMA` | `VARCHAR(128)` | `NOT NULL` | Table schema
`TABLE_NAME` | `VARCHAR(128)` | `NOT NULL` | Table name
`FLAGS` | `NUMBER(11)` | `NOT NULL` | Options for Index
`INDEXOBJ` | `UNKNOWN(8)` | `NOT NULL` | Index object
`EXTENSIONS` | `TINYINT(3)` | `NOT NULL` | Not used

## B.22 POL__INDICESDT

Table B-22 POL__INDICESDT Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`COLUMN_NAME` | `VARCHAR(128)` | `NOT NULL` | Column name
`DIRECTION` | `TINYINT(3)` | `NOT NULL` | Ascending or descending direction
`INDEX_POSITION` | `NUMBER(10)` | `NOT NULL` | Relative position in index
`MASTER` | `UNKNOWN(8)` | `NOT NULL` | Master index table
`EXTENSIONS` | `TINYINT(3)` | `NOT NULL` | Not used

## B.23 POL__PROCEDURES

Table B-23 POL__PROCEDURES Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`CATALOG_NAME` | `VARCHAR(128)` | `NOT NULL` | Catalog name
`SCHEMA_NAME` | `VARCHAR(128)` | `NOT NULL` | Schema name
`PROCEDURE_NAME` | `VARCHAR(128)` | `NOT NULL` | Procedure name
`TABLE_CLASS` | `UNKONWN(8)` | `NOT NULL` | Table class
`PROCEDURE_TYPE` | `SMALLINT(5)` | `NOT NULL` | Procedure type
`PROCEDURE_REF` | `UNKNOWN(8)` | `NOT NULL` | Procedure reference

## B.24 POL__PROCEDURE_COLUMNS

Table B-24 POL__PROCEDURE_COLUMNS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`MASTER` | `UNKNOWN(8)` | `NOT NULL` | Master Index table
`COLUMN_TYPE` | `SMALLINT(5)` | `NOT NULL` | Column type
`DATA_TYPE` | `SMALLINT(5)` | `NOT NULL` | Data type
`TYPE_NAME` | `VARCHAR(128)` | `NOT NULL` | Type name
`PRECISION` | `NUMBER(10)` | `NOT NULL` | Significant digits for Column
`LENGTH` | `NUMBER(10)` | `NOT NULL` | Length
`SCALE` | `SMALLINT(5)` | `NOT NULL` | Significant digits right of decimal
`RADIX` | `SMALLINT(5)` | `NOT NULL` | Base of the system
`POSITION` | `SMALLINT(5)` | `NOT NULL` | Position

## B.25 POL__SCHEMATA

Table B-25 POL__SCHEMATA Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`NAME` | `VARCHAR(128)` | `NOT NULL` | Name
`OWNER` | `VARCHAR(128)` | `NOT NULL` | Owner
`SCHEMA_ID` | `NUMBER(11)` | `NOT NULL` | Schema ID
`CREATED` | `DATE` | `NOT NULL` | Date when created

## B.26 POL__SEQ

Table B-26 POL__SEQ Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`SCHEMA_NAME` | `VARCHAR(128)` | `NOT NULL` | Schema name
`SEQ_NAME` | `VARCHAR(128)` | `NOT NULL` | Sequence name
`SEQ_REF` | `UNKNOWN(8)` | `NOT NULL` | Sequence reference
`INC_BY` | `NUMBER(10)` | `NOT NULL` | Increment by value
`START_WITH` | `NUMBER(10)` | `NOT NULL` | Number to start sequence with
`MIN_VALUE` | `NUMBER(10)` | `NOT NULL` | Minimum value for sequence
`MAX_VALUE` | `NUMBER(10)` | `NOT NULL` | Maximum value for sequence
`IS_ACCESSED` | `TINYINT(3)` | `NOT NULL` | if accessed

## B.27 POL__SYNONYM

Table B-27 POL__SYNONYM Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`SYN` | `VARCHAR(128)` | `NOT NULL` | Synonym
`OBJECT` | `VARCHAR(128)` | `NOT NULL` | Object

## B.28 POL__TBLCONS

Table B-28 POL__TBLCONS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`CATALOG` | `VARCHAR(128)` | `NOT NULL` | Fully qualified database file name
`SCHEMA` | `VARCHAR(128)` | `NOT NULL` | Schema
`TABLE` | `VARCHAR(128)` | `NOT NULL` | Table
`CONSREF` | `UNKNOWN(8)` | `NOT NULL` | Reference to POL__CONS object
`FLAGS` | `NUMBER(11)` | `NOT NULL` | Reserved
`TYPE` | `NUMBER(11)` | `NOT NULL` | Type
`SEARCH` | `VARCHAR(128)` | `NOT NULL` | Used by Check constraint to store user constraint string
`SEARCHTREE` | `TINYINT(3)` | `NOT NULL` | Internal representation of constraint clause
`EXTENSIONS` | `TINYINT(3)` | `NOT NULL` | Not used
`CLASSREF` | `UNKNOWN(8)` | `NOT NULL` | Reference to Class Object for the table
`GROUPREF` | `UNKNOWN(8)` | `NOT NULL` | Reference to Group Object for the table

## B.29 POL__TBLUSAGE

Table B-29 POL_TBLUSAGE Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`CATALOG` | `VARCHAR(128)` | `NOT NULL` | Catalog
`SCHEMA` | `VARCHAR(128)` | `NOT NULL` | Schema
`TABLE` | `VARCHAR(128)` | `NOT NULL` | Table
`TBLCONSREF` | `UNKNOWN(8)` | `NOT NULL` | Reference to POL__TBLCONS Object
`DOMCONSREF` | `UNKNOWN(8)` | `NOT NULL` | Not used
`ASSERTCONSREF` | `UNKNOWN(8)` | `NOT NULL` | Not used
`EXTENSIONS` | `TINYINT(3)` | `NOT NULL` | Not used

## B.30 POL__TRIGGERS

Table B-30 POL__TRIGGERS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`TRIGGER_NAME` | `VARCHAR(128)` | `NOT NULL` | Trigger name
`TABLE_CLASS` | `UNKNOWN(8)` | `NOT NULL` | Table class
`TRIGGER_KIND` | `SMALLINT(5)` | `NOT NULL` | Trigger kind
`METHOD` | `UNKNOWN(8)` | `NOT NULL` | Method

## B.31 POL__VIEWS

Table B-31 POL__VIEWS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`NAME` | `VARCHAR(30)` | `NOT NULL` | View name
`VIEWDEF` | `VARCHAR(128)` | `NOT NULL` | View definition
`POSMAPS` | `NUMBER(11)` | `NOT NULL` | Position Map

## B.32 POL__USERS

Table B-32 POL__USERS Parameters

Column | Datatype | Null | Description
--- | --- | --- | ---
`USERNAME` | `VARCHAR(30)` | `NOT NULL` | User name
`PASSWORD` | `VARCHAR(30)` | `NOT NULL` | Password
`USER_ID` | `NUMBER(11)` | `NOT NULL` | User ID
`CREATED` | `DATE` | `NOT NULL` | Date when created