Is 'type' a reserved word?


#1

I’d like to my a ‘type’ column in my database. Will this create a
problem? thanks.


#2

I’d like to my a ‘type’ column in my database. Will this create a
problem? thanks.

Yes, it’s used for STI. See here:


I think you can change it, but not sure how.

HTH,
Jordan


#3

Yup it is. I’ve run into this quite a bit, I just name my columns
“type_of” now.


#4

Not to be a curmudgeon, but it really is easy to just try using “type”
as a column name and see if you run into a problem. It probably takes
less time too.