schema.sql 641 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
CREATE TABLE IF NOT EXISTS phenotype (
  id                 VARCHAR(255) NOT NULL,
  created_date       BINARY(255),
  last_modified_date BINARY(255),
  phenotype_group    VARCHAR(255) NOT NULL,
  PRIMARY KEY (id)
);
CREATE TABLE IF NOT EXISTS property (
  id                 VARCHAR(255) NOT NULL,
  created_date       BINARY(255),
  description        TEXT         NOT NULL,
  last_modified_date BINARY(255),
  meaning            VARCHAR(255) NOT NULL,
  type               VARCHAR(255) NOT NULL,
  PRIMARY KEY (id)
);
17
CREATE TABLE IF NOT EXISTS registry_user (
18 19 20 21
  email VARCHAR(255) NOT NULL,
  role  VARCHAR(255),
  PRIMARY KEY (email)
);