<commit_before>```sql
DROP TABLE IF EXISTS Sub_Datasets CASCADE;


-- SCHEMA
CREATE TABLE Sub_Datasets (

    -- General
	dataset_id SERIAL PRIMARY KEY,
    created TIMESTAMP WITH TIME ZONE NOT NULL,
    updated TIMESTAMP WITH TIME ZONE NOT NULL,

    -- Attributes
	metadata_id INTEGER REFERENCES Metadata (metadata_id) ON UPDATE CASCADE ON DELETE CASCADE
    dataset_name CHARACTER VARYING(255) NOT NULL,
    dataset_description CHARACTER VARYING(255) NOT NULL,
);


-- EXAMPLE-DATA

-- EnviroCar API
INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 1, 'Tracks', 'The Tracks endpoint');

INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 1, 'Phenomenons', 'The Phenomenons endpoint');

INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 1, 'Sensors', 'The Sensors endpoint');

INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 1, 'Groups', 'The Groups endpoint');

INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 1, 'Users', 'The Users endpoint');

INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 1, 'Measurements', 'The Measurements endpoint');


-- OCT API (Connectors & Queries)
INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 2, 'Sensors', 'The Measurements table');

INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 2, 'Water Bodies', 'The Water Bodies table');

INSERT INTO Sub_Datasets (created, updated, metadata_id, dataset_name, dataset_description)
VALUES (now(), now(), 2, 'Water gauges', 'The Measurements table');

```<commit_msg>Updated Sub_Datasets-Schema<commit_after>```sql
DROP TABLE IF EXISTS Sub_Datasets CASCADE;


-- SCHEMA
CREATE TABLE Sub_Datasets (

    -- General
	sd_id SERIAL PRIMARY KEY,
    created TIMESTAMP WITH TIME ZONE NOT NULL,
    updated TIMESTAMP WITH TIME ZONE NOT NULL,

    -- Attributes
	md_id INTEGER REFERENCES Main_Datasets (md_id) ON UPDATE CASCADE ON DELETE CASCADE
    md_name CHARACTER VARYING(255) NOT NULL,
    md_description CHARACTER VARYING(255) NOT NULL
);


-- EXAMPLE-DATA
INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 1, 'Sensors', 'The Sensors table');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 1, 'Water Bodies', 'The Shapes table');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 1, 'Water Gauges', 'The Measurements table');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 2, 'Family', 'The Families table');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 2, 'Genus', 'The Genera table');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 2, 'Specie', 'The Species table');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 3, 'Tracks', 'The Tracks endpoint');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 3, 'Phenomenons', 'The Phenomenons endpoint');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 3, 'Sensors', 'The Sensors endpoint');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 3, 'Groups', 'The Groups endpoint');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 3, 'Users', 'The Users endpoint');

INSERT INTO Sub_Datasets (created, updated, md_id, md_name, md_description)
VALUES (now(), now(), 3, 'Measurements', 'The Measurements endpoint');
```
{'fraction_non_alphanumeric': 0.12496960855823, 'fraction_numerical': 0.008023340627279359, 'mean_word_length': 6.105354058721934, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2337504', 'n_tokens_mistral': 1397, 'n_tokens_neox': 1325, 'n_words': 454}