Questions tagged [naming-convention]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
45 views

Is there a good reason to put the company name at the beginning of the table names? [closed]

When developing a new system, for a big corporation. Technologies: Web, Java, Spring Boot, Rest Api, Postgres, Hibernate Company: Bank System: Promissory control, and all others Company name: ...
0
votes
1answer
48 views

PostgreSQL naming conventions

Maybe double post but I could not find any answer here. I saw couple of posts how to name my tables and I understood that (semi-officially) it should contain lower cases, should be underscored and ...
1
vote
0answers
25 views

Redundancy in table names / Table naming convensions

I am creating some templates in my database that users would be able to use to help set up some of their data. For example, I have the following tables (simplified of course): store (id, store_name)...
3
votes
2answers
198 views

SQL table with same name as catalog view

When naming tables in SQL I try to stay away from SQL reserved keywords, but today a colleague questioned the use of Events as a table name. They said, anything that turns green in SSMS shouldn't be ...
0
votes
0answers
36 views

Schema Master, Schema, Scheme - table name/design help

I’m stuck! 3 table names. Schema Master, Schema, Scheme. They are too confusing for me I always get them mixed up.... Any ideas on how to name better? I also maybe designing this database ...
1
vote
1answer
198 views

Naming Convention for Login, User and Roles? [closed]

What are the Naming Conventions for a Login, A database User and a Database role? Is there any best practice to follow?
0
votes
2answers
37 views

Column names - (created, modified) vs. (creation, modification) [closed]

I have a database schema where all the tables are required to have a column to hold the timestamp for the initial INSERT and another column that holds the timestamp of the last UPDATE. Initially this ...
0
votes
2answers
131 views

Can any database table name support double quotes "?

I need to know whether any database supports double quotes as a part of their table name. I am especially interested in JDBC compliant databases. And if they do, can I please know how?
0
votes
1answer
192 views

How to name tables such as “Suppliers Categories” [closed]

I am refactoring a very old DB (< 2001) migrating from MyISAM to InnoDB and I experience some issues with the CamelCase notation. I don't know why but with the use of MySQL Workbench, sometime, my ...
0
votes
1answer
50 views

How do I fix the naming of columns in Metabase?

Metabase currently imports the column names and tries to figure out the wording. This convention is fundamentally broken in my schema. For example, when it scans my PostgreSQL database it'll bring in ...
0
votes
0answers
24 views

What is the naming convention where column names are prefixed by chars indicating the data type?

I work on a database where column names are prefixed by a character representing the datatype of the column. I quite like this, because it's easy to see at a glance what type of data each column holds....
0
votes
1answer
66 views

Comparing SQL binary data types

I am curious if there are any major differences with performance and/or conventionality regarding which binary data types one chooses. Let's say I have a table of metallic objects and I am considering ...
0
votes
0answers
15 views

Name of attributes that are indirectly related to entity

If I have a set of data that relate to an entity directly and some that do not, is there a standard name for these two types of attributes? example, Employee: employeeID firstname lastname manager ...
1
vote
0answers
70 views

ERD mostly in text

In LaTeX I can replicate database tables similar to the ones in the diagram below, but I do not want to deal with figuring out how to nicely draw the relation diagrams between the tables. Is there an ...
1
vote
1answer
48 views

Recommended user ID column names to use

I use user IDs a lot in tables, and I would like to find out when naming these columns, what's the best way to go about naming them. Should you be specific to what the user ID is, or should you keep ...
3
votes
2answers
5k views

MySQL database naming convention?

Is there any convention for database names in MySQL/MariaDB? I've searched Google and this Stack Exchange and haven't been able to find anything. Not even a "Nope, there's no official convention." Is ...
2
votes
1answer
137 views

Does the SQL-1992 standard restrict naming identifiers to 18 characters?

In this draft of SQL:1992, I found… Section 5.2 Leveling Rules .... The following restrictions apply for Entry SQL in addition to any Intermediate SQL restrictions: a) No <...
1
vote
1answer
118 views

Data modelling for specific units of measurement

I am currently adding a feature in our software where we save a timeout in the database to initialize cronjobs which get active after that timeout. To model this I see different ways but can't say ...
6
votes
3answers
1k views

What is the significance of the trailing dollar sign `$` on identifiers in SQL Server?

Dumping some internal views, such as sys.system_objects as done in this question I see that some identifiers end with a dollar-sign $ CREATE VIEW sys.system_objects AS -- cutout FROM sys....
5
votes
2answers
446 views

Is there a name for the class of characters represented by [] in SQL Server?

I am interested in the terminology for the characters you can put around table names, column names, etc. when referencing them in a query. A name that in Microsoft SQL Server would be for []s and in ...
2
votes
4answers
3k views

MySQL similar name for status or type column

As status and type is reserved key in MySQL, I need a column name similar to status to identify the status of a row. I know there is way to ignore this problem but in different language and different ...
0
votes
1answer
50 views

What's the recommended way to handle naming collisions with the PK column? [closed]

I have a data field "Shipment ID" which is a VARCHAR(18) from a number of different vendors. This is going into a table shipment with a surrogate PK shipment_id. I'm trying to figure out the best way ...
10
votes
1answer
324 views

Issue with Table Naming Conventions and Policy Management in SQL Server 2016

In SQL Server 2012, I had a policy set to not allow spaces in a table name. However, when I use the same policy in SQL Server 2016, I get an error. Here is the code for the condition: DECLARE @...
0
votes
2answers
147 views

Change naming conventions in SQL Server

In SQL Server 2014 we need to change naming convention for indexes and keys. The old naming convention is not following any standards. My questions are: How can we change the naming convention for ...
1
vote
1answer
58 views

Naming convention for automated table outputs (processed with Python)

I have several tables that I process nightly with Python. For example, I have read-only access to an incidents table. I process the table with a specialized Python library called ArcPy. The script ...
1
vote
1answer
72 views

Dependency management by decoupling table name from table key

If I share a Google Spreadsheet with someone, I will share a link like this: https://docs.google.com/spreadsheets/d/1UL0Aii1aaErbUm6pdmZ_D9dsqx2p3BPZ5GHxz7TH37M/edit This means that I am free to ...
3
votes
1answer
2k views

CREATE VIEW as join between tables with identically named columns

As the title says, I'd like to create a view from a join between tables which have columns with identical names (surprisingly "id"). Postgres doesn't prepend the table name to the result, but for ...
92
votes
19answers
27k views

Is adding the ‘tbl’ prefix to table names really a problem?

I’m watching some Brent Ozar videos (like this one, for instance) and he suggests not prefixing tables with ‘tbl’ or ‘TBL’. On the internet I found some blogs saying it adds nothing to documentation,...
1
vote
2answers
506 views

How to Apply a Title-Case RegEx Condition for Object Names with Policy Based Management

I'm implementing PBM on a SQL Server 2014 instance and want to enforce a condition that all objects are created outside the dbo schema and all object names are created in title-case (i.e., OrderDetail)...
2
votes
3answers
1k views

Best name for link table [closed]

I was wondering what the best name for a linked table in this situation (or any) would be. I've searched for this, but could not find any concrete examples. For example, I have the following tables (...
1
vote
1answer
98 views

Standard naming for a credential systems

Is there a standard naming convention in regards to credential oriented systems? (Logins) The only one I could really come up with (in a shorthand form) is using the word "Gateway". Representing a ...
16
votes
1answer
4k views

Naming conflict between function parameter and result of JOIN with USING clause

Given this setup in current Postgres 9.4 (from this related question): CREATE TABLE foo (ts, foo) AS VALUES (1, 'A') -- int, text , (7, 'B'); CREATE TABLE bar (ts, bar) AS VALUES (3, 'C') ...
1
vote
1answer
1k views

How do I open an ERwin Naming Standards file (.nsm) in Excel?

I have a Naming Standards file in ERwin (.nsm format) that I want to be able to open up in Excel (for example, in order to compare 2 .nsm files). How would I be able to do that?
1
vote
1answer
71 views

Comparing the contents of 2 .nsm (naming standards) files

I have 2 naming standards files from ERwin (.nsm extension), and I want to compare them to see if they contain the same rules. Is there some sort of automated way to check this? If there isn't a way ...
0
votes
1answer
69 views

Naming a second additional column referencing another table column?

I'm working with a table in database that references to a column in another table. Such as: Product Table ------------ Id Description Currencies_Code Currencies ------------ Id Code Description We ...
3
votes
1answer
2k views

What problems would using the reserved keywords DATE and TIME as column names cause in Oracle?

DATE is an SQL Reserved Word and TIME is a PL/SQL Reserved Word in Oracle (listed in SQL> HELP RESERVED WORDS). What problems would using them as column names cause in Oracle? The database server ...
1
vote
1answer
740 views

Which terms are used to refer a row in database?

I am creating a Java application, in which I want to create a class that will relate to a row in database. I decided to use Entity while naming the class with a prefix/suffix. But, This page says: ...
0
votes
1answer
142 views

How to reference a table called `\` (simply just backslash character) in MySQL in a query?

Through some unknown circumstances I have a table called "\" in a database. mysql> show tables like '\\'; +-----------------------------+ | Tables_in_in_realestate (\) | +--------------------------...
1
vote
0answers
129 views

Named a table “order” in Microsoft Office Access database and the webapp now can't see the table (even after renaming it)

I am creating a web application in Dreamweaver using ASP VBScript. The web application is a store and I have to implement a database into it (which I did). I created a table in my database called ...
0
votes
1answer
36 views

How do I call a collection of tables with normalized (generic) information

In a database design there are many fields with information that needs to be normalized. For instance for an address record countries can be normalized but also the address type (i.e. private address, ...
4
votes
1answer
339 views

Normalized Data Store - Confused with prefixes to use

I'm designing a Staging+NDS+DDS Data Warehouse system, where an ETL is going to normalize data from [Staging] and load it into [NDS], which will hold all history. I've pretty much finished the T-SQL ...
1
vote
1answer
1k views

database roles name convention [closed]

i want to ask if there is any name convention for sql server database roles, what is best practise or what i should follow. We have databases and a lot of people and i want to suggest some rules. ...
1
vote
2answers
2k views

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 ...
2
votes
1answer
727 views

select query on unique column AND alternate column of “aliases”

I have a MySQL table (~10,000 rows) with a pk id (int) column and a name (varchar) column (as well as a few other unimportant columns for this question). The name column contains unique values that ...
1
vote
2answers
122 views

Why WordPress use a column prefix? [closed]

I'm trying to learn some basic database design through open source projects. And look into the WordPress database schema, the posts table for example, you'll find something like this post_author ...
13
votes
2answers
13k views

Official PostgreSQL Capitalization conventions [closed]

Is there an official PostreSQL convention regarding capitalization in DB, Table and field names? The examples on the official site suggest a lowercase and _ word separation, and I wonder whether this ...
1
vote
1answer
170 views

How should I entitle date columns? [duplicate]

Is there any convenience in name date-time related columns? created and delivered, … or createdTS, deliveredTS or createdAt, deliveredAt or…
1
vote
1answer
223 views

Name for SELECT equivalent of UPSERT

UPSERT means INSERT and\or UPDATE, is there a standard name for a stored procedure that will INSERT if necessary and then SELECT? e.g. I want to get the IS of a row that matches columns and give me ...
1
vote
0answers
85 views

Naming convention for columns with same name (but different logically)?

How do I name columns in my database tables which have the same name in outside world but are logically separated? Lets say an example Company Share: 100% of 50% Now I have two company shares: ...
3
votes
1answer
2k views

Does the length of a table name affect performance?

PostgreSQL table names are limited to 63 chars. Is there a performance gain to be had if I limit my table names to something like 5 chars or can I use the full 63 chars without consequence? I ...