python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - primary-key

Adding a foreign key constraint referencing to primary key columns

I am applying a foreign key constraint to a table(datareal.official). Should I always refer to the same columns in the primary key of the other tabel (datareal.officialcarriage). Or could I theoretica...
test-img

hering

sql

foreign-keys

constraints

primary-key

Votes: 0

Answers: 0

PostgreSQL User table, benefits of user_id?

I am creating a table to store my user's info in a psql database, what are the benefits of saving a serialized user_id if the username has to be unique. In other words, why cant the username be the pr...
test-img

Arishoham

sql

postgresql

primary-key

Votes: 0

Answers: 2

Latest Answer

why cant the username be the primary key? While it should be unique, it's not suitable as a primary key in this case. In general, primary key values should never change. Any user provided value is h...
test-img

a_horse_with_no_name

How to create auto generated primary key for string in Spring JPA?

I want to create a primary key of String type, which will be auto-generated by Spring JPA. I want that the primary key should start with "USER****" and it should be of uniform length. e.g. U...
test-img

DEV_BOT

java

spring

spring-data-jpa

primary-key

Votes: 0

Answers: 0

UUID and auto increment INT as primay key for diffrent tables in one db

I have a database with about 100 tables, I want to add REST API requests connected with some tables. I don't want to expose id from the database directly to the request so I want to change PK (primary...
test-img

David

mysql

primary-key

uuid

auto-increment

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs