use code table structure

use code table structure#

THIS TABLE IS NOT CURRENTLY BEING USED BY POLARIS

Table Structure#
Field	Type	NULL allowed	Default Value
use_code*	TEXT	NO
rank	INTEGER	NO	0
routable	INTEGER	NO	0
subset_of	TEXT	YES	‘’
superset_of	TEXT	YES	‘’
alternative_labels	TEXT	YES	‘’
notes	TEXT	YES	‘’

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "Use_Code" (
    "use_code"             TEXT    NOT NULL,
    "rank"                 INTEGER NOT NULL DEFAULT 0,
    "routable"             INTEGER NOT NULL DEFAULT 0,
    "subset_of"            TEXT             DEFAULT '',
    "superset_of"          TEXT             DEFAULT '',
    "alternative_labels"   TEXT             DEFAULT '',
    "notes"                TEXT             DEFAULT '',
    PRIMARY KEY("use_code")
);