Open
Description
Is your feature request related to a problem? Please describe.
Currently multivalued slots are described in SQL DDL using first normal form join tables only.
Describe the solution you'd like
I would like a configurable feature to instead use arrays when using the postgresql dialect.
For example:
CREATE TABLE "Donor" (
birth_date DATE,
death_date DATE,
death_age INTEGER,
organism_type TEXT NOT NULL,
phenotypic_sex TEXT,
strain TEXT,
id TEXT NOT NULL,
name TEXT,
description TEXT,
image TEXT,
reported_ethnicity TEXT[],
PRIMARY KEY (id)
);COMMENT ON TABLE "Donor" IS 'A person or organism that is the source of a biosample.';COMMENT ON COLUMN "Donor".birth_date IS 'date of birth';COMMENT ON COLUMN "Donor".death_date IS 'date of death';COMMENT ON COLUMN "Donor".death_age IS 'age at death';COMMENT ON COLUMN "Donor".organism_type IS 'the type of organism, ideally the Linnean genus and species name, but also may be e.g. human, mouse, etc.';COMMENT ON COLUMN "Donor".strain IS 'strain of organism, for non-humans only, e.g. C57BL/6J';
How important is this feature? Select from the options below:
• Medium - can do work without it; but it's important (e.g. to save time or for convenience)
When will use cases depending on this become relevant? Select from the options below:
• Short-term - 2-4 weeks
Additional context
(https://obo-communitygroup.slack.com/archives/C04EU7JL1NF/p1694021239197999)
Metadata
Metadata
Assignees
Type
Projects
Status
Todo