nwb-linkml/nwb_schema_language/project/sqlschema/nwb_schema_language.sql

103 lines
2.1 KiB
MySQL
Raw Permalink Normal View History

2023-08-16 23:07:36 +00:00
2023-08-17 06:47:35 +00:00
CREATE TABLE "Attribute" (
name TEXT NOT NULL,
dims TEXT,
shape TEXT,
value TEXT,
default_value TEXT,
doc TEXT NOT NULL,
required BOOLEAN,
dtype TEXT,
PRIMARY KEY (name, dims, shape, value, default_value, doc, required, dtype)
);
CREATE TABLE "CompoundDtype" (
name TEXT NOT NULL,
doc TEXT NOT NULL,
dtype TEXT NOT NULL,
2023-08-17 06:47:35 +00:00
PRIMARY KEY (name, doc, dtype)
);
CREATE TABLE "Dataset" (
neurodata_type_def TEXT,
neurodata_type_inc TEXT,
2023-08-16 23:07:36 +00:00
name TEXT,
2023-08-17 06:47:35 +00:00
default_name TEXT,
dims TEXT,
shape TEXT,
value TEXT,
default_value TEXT,
doc TEXT NOT NULL,
quantity TEXT,
linkable BOOLEAN,
attributes TEXT,
dtype TEXT,
PRIMARY KEY (neurodata_type_def, neurodata_type_inc, name, default_name, dims, shape, value, default_value, doc, quantity, linkable, attributes, dtype)
2023-08-16 23:07:36 +00:00
);
2023-08-18 08:11:14 +00:00
CREATE TABLE "Datasets" (
datasets TEXT,
PRIMARY KEY (datasets)
);
2023-08-17 06:47:35 +00:00
CREATE TABLE "Group" (
neurodata_type_def TEXT,
neurodata_type_inc TEXT,
name TEXT,
default_name TEXT,
doc TEXT NOT NULL,
quantity TEXT,
linkable BOOLEAN,
attributes TEXT,
datasets TEXT,
groups TEXT,
links TEXT,
PRIMARY KEY (neurodata_type_def, neurodata_type_inc, name, default_name, doc, quantity, linkable, attributes, datasets, groups, links)
);
2023-08-18 08:11:14 +00:00
CREATE TABLE "Groups" (
groups TEXT,
PRIMARY KEY (groups)
);
2023-08-17 06:47:35 +00:00
CREATE TABLE "Link" (
2023-08-16 23:07:36 +00:00
name TEXT,
2023-08-17 06:47:35 +00:00
doc TEXT NOT NULL,
target_type TEXT NOT NULL,
quantity TEXT,
PRIMARY KEY (name, doc, target_type, quantity)
);
CREATE TABLE "Namespace" (
doc TEXT NOT NULL,
name TEXT NOT NULL,
full_name TEXT,
version TEXT NOT NULL,
2023-10-09 22:06:53 +00:00
date DATETIME,
2023-08-17 06:47:35 +00:00
author TEXT NOT NULL,
contact TEXT NOT NULL,
schema_ TEXT,
PRIMARY KEY (doc, name, full_name, version, date, author, contact, schema_)
2023-08-17 06:47:35 +00:00
);
CREATE TABLE "Namespaces" (
namespaces TEXT,
PRIMARY KEY (namespaces)
);
CREATE TABLE "ReferenceDtype" (
target_type TEXT NOT NULL,
reftype VARCHAR(9),
PRIMARY KEY (target_type, reftype)
2023-08-16 23:07:36 +00:00
);
2023-08-17 06:47:35 +00:00
CREATE TABLE "Schema" (
source TEXT,
namespace TEXT,
title TEXT,
neurodata_types TEXT,
2023-08-18 08:11:14 +00:00
doc TEXT,
PRIMARY KEY (source, namespace, title, neurodata_types, doc)
2023-08-16 23:07:36 +00:00
);