#AskPrisma I have read the doc where postgres support table inheritance, now I dont know how do we do it in prisma schema??

@Ian 👋 Currently we do not support inheritance. It would be great if you could create a feature request for this here 🙂

Thanks, just a follow up question the brute force practice available right now to achieve this is to just add a discriminator in the table and laid out all the fields right?

Yup I think that’s the only way. One interesting feature request we already have that’s similar to what you want is here that you could have a look at.

Thanks for assisting. Im coming from mongoose and prisma makes me feels like Ill never look back. Thanks!!!

We are also creating a MongoDB adaptor (still in preview) but you can signup for that here 😄

One last question haha Is there a guidance when to use auto inc vs cuid and uuid?? I mean when do you use is what .. Could be good if the docs had a rule of thumb about this

I don’t think that there’s any rule of thumb to this. UUID’s are generally preferable as they mask the no. of records that you have. Auto inc id’s if used usually give out that info.

In your personal pref what would you recommend to me?

Any specific reason you need a

toJson

?

We have a practice in orm like mongoose/typeorm/mikroorm where there is transform or toJson annotation like where you can mask the

ObjectId

so you dont return the object id of database instead hash by using

HashIds

package...

You can directly select fields like this.