CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text ); code example

Example 1: CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );

CREATE TABLE annotation (
 annotationid serial PRIMARY KEY,
 paragraphid int references paragraph(paragraphid),
 notes varchar,
 researcherid int references researcher(reasearcherid)
);

Example 2: CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );

CREATE TABLE researcher (
  researcherid serial PRIMARY KEY,
  name text
);

Tags:

Sql Example

Related