Introspection
Introspect your database with Prisma ORM
For the purpose of this guide, we'll use a demo SQL schema with three tables:
CREATE TABLE User (
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
name VARCHAR(255),
email VARCHAR(255) UNIQUE NOT NULL
);
CREATE TABLE Post (
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
title VARCHAR(255) NOT NULL,
createdAt TIMESTAMP NOT NULL DEFAULT now(),
content TEXT,
published BOOLEAN NOT NULL DEFAULT false,
authorId INTEGER NOT NULL,
FOREIGN KEY (authorId) REFERENCES User(id)
);
CREATE TABLE Profile (
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
bio TEXT,
userId INTEGER UNIQUE NOT NULL,
FOREIGN KEY (userId) REFERENCES User(id)
);
Expand for a graphical overview of the tables
User
Column name | Type | Primary key | Foreign key | Required | Default |
---|---|---|---|---|---|
id | INTEGER | ✔️ | No | ✔️ | autoincrementing |
name | VARCHAR(255) | No | No | No | - |
email | VARCHAR(255) | No | No | ✔️ | - |
Post
Column name | Type | Primary key | Foreign key | Required | Default |
---|---|---|---|---|---|
id | INTEGER | ✔️ | No | ✔️ | autoincrementing |
createdAt | DATETIME(3) | No | No | ✔️ | now() |
title | VARCHAR(255) | No | No |