about giving same column name in every table of database I have a database with 5 tables.
In every table there is a column for checking status.
If i give the name to that column which is same in all the 5 tables; 
What will happen?
Is it correct according to conventions?
You can skip table name prefix in the status column, You can have all the tables with same column name and same datatype, that will make your naming uniform through out the tables in the database 

I have seen Database with 2000 of tables, and most of them have column status with  same datatype. TINYINT in our case.

Let say a query.

SELECT T1.columnName...., T2.Column,,...
FROM Table1 T1 
JOIN Table2 T2 ON .....
WHERE T1.Status = 1 and T2.Status =1


If the status column is only for row data active and inactive, you can choose datatype as bit or TINYINT incase you are looking to add more option in future