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 PRIMARY KEY,
    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 ''
);