Sfrgttk

Do VLANs within a subnet need to have their own subnet for router on a stick?

How to test if a transaction is standard without spending real money?

is the intersection of subgroups a subgroup of each subgroup

Test if tikzmark exists on same page

Why Is Death Allowed In the Matrix?

Are the number of citations and number of published articles the most important criteria for a tenure promotion?

Which models of the Boeing 737 are still in production?

Email Account under attack (really) - anything I can do?

Writing rule which states that two causes for the same superpower is bad writing

Today is the Center

How does one intimidate enemies without having the capacity for violence?

I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine

How can I make my BBEG immortal short of making them a Lich or Vampire?

What does "Puller Prush Person" mean?

TGV timetables / schedules?

To string or not to string

Dragon forelimb placement

How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?

What would happen to a modern skyscraper if it rains micro blackholes?

Have astronauts in space suits ever taken selfies? If so, how?

strToHex ( string to its hex representation as string)

Is it important to consider tone, melody, and musical form while writing a song?

Fencing style for blades that can attack from a distance

In Japanese, what’s the difference between “Tonari ni” (となりに) and “Tsugi” (つぎ)? When would you use one over the other?

What is the difference between a foreign key and a primary foreign key?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

1

I understand that you use foreign keys to relate rows from one table to the other and if this foreign key also becomes a primary key of that table then it is a primary foreign key.

But, for example, if a hotel records the date and time of check-ins for each customer, and each customer has a customer ID, should I include the customer ID as a primary foreign key or just a foreign key? Because at one time there can be multiple check-ins so date and time is not enough as a primary key?

database-design foreign-key primary-key uniqueidentifier

share

asked 52 secs ago

Sook LimSook Lim

81

New contributor

Sook Lim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

1

I understand that you use foreign keys to relate rows from one table to the other and if this foreign key also becomes a primary key of that table then it is a primary foreign key.

But, for example, if a hotel records the date and time of check-ins for each customer, and each customer has a customer ID, should I include the customer ID as a primary foreign key or just a foreign key? Because at one time there can be multiple check-ins so date and time is not enough as a primary key?

database-design foreign-key primary-key uniqueidentifier

share

asked 52 secs ago

Sook LimSook Lim

81

New contributor

Sook Lim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I understand that you use foreign keys to relate rows from one table to the other and if this foreign key also becomes a primary key of that table then it is a primary foreign key.

But, for example, if a hotel records the date and time of check-ins for each customer, and each customer has a customer ID, should I include the customer ID as a primary foreign key or just a foreign key? Because at one time there can be multiple check-ins so date and time is not enough as a primary key?

database-design foreign-key primary-key uniqueidentifier

share

asked 52 secs ago

Sook LimSook Lim

81

New contributor

Sook Lim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 52 secs ago

Sook LimSook Lim

81

New contributor

Sook Lim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 52 secs ago

Sook LimSook Lim

81

New contributor

Sook Lim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 52 secs ago

Sook LimSook Lim

81

New contributor

Sook Lim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 52 secs ago

Sook LimSook Lim

81