sql server - How to make tables in a database -
I am creating a database about the cars that go around a certain road, so I created a table which is a car ID And the day the car crosses the special road car can pass millions of times by road, I know that to keep all the dates I need to make another table but I am confused. Please help. How should the database be shown
Without knowing what database you are using, I will assume that MS SQL Server / SQL Express should satisfy your requirements.
- Create personalized personalized store details table (identification id identification (1,1) primary key, Registration varchar (10), varchar (20), model varchar (50) - any other field here Add) Go - place passes through a "known" car About each time create a store description table (ID int identity (1,1) Primary key, CarID int is not zero, obstruction Sightings_FK_Car foreign key (carid) Reference car ( ID), add any other field to the current time)
Using the meaningless integer as the primary key on the tables is a personal choice. You can use a combination of some car registration and other time viewing time as the primary key on the first table, like the registration number of the car. I like the meaningful integer for the reasons for the execution.
Comments
Post a Comment