Usage of `@map` and `@@map` as a best practice to name tables and columns in a database

Say we have a legacy database somewhere that has its table names and column names.
One way to use

@map

@map

and

@@map

@@map

is to ensure that the names of our models and fields map to the names of the tables and columns, respectively in that database.

Apart from this use case, can I use these as a best practice whenever I am creating my Models where essentially a legacy database does not exist but I am building from scratch.

Example: When I define a Model named

Category

Category

and I use

model Category {
  id Int @id @default(autoincrement())
  name String
  posts Post[]

  @@map("categories")
}

model Category {
  id Int @id @default(autoincrement())
  name String
  posts Post[]

  @@map("categories")
}

Here the reason for using

@@map

@@map

is just to ensure that the new table created in my database has the name

categories

categories

.

Essentially, this way I am thinking about what names I can pick for the columns and tables in my real database.

Prisma•13mo ago•

3 replies

Abdullah Zeeshan

Usage of `@map` and `@@map` as a best practice to name tables and columns in a database

Say we have a legacy database somewhere that has its table names and column names.
One way to use

@map

@map

and

@@map

@@map

Category

Category

and I use

model Category {
  id Int @id @default(autoincrement())
  name String
  posts Post[]

  @@map("categories")
}

model Category {
  id Int @id @default(autoincrement())
  name String
  posts Post[]

  @@map("categories")
}

Here the reason for using

@@map

@@map

is just to ensure that the new table created in my database has the name

categories

categories

.

Essentially, this way I am thinking about what names I can pick for the columns and tables in my real database.

Usage of `@map` and `@@map` as a best practice to name tables and columns in a database

Similar Threads

Usage of `@map` and `@@map` as a best practice to name tables and columns in a database

Similar Threads

Similar Threads

Similar Threads